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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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,536 views