Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: RMI from Java stored procedures

Re: RMI from Java stored procedures

From: Sanjay Garg <SANGARG_at_prodigy.net>
Date: Sat, 4 Sep 1999 00:30:01 -0400
Message-ID: <7qq714$4t28$1@newssvr03-int.news.prodigy.com>


Is their a similar solution for JDBC application to receive message from DB2 database too.
Appreciate any input. Thanks.
Sanjay

doeni_at_evhr.net wrote in message ...
>
>This way is a bit trick.
>Don't forget that RMI is 100% pure java. Unless your C program calls
another
>Java program that in turn makes the RMI call.
>
>The simplest solution would probably be to use JDBC with the DBMS_PIPE
>package. The JDBC application receives the message through the pipe, and
> makes the RMI call.
>
>"C. Ferguson" <c_ferguson_at_rationalconcepts.com> writes:
>
>> Hi Joe,
>> maybe database trigger to external procedure to c routine that makes
the
>> socket connection to remote method? In 8.0.4 you can use pipes to get to
a c
>> method, or use the external procedure mechanism to make the c call which
can
>> then talk to the java process. I haven't done c to java, so you'll have
to do
>> some digging...
>> just some ideas.
>>
>> regards,
>> Cindy
>>
>> Joe Varghese wrote:
>>
>> > >
>> > >From 8.1.5 on, you can write stored procedures in Java.
>> > >You can also use the database as an EJB Server where you deploy your
>> > >Enterprise JavaBeans, or use the ORB inside of the DB to call CORBA
>> > >server objects.
>> > >
>> >
>> > thanks for the pointers. Unfortunately, I release I cannot use Java
stored
>> > procedures, as our database is 8.0.4 :(
>> >
>> > Do you (or anyone else) have other ideas? Again, the basic idea is to
call a
>> > Java RMI whenever the database has been updated ....
>> >
>> > Thanks
>> >
>> > joe
>>
>>
>
>--
>The fundamental aim of King Crimson is to organize anarchy, to utilize
> the latent power of chaos and to allow the varying influences to
> interact and find their own equilibrium.
> -Robert Fripp
Received on Fri Sep 03 1999 - 23:30:01 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US