CODEWITHSUNDEEP
oracle-databaseplsqloracle10gjava-stored-procedures
Vanja Keglevic
Vanja Keglevic

Reputation: 83

Oracle database - use external Java

I'm looking to find a way how to use higher versions of Java (1.6,1.7,...) instead of Java 1.4 which is available for Java stored procedures in a Oracle 10g. I'm thinking about deploying a GlassFish server on the database server, and deploy web applications which functionalities would I use by calling them from PL/SQL.

Reasons for using Java instead of PL/SQL would be communications with various devices, calling and deploying web services, text processing...

Does anybody have a better, simpler idea on how to use higher version Java from PL/SQL in Oracle 10g database?

Upvotes: 3

Views: 494

Answers (1)

ibre5041
ibre5041

Reputation: 5298

Forget about that. There used to be something called Jserver several years ago, but it was abandoned by Oracle. Theoretically you could use Oracle ver 12c which uses JVM ver 1.6. But even this JVM is slightly different. For example it's GC can kill threads when they are not bound to a "live" DB connection. So you may encounter various interesting problems.

There is no way how to "upgrade" JVM inside current Oracle DB installation.

Upvotes: 1

Related Questions