Skip to Content
0
Former Member
Dec 19, 2006 at 11:01 PM

Error in XI Sender JDBC adapter for AS/400 DB2

9 Views

We are trying to connect to AS/400 DB2 from XI's Sender JDBC Adapter. we got the driver from DataDirect (connectjdbc.jar) and configured it within XI .The configuration according to the manual for this jar file is

// Register the driver with the driver manager

Class.forName("com.ddtek.jdbc.db2.DB2Driver");

// Establish the Connection

String url = "jdbc:datadirect:db2://corpserver1:50000;LocationName=ACCTNG";

Connection con = DriverManager.getConnection(url, "test04", "test04");

In XI we configured this as:

Driver = com.ddtek.jdbc.db2.DB2Driver

Connection = jdbc:datadirect:db2://servername;LocationName=NBHAGWAT

and specified the user id and password

<b>Note</b>: The Port Number is optional

When this was done in XI, we got the below error in the Adapter Monitoring:

Sender Adapter v2108 for Party '', Service 'JDBCtoFile':

Configured at 2006-12-19 15:45:31 MST

History:

- 2006-12-19 15:45:31 MST: Retry interval started. Length: 10.000 s

- 2006-12-19 15:45:31 MST: Error: Accessing database connection 'jdbc:datadirect:db2://AS400a;LocationName=NBHAGWAT' failed: DriverManagerException: Cannot establish connection to URL 'jdbc:datadirect:db2://AS400a;LocationName=NBHAGWAT': SAPClassNotFoundException: com.ddtek.jdbc.db2.DB2Driver

- 2006-12-19 15:45:31 MST: Processing started

Is this because there is something wrong because the way the connection string is specified.

Anybody who has configured XI Sender JDBC adapter for AS/400 DB2, please send us some information on this.

Thank you,

Regards,

Balaji