Java and JavaScript in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Install JDBC 8i (classes12.jar) into Oracle 18c

CldrMay 8 2019 — edited Jul 2 2019

Hi all,

I'm currently trying to execute queries from a 18c database to an ancient Oracle 7 Database (yes, the 90's one) using the a 8i JDBC driver.

However when trying to load the classes12.jar with loadjava i get a couple dozen of the of the following:

creating : class oracle/jdbc/dbaccess/DBAccess

loading : class oracle/jdbc/dbaccess/DBAccess

Error while creating class oracle/jdbc/dbaccess/DBAccess

ORA-29545: badly formed class: User has attempted to load a class (oracle.jdbc.dbaccess.DBAccess) into a restricted package. Permission can be granted using dbms_java.grant_permission(<user>, LoadClassInPackage...

ORA-06512: at line 1

I'm afraid something might break if i force the loading with SYS.

Is there any way to use this driver in 18c to connect to v7 instead of DBLinking 18c>10g>8i>7 ?

This post has been answered by Marcelo F. Ochoa on Jun 27 2019

Jump to Answer

Added on May 8 2019

7 comments

2,806 views