Skip to Main Content

Java and JavaScript in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle java SP to DB2 SP using type 4 JDBC db2jcc.jar connection error

574832Apr 27 2007 — edited May 8 2007
Oracle 10.2.0.1.0 java 1.4 windows xp
I am trying to connect an oracle-java stored procedure to a DB2 database in Z/OS using the Type 4(no client) JDBC Driver.
I have successfully connected in a simple command line java program selecting rows from a table by adding db2jcc.jar and the licensing.jar to the classpath.
I have successfully connected an oracle java stored procedure to an mysql stored procedure on the same database by javaloading the mysql driver jar which resolved OK.
I have read the thread 354894 which describes this for Informix, and followed the described process.
I have javaloaded the db2jcc.jar with genmissing and the licensing.jar and most everything is now VALID.

I am now getting the following errors
Creating new getdata ... 3 [Ljava.lang.String;@2862355c
java.lang.NoClassDefFoundError: !!!ERROR!!! generated by genmissing
at com.ibm.jvm.Trace.<clinit>(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:165)
at com.ibm.db2.jcc.b.n.m(n.java:424)
at com.ibm.db2.jcc.b.n.<clinit>(n.java:268)
at com.ibm.db2.jcc.DB2Driver.<clinit>(DB2Driver.java:39)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:165)
at getdata.getdimv33(GETDATA:175)

Any help would be appreciated.
Jack
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 5 2007
Added on Apr 27 2007
3 comments
2,552 views