Java Stored Procedure and JDBC driver
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:
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!
Click Here to Expand Forum to Full Width