-
Java Stored Procedure and JDBC driver
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?
-thanks,
VAn
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|