×
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.
Per the link http://www-1.ibm.com/servers/eserver/iseries/toolbox/faqjdbc.htm#faqA1
What JDBC drivers does IBM provide for the OS/400 database?
IBM provides two different JDBC drivers for the OS/400 database:
The "Native" JDBC driver. This is shipped as part of the AS/400 Developer Kit for Java (57xxJV1). It is implemented
by making native method calls to the SQL CLI (Call Level Interface). Consequently, it only runs on the OS/400 JVM.
The class name to register is com.ibm.db2.jdbc.app.DB2Driver . The URL subprotocol is db2 .
The "Toolbox" JDBC driver. This is shipped as part of the IBM Toolbox for Java (57xxJC1). It is implemented by
making direct socket connections to the database host server. This happens to be the same route that the Client
Access/400 ODBC driver takes. However, Client Access/400 is NOT required. The Toolbox runs on any JVM. The
class name to register is com.ibm.as400.access.AS400JDBCDriver . The URL subprotocol is as400 .
While I have both JC1 and JV1 installed on my 4.4 box only the second driver is where the data above shows. On my client's 4.5 box neither driver is at the above location. My box has the jdk 1.1.7 the 4.5 has 1.1.8 and 1.2 jdk's
I'm new to installing and using Java and JDBC so... who uses this, are there extra steps above installing JV1 or JC1 to get the JDBC drivers loaded and where do they end up?
Thanks
---------------------------------
Kirk Goins
IBM Certified AS/400 Technical Solutions
DataMirror High Availability Certified
Pacific Information Systems - An IBM Premier Business Partner
503-674-2985 kirkg@pacinfosys.com
"WE KNOW TECHNOLOGY"
---------------------------------
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.
midrange.com
