× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.






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.





As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.