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