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



Based on the discussion so far, I'll remove jt400.jar from my classpath 
and go with James' suggestion of trying the JTOpen version of 
jt400Native.jar.

Thanks 

Keith




"James O'Sullivan" <josulli4@xxxxxxx> 
Sent by: java400-l-bounces@xxxxxxxxxxxx
18/05/2005 13:19
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
RE: Native JDBC Driver for v5r3










Colin,
      think that has been around since about V5R1, but like a lot of IBM
stuff, you have to search to find it.
Only found it because the JTOpen version of jt400.jar did not work with 
the
IBM version of jt400ntv.jar, and there was no JTOpen version of the
jt400ntv.jar file, so searched aorund for an alternative and found the
explanation for jt400Native.jar, which did exist in the JTOpen version


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 13:05   
                      Please respond   
                      to Java  
                      Programming on   
                      and around the   
                      iSeries / AS400   
  
  




James,

Is that new for V5R3 then? Useful to know!

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.

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



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

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.