Re: RMI from Java stored procedures

NOSPAM_at_NOSPAM.com (Joe Varghese) writes:

> Can you (or anyone else) post some books/articles/websites where I can learn
> more about Java stored procedures? Can an Oracle database have Java stored
> procedures?

Look at following URLs to get some white papers/docs : http://technet.oracle.com/ Simply register http://www.oracle.com/java

>
> My problem is that I want to call a RMI method whenever the database is
> updated, and until now didnt know that stored procedures could be written in
> Java (unless I misunderstood the post).

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 in advance!
>
> joe varghese
>
> In article <m13dx6xqlx.fsf_at_kheldar.evhr.net>, doeni_at_kheldar.evhr.net says...
> >
> >"Alex Murkes" <murkes_at_my-Deja.com> writes:
> >
> >An RMI call from a Java Stored Procedure should be OK, however the user
> >calling the procedure should have the JAVASYSPRIV or JAVAUSERPRIV role
> >granted.
> >
> >> I tried to make an RMI call from a Java stored procedure, but got a
> >> SecurityException. I searched JDK 1.1 docs (Oracle's JVM is 1.1.6), but
> >> couldn't figure out how to change security permissions in a running JVM.
> >>
> >> Has anyone been successful in doing RMI from a Java stored procedure?
> >>
> >> Thanks!
> >> -Alex
>

--
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