SAP XI 3.0 JDBC connection to DB2 AS/400 error

[Former Member]

We're trying to connect to DB2 database (AS400) using XI 3.0 JDBC.

We've deployed the jt400.jar (part of JTO) on the J2EE succesfully.

We created a receiver/sender communication channel with the following params:

Trans Protocol: JDBC 2.0

Message Protocol: JDBC

Adapter Eng: Integration Server

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

Connection: jdbc:as400:<servername>

User & password.

The JDBC adapter shows the following error on the Sender channel: Error accessing database connection jdbc:as400:<servername> failed: DriverManagerException:

Cannot establish connection to URL jdbc:as400:<servername> . java.awt.headlessexception.

Please advice

Tx

Ron

[Former Member]

Ron

You specify the driver as:

com.ibm.as400.access.AS400JDBCDriver

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

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

For further info. go through the url:

---Satish

[Former Member]

Hi Satish,

Tx for your reply but you are referring to an XI config.

We have this working. The problem I face is connecting the portal to a non SAP backend system using a PAR template...

Regards

Ron