iSeries DB2 JDBC Adapter failure

[Former Member]

I have a scenario where XI needs to send data to AS-400 (iSeries) DB2. To do that we installed the DB2 JDBC driver for AS-400 (jt400.jar).

However, we are getting the following error:

Receiver Adapter v2808 for Party '', Service 'Phase2Test_BusService':

Configured at 2007-07-24 16:45:37 EDT

History:

- 2007-07-24 16:45:37 EDT: Error: Accessing database connection 'jdbc:as400://10.63.248.37:8471/p2iftest' failed: DriverManagerException: Cannot establish connection to URL 'jdbc:as400://10.63.248.37:8471/p2iftest': SAPClassNotFoundException: com.ibm.as400.access.AS400JDBCDriver

We run a custom Java program to test the driver. It's working with the that. However, the same driver is failing for XI.

Please help.

[Former Member]

We have configured the adapter in the same way. Also we have the Table definition in place. But still we are getting the same error.

[Former Member]

The driver is deployed in Visual Admin.

To test the driver is ok or not, we wrote a small stand-alone custom Java program and connected to the iSeries DB2. So aparently there is no issue with the driver.

- Shibaji

[Former Member]

Chandra,

Also see whether the database and the table are there or not? XI will not create them. So initially you have to create them manually and then use it.

Regards,

---Satish

[justin_santhanam]

Chandra,

Even in my current implementation i'm using AS400 & integrating the same with XI.

Please check whether u gave the same comm.channel properties.

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

connection :jdbc:as400://server/;errors=full

Best regards,

raj.

[justin_santhanam]

Chandra,

Did u deployed the driver in Visual admin.

Best regards,

raj.

[Former Member]

Chandra,

I am expecting that you guys have installed the drivers in the XI box. Also try to connect the database from the command prompt and see whether it is getting connected or not. Also I feel from the error message that the drivers are not the same version. So please reverify the drivers once again.

Regards,

---Satish