Using loadjava in Oracle 9i

[Chris Staten]

Hey all, I have a quick question about java and Oracle 9i. I�m using Oracle�s loadjava utility to load java classes into my database and then calling them using PL/SQL. I read where the loadjava utility works with .java, .class, and .jar files, so I decided to compile all of my code and jar it up before moving it over to the database (seems cleaner to me).

This is where I run into a problem, all of my classes seem to have errors in them when I do this, but if I take the .java files and move them over using the loadjava utility then they compile just fine and all is good.

Any idea why my code only works when the source code is moved over?

[Jeanne Boyarsky]

Chris,
I'm moving this to our Oracle forum since it is about an Oracle utility.

[Chris Staten]

OK, I've got everything working just fine by jaring up the .java files and not the .class files. They get compiled and loaded into the DB just fine when I move the jar file over.

I'd still like to figure out why I can't directly put my class files over though.

[Avi Abrami]

Chris,
Either don't use the "-resolve" option (in your loadjava command line) or add the "-genmissing" option. The loadjava utility is described in the Java Developer's Guide which is part of the Oracle documentation and is available from:

http://tahiti.oracle.com

Good Luck,
Avi.