Re: Loadjava won't load jar

Bob Maggio wrote:
>
> Has anyone ever tried loading Sybase jar files (jconn2.jar) for the
> sybase driver into oracle? I am trying to write a small connecter that
> can be called via an Oracle pl/sql statment but the code needs the
> Sybase jar files to connect. Alone the code works fine, but trying to
> load into Oracle 8.1.7, I get "cannot resolve" ORA 12534 errors. I am
> unable to compile the programs separately. Any suggestions on getting
> these classes into Oracle?
> Thanks
> Bob Maggio
> rmaggio_at_courts.state.ny.us

Hi Bob,
No, I have never tried to install Sybase JAR files into Oracle. Are you trying to do this because you want your PL/SQL code to connect to a Sybase database via JDBC? If yes, then I have a suggestion, but there are probably different (and better :-) ways.

Have your PL/SQL code invoke a method (using RMI) on a java class that is external to the Oracle JVM. This external class should have no trouble connecting to the Sybase database (as you imply in your description) -- and it can return results back to your PL/SQL code.

Hope this helps.

Good Luck,
Avi. Received on Thu Apr 18 2002 - 05:19:30 CDT