1 Reply Latest reply: Jul 19, 2010 2:59 AM by EJP RSS

    Call remote PL/SQL procedure using Java Rmi

    843793


      I have to develop a web application to run remote PL/SQL batch program using Socket or Rmi.
      Since Batch program takes many hours, I have to restart WAS during Batch Program running.
      Because restarting WAS makes a session disconnect, I can not run the batch programs normally.
      To resolve this problem, is using socket or rmi ok? or, Please recommend other solutions if you have.
      Thank you all.




        • 1. Re: Call remote PL/SQL procedure using Java Rmi
          EJP
          1. You can't use RMI to talk to an application written in another language.

          2. You can use RMI/IIOP to talk to an application written in another language if:

          (a) the other application speaks CORBA
          (b) the other application is a CORBA client
          (c) your Java application is a CORBA server.

          3. If you can't meet those constraints, you would have to use Sockets directly with a home-grown protocol (be careful about word order, alignment, packing, slack bytes, etc), or XML-RPC, or SOAP, or some other high-level industry standard protocol.