on 12-19-2006 11:01 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
> 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>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.