Re: RMI from Java stored procedures

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