RE: Native JDBC Driver for v5r3 -- JAVA400-L

Heres the link to the page that details which jar files do what

http://publib.boulder.ibm.com/infocenter/iseries/v5r3/ic2924/index.htm?info/
rzahh/jarfilelist.htm 

cheers
Colin.W
 
http://as400blog.blogspot.com


-----Original Message-----
From: James O'Sullivan [mailto:josulli4@xxxxxxx] 
Sent: 18 May 2005 13:00
To: Java Programming on and around the iSeries / AS400
Subject: RE: Native JDBC Driver for v5r3






Keith,
      can't really help on the connection problem, as we use jdbc:as400: as
the Driver, but with regard to Colins comments about having both jar files
in your classpath, this is not necessary. jt400Native.jar contains
everything from jt400.jar plus "native" optimisation classes for the
iSeries. In times past the "native" classes were contained in a separate jar
file j400ntv.jar and then it was necessary to have both jt400ntv.jar and
jt400.jar in your classpath.

If you don't get specific help with your problem, trying downloading the
JTOpen version of theToolbox and extract their version of the
jt400Native.jar file. (https://sourceforge.net/projects/jt400)
We had problems with the OS/400 version of the file in the past and the fix
was contained in the open source version.

Don't overwrite the version in /QIBM/ProdData.. just extract the file to
another directory in the IFS and point your classpath at it. Files in
QIBM/ProdData can get overwritten without warning , so if the open source
version does fix your problem, you could lose the file without warning the
next time you apply a PTF.

regards

James..
----------------------------------------------------------------------------
------------

This is a PRIVATE message. If you are not the intended recipient, please
delete without copying and kindly advise us by e-mail of the mistake in
delivery. NOTE: Regardless of content, this e-mail shall not operate to bind
CSC to any order or other contract unless pursuant to explicit written
agreement or government initiative expressly permitting the use of e-mail
for such purpose.
----------------------------------------------------------------------------
------------




 

                      Colin Williams

                      <colin.williams          To:      "'Java Programming
on and around the iSeries / AS400'"       
                      @bertrams.com>           <java400-l@xxxxxxxxxxxx>

                      Sent by:                 cc:

                      java400-l-bounce         Subject: RE: Native JDBC
Driver for v5r3                              
                      s

 

 

                      18/05/2005 12:20

                      Please respond

                      to Java

                      Programming on

                      and around the

                      iSeries / AS400

 

 





Keith,

You have got both jt400Native.jar and jt400 on your classpath havent you

cheers
Colin.W

Extension   5800
Direct dial   0870 429 5800


-----Original Message-----
From: Keith.McCully@xxxxxxxxxxxx [mailto:Keith.McCully@xxxxxxxxxxxx]
Sent: 18 May 2005 12:12
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.

This e-mail has been sent by a company of Bertram Group Ltd, whose
registered office is 1 Broadland Business Park, Norwich, NR7 0WF. This
message, and any attachments, are intended solely for the addressee and may
contain privileged or confidential information.  If you are not the intended
recipient, any disclosure, copying, distribution or any action taken or
omitted to be taken in reliance on it, is prohibited and may be unlawful.
If you believe that you have received this email in error, please contact
the sender immediately. Opinions, conclusions and statements of intent in
this e-mail are those of the sender and will not bind a Bertram Group Ltd
company unless confirmed in writing by a director independently of this
message. Although we have taken steps to ensure that this email and any
attachments are free from any virus, we advise that in keeping with good
computing practice the recipient should ensure they are actually virus free.

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




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

This e-mail has been sent by a company of Bertram Group Ltd, whose registered 
office is 1 Broadland Business Park, Norwich, NR7 0WF. 
This message, and any attachments, are intended solely for the addressee and 
may contain privileged or confidential information.  If you are not the 
intended recipient, any disclosure, copying, distribution or any action taken 
or omitted to be taken in reliance on it, is prohibited and may be unlawful.  
If you believe that you have received this email in error, please contact the 
sender immediately. Opinions, conclusions and statements of intent in this 
e-mail are those of the sender and will not bind a Bertram Group Ltd company 
unless confirmed in writing by a director independently of this message. 
Although we have taken steps to ensure that this email and any attachments are 
free from any virus, we advise that in keeping with good computing practice the 
recipient should ensure they are actually virus free.