Which JDK version does Oracle 9.2 support for stored procedures?

Thread view:

Roger Sheldon - 14 Dec 2003 00:34 GMT

Hi,

I've got Oracle 9.2 and I would like to write a java stored procedure
which invokes code from a Java 1.3 jar file, but it seems I'm out
of luck.

From looking at the examples in C:\oracle\ora92\javavm\demo\examples\
it appears that only JDK 1.1 and 1.2 are supported.

I compiled Hello.java using javac from JDK 1.3 then loaded and published
the Hello.world() method, but it didn't work.

But if I compile it via:
javac -target 1.2 Hello.java
then it *does* work.

So am I missing something here, or is Oracle really only
supporting 1.2 for java stored procedures?

Thanks

Roger

Reply to this Message

Lee Fesperman - 14 Dec 2003 22:11 GMT

> Hi,
>
[quoted text clipped - 14 lines]
> So am I missing something here, or is Oracle really only
> supporting 1.2 for java stored procedures?

You should use a 100% Java ORDBMS. With non-Java DBMSs like Oracle, you get 'Java in the
database'. That is, these DBMSs provide their own proprietary JVM embedded in the DBMS.
You can't choose the best and most up-to-date JVM.

100% Java DBMSs provide 'the database in Java'. You can choose the best-of-breed JVM,
with the latest features and the greatest performance for any given platform. And, you
get true integration of Java stored procedures with the database engine.

For more details, see http://www.firstsql.com/javadbsynergy.shtml.

Signature

Lee Fesperman, FirstSQL, Inc. (http://www.firstsql.com)
==============================================================
* The Ultimate DBMS is here!
* FirstSQL/J Object/Relational DBMS (http://www.firstsql.com)

Reply to this Message

Which JDK version does Oracle 9.2 support for stored procedures?

Free Magazines