Skip to Content
avatar image
Former Member

SAP XI 3.0 JDBC connection to DB2 AS/400 error

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    May 11, 2006 at 03:01 PM

    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:

    JDBC driver to AS400

    ---Satish

    Add comment
    10|10000 characters needed characters exceeded

    • 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