cancel
Showing results for 
Search instead for 
Did you mean: 

Error in XI Sender JDBC adapter for AS/400 DB2

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

bhavesh_kantilal
Active Contributor
0 Kudos

Hi,

Like mentioned by kenny,<i>Class not found com.ddtek.jdbc.db2.DB2Driver</i> implies that the driver class was not found. Maybe the driver was not installed as per the document.

Please revisit the installation guide and do the same.

Regards

Bhavesh

Former Member
0 Kudos

did u mention the port # in the URL? I feel the driver could not bind to the DB2 server..

just 2 cents thought...

Thanks-GS

Former Member
0 Kudos

> SAPClassNotFoundException:

> com.ddtek.jdbc.db2.DB2Driver

It looks like your JDBC driver is not found. Have you deployed the driver to XI?

<a href="https://www.sdn.sap.comhttp://www.sdn.sap.comhttp://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/3867a582-0401-0010-6cbf-9644e49f1a10">https://www.sdn.sap.comhttp://www.sdn.sap.comhttp://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/3867a582-0401-0010-6cbf-9644e49f1a10</a>

Former Member
0 Kudos

Hi All,

I had installed the driver as per the pdf "how to configure external drivers for JDBC and JMS adapters". tested the same and its fine. but i am not able to access the driver from XI JDBC Sender Adapter.

I also tried to mention the port number in the connection string, still no success.

Any suggestions?

Regards,

Balaji

bhavesh_kantilal
Active Contributor
0 Kudos

Hi,

Either the driver you have mentioned in the Sender JDBC adapter is incorrect ( not compatible with the driver you have installed ) or the driver is missing.!

Take a look at the last line on your JDBC adapter in RWB . It should have something like, AVAILABLE DRIVER with a list of drivers. Is the AS400 driver detail mentioned there?

Regards

Bhavesh

bhavesh_kantilal
Active Contributor
0 Kudos

Hi,

Either the driver you have mentioned in the Sender JDBC adapter is incorrect ( not compatible with the driver you have installed ) or the driver is missing.!

Take a look at the last line on your JDBC adapter in RWB . It should have something like, AVAILABLE DRIVER with a list of drivers. Is the AS400 driver detail mentioned there?

Regards

Bhavesh