RE: Native JDBC Driver for v5r3

Your company's CCSID is 65535. You can change it to 37 for the job.

-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx
[mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of
Keith.McCully@xxxxxxxxxxxx
Sent: Wednesday, May 18, 2005 6:12 AM
To: Java Programming on and around the iSeries / AS400
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.



"EMF <capitalfactors.com>" made the following annotations.
------------------------------------------------------------------------------
The information transmitted by the following E-Mail is intended only for the 
addressee and may contain confidential and/or privileged material. Any 
interception, review, retransmission, dissemination, or other use, or taking 
any action upon this information by persons or entities other than the intended 
recipient is prohibited by law and may subject them to criminal or civil 
liability. If you received this communication in error, please contact us 
immediately at 954-660-7400 and delete the communication from any computer or 
network system.
==============================================================================