JDCB Connection from XI to AS400

[Former Member]

Hello,

I am trying to create a connection between my <b>SAP XI 2004 SP20</b> system and an

<b>IBM as400 - os400 V</b>5<b>R</b>3 system using the Sender JDBC adapter.

the System Administrator provided me a driver called jt400.jar wich i installed in the SAP XI system. Using the following connection details i get an error.

<u><b>Connection Details:</b></u>

Connection: jdbc:db2://<host>/<database>

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

<u><b>Error:</b></u>

Error during database connection to the database URL <i>"jdbc:db2://<host>/<database>"</i> using the JDBC driver 'com.ibm.db2.jdbc.app.DB2Driver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection to URL <i>"jdbc:db2://<host>/<database>"</i>: SAPClassNotFoundException: com.ibm.db2.jdbc.app.DB2Driver'

Is this a driver problem or a connection problem?

Can anybody help me out on this?

Kind regards,

Ramon

[nisarkhan_n]

can you cross check the connection parameters once again ( not sure just check cross check with these parameters below)

JDBC Driver: com.ibm.as400.access.AS400JDBCDriver

Connection :jdbc:as400://ServerName/databaseName

[Former Member]

HI,

I think its a driver problem check whether the driver are installed or not through Visual admin.

Also check the following help for installing the drivers.

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/3867a582-0401-0010-6cbf-9644e49f...

Thnx

Chirag

[Former Member]

HI,

Follow the steps for checking the drivers:

Go to Visual admin:

1) chose table cluster->server->libraries->com.sap.aii.af.jmsproviderlib

2) Check in window jar container,if JMS/JDBC libraries are uploaded correctly

3) Look ar jars contained

3) look at \usr\sap\<sysID>\JCOO\j2ee\cluster\server-\bin

Also check the deployment in Visual Admin

1) choose tab cluster->server->service->classloader viewer

2_ Look tab in runtime component-> libraries-> com.sap.aii.af.jmsproviderlib for JDBC/JMS lib.

Refer the thread which has the same problem.

Thnx

Chirag