Hello All,

I have a Java Stored Procedure that makes a connection to a PostgreSQL db via JDBC and does a select.

After successfully loading my TestPG.class and postgresql.jar(org.postgresql.Driver class is in here).I can see both in my schema; when i run it I get:

java.lang.ClassNotFoundException: org/postgresql/Driver
at java.lang.Class.forName0(Class.java)
at java.lang.Class.forName(Class.java)
at DataPatt.connect(DataPatt:13)
at DataPatt.getUserName(DataPatt:38)

So my question is how do I correctly load a jar?

I did this:
loadjava -u pcuser/password -v -R "((* PCUSER) (* PUBLIC))" -r DataPatt.java

loadjava -u pcuser/password -v postgresql.jar

Like I said, I can see all the classes via DBA studio when i click on my schema(PC user), it compiles fine (as expected), but when I run it the oracle java runtime can't find the classes that I loaded for the database driver!!!!! bastards!

Any ideas?