Re: Native JDBC Driver for v5r3

[Bruce Jin <brucej@xxxxxxxxxxxxxxxxxxxx>]

Change your job CCSID to 37 will get rid of this error.
You can change it in CL or qshell script.
It may be a good idea to check and save the original ccsid and restore 
it after your java job ends.
Bruce


Keith.McCully@xxxxxxxxxxxx wrote:

> 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
>