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!

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

3,114 views