Skip to Content
author's profile photo Former Member
Former Member

AS400 JDBC driver

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

Add comment
10|10000 characters needed characters exceeded

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 03, 2006 at 09:15 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 03, 2006 at 09:15 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 03, 2006 at 09:19 AM

    Hi,

    You can find a list of JDBC drivers here:

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

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 03, 2006 at 09:22 AM

    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-9644e49f1a10

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

    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

    Add comment
    10|10000 characters needed characters exceeded