native JDBC driver (AS400 DB2/400 access)

[Guest.Visitor]

in several Documentations about Java and JDBC, there is mentioned, that the native-JDBC-Driver is shipped with 5769-JV1 (com.ibm.db2.jdbc.app.DB2Driver) but (with AS400-CMD WRKLNK) in this directory: /QIBM/ProdData/Java400/com/ibm/db2/jdbc/app I could not find something about DB2Driver. How can I check, if the native JDBC-Driver is installed already ? How can I check, if the native JDBC-Driver is shipped with 5769-JV1 ? How do I get a download, if the native JDBC-Driver is not installed ?

[Guest.Visitor]

Here's what I got from one of my native-JDBC colleagues. - Jeff Lee, AS/400 Toolbox for Java On the 400 do GO LICPGM. Use Option 10 to see installed licpgms. Search down the list for 5769JV1. If 5769JV1 is installed, you should see something like this: 5769JV1 *COMPATIBLE AS/400 Developer Kit for Java 5769JV1 *COMPATIBLE Java Developer Kit 1.2 5769JV1 *COMPATIBLE Java Developer Kit 1.1.8 If 1.1.8 is there, you have Native JDBC 1.0 support installed. If 1.2 is there, you have Native JDBC 2.0 support installed. Native JDBC does ship with 5769JV1 and the licpgm can't be installed to not have JDBC support. The full JDBC support is part of the product options, so you have to have the 1.1.8, 1.2, etc. product options installed in order to have the JDBC driver, but you can't do Java without one of these anyway. 5769JV1 support comes pre-installed on all AS/400s shipped, so it is likely there. As for looking at the actual jar files or class files, they move around a bit from release to release, but the main jar file is db2_classes.jar and in the most current release is found in '/qibm/proddata/java400/ext/'. If you don't have it for whatever reason, install the licpgm and the program options you want to use.

[Guest.Visitor]

Jeff, thank you. our machine is on OS400 V4R4M0 with CumTap-PTF C0147440 , and has installed: 5769JC1 V4R2M0 AS/400 Toolbox for Java 5769JV1 V4R4M0 AS/400 Developer Kit für Java 5769JV1 V4R4M0 Java Developer Kit 1.1.7 These are some of the (pre-installed) LicPgm. Maybe, the native JDBC-driver is only available within V4R5M0 ? Maybe, the native JDBC-driver is not included in JavaDevKit 1.1.7 ?

[Guest.Visitor]

yes, Jeff, I found the db2_classes.jar in directory: /QIBM/ProdData/Java400/ext thank you.