AS400 JDBC driver

[Former Member]

Hi,

We have a scenario for testing database connectivity with AS400 via JDBC drivers.

And we have already tried with MSSQL JDBC drivers.

The sap document on external drivers JDBC and JMS provides only for some database..

Is there any way to identify the jar files for each and every database individually.any documents to find the list for external JDBC with respect to each database...

Kindly help

Gopalakrishnan M

[Former Member]

Hi,

For AS400, we can use File based integration. The AS400 creates a flat file which is read by SAP XI File adapter and sent through regular processing.

There are two types of DB2 JDBC Drivers are avialble.

1.The "Native" JDBC driver.

Driver:com.ibm.db2.jdbc.app.DB2Driver

Sub protocol:db2

Ex.jdbc:db2:localhost/COLLECTIONNAME

2.The "Toolbox" JDBC driver.

Driver:com.ibm.as400.access.AS400JDBCDriver

Sub protocol:as400

Ex.jdbc:as400://MACHINENAME/COLLECTIONNAME

We can integrate AS400 systems using JT400 classes from IBM, in a different middleware. These classes also have JDBC drivers, which you can use in the JDBC adapter but I would suggest to write your own adapter using JT400 Direct Record access classes. These are much faster than JDBC.

Ofcourse, you can also use the JMS and file adatper as other option as well.

And to access any Database from XI, the corresponding driver has to be deployed on your XI server.

For info on how the drivers have to be installed, check these links,

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/3867a582-0401-0010-6cbf-964...

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/70ffd890-0201-0010-708f-d5d...

Also Refer to the documentation on the URL

http://as400bks.rochester.ibm.com/html/as400/v4r5/ic2924/index.htm?info/java/rzaha/jdbc.htm

There is a new tool available at Service Marketplace which makes it easy to deploy JDBC / JMS driver.

the URL is

https://websmp105.sap-ag.de/~sapdownload/011000358700007048402005E/HowInstallExternalDriver.zip

Check out the drivertool utility in this zip.

While using the AS/400 Toolbox for java, instead of AS/400 DevKit4Java, you will find this IBM page very useful.

http://as400bks.rochester.ibm.com/html/as400/v4r5/ic2924/info/java/rzahh/jdbc.htm

Also have a look at: http://publib.boulder.ibm.com/iseries/v5r2/ic2924/index.htm?info/rzahh/javadoc/JDBCProperties.html

It is clear from this document that, First you have to deploy with SDM the corresponding Drivers.

For example say,

com.ibm.as400.access.AS400JDBCDriver

Then in your configuration Channel you have to use this string:

jdbc:as400://"Your IP":446/"Your Schema";date format=iso;date separator=-

I hope this info helps......

Regards,

Abhy

Message was edited by: Abhy Thomas

[Former Member]

Hi,

You can find a list of JDBC drivers here:

http://developers.sun.com/product/jdbc/drivers

[bhavesh_kantilal]

hi,

Log in to AS400 DB's website and see for the Driver info. You will get the driver to be used to connect to the database and then install the same on your XI.

Regards,

bhavesh

[Former Member]

If you are aware of the types of JDBC drivers, XI makes use of the Type 4 i.e. Thin drivers which are full Java Implementation type drivers. The responsibility of providing such a driver is of the database vendor and you should check the database documentation. If you google enough then you'll find many sites listing drivers for different databases but you get it only as a official download version