Re: Native JDBC Driver for v5r3

[Marshall Dunbar/DPS <marshall@xxxxxxxxxxx>]

1) I believe the native db2 driver is in db2_classes.jar which should 
already be loaded by the JVM since it is in the "ext" directory, 
/qibm/proddata/java400/ext.

2) The URL should be jdbc:db2:rdbname/dftcollection

Where "rdbname" is the name of the *LOCAL entry in WRKRDBDIRE, and 
"dftcollection" is the SQL collection to use if not specified in your SQL 
statements.

3) Make sure your system value (DSPSYSVAL QCCSID) is not 65535!  V5R3 will 
not let a JDBC driver connect to a system with 65535.  I believe most U.S. 
systems should set the QCCSID to 37.

Good luck.
===
Marshall Dunbar
DPS, Inc.
marshall@xxxxxxxxxxx
direct:(828)635-5561
main office:(317)574-4300 (800)654-4689
====



Keith.McCully@xxxxxxxxxxxx 
Sent by: java400-l-bounces@xxxxxxxxxxxx
05/18/2005 07:12 AM
Please respond to
Java Programming on and around the iSeries / AS400 
<java400-l@xxxxxxxxxxxx>


To
Java Programming on and around the iSeries / AS400 
<java400-l@xxxxxxxxxxxx>
cc

Subject
Native JDBC Driver for v5r3






Hi,


Just taken delivery of new iSeries with OS v5r3 & JVM 1.4.2. Previously, 
had OS v4r3 & JVM 1.1.7 and JDBC worked ok.

Since both my programs and data are on the iSeries, I've followed IBM's 
recommendation and opted for the "Native" JDBC driver.

So far I have the following:

1. Added /QIBM/ProdData/OS400/jt400/lib/jt400Native.jar to my classpath 
(as my OS > v5r1)
2. Class.forName("com.ibm.db2.jdbc.app.DB2Driver")
3.Use DriverManager.getConnection("jdbc:db2:*local", properties)for the 
connection.

Points 2 & 3 are unchanged from the previous version that worked, only the 

classpath has changed.

Compiled and tested in Qshell. Compiles ok but get runtime error message 
when attempts to establish connection:

Caught exception: INTERNAL ERROR:  Creation of DB2Driver object for 
registering with DriverManager failed. 

Any help or suggestions would be appreciated,

Keith
-- 
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L) 
mailing list
To post a message email: JAVA400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.