Jdbc driver format

[Former Member]

Hi All,

Imported & Installed Type 4 DB2 JDBC driver… I need help in filling the JDBC Driver format and Connection string.

Database: DB2,

Port: 1111,

Database name: testdb

Server Name: testserv.com

I’m using the following values, and got the follwoing processing error

Jdbc Driver: com.ibm.db2.jcc.DB2Driver

Connection: jdbc:db2:// testserv.com:1111;databaseName= testdb

User Name: test

Password: xxxxxx

Processing Error: Accessing database connection jdbc:db2:// testserv.com:1111;databaseName= testdb ' failed: com.ibm.db2.jcc.b.SqlException: Invalid database url syntax

Can some one help me in correcting this error

Thanks for the help

[Former Member]

Thanks SKM it worked

[Former Member]

you are welcome.

SKM

[Former Member]

Hi,

I included the 3 jar files (db2jcc.jar,db2_license_cu.jar, db2_license_cisuz.jar)and deployed the aii_af_jmsproviderlib.sda file without error. The other parameters used were :

JDBC Version : 2.0(with XA support)

CPDS Classname : com.ibm.db2.jcc.DB2Driver

URL: jdbc:db2://<servname>:50000/<dbname>

user : abc

password : <password>

SQL Engine : Vendor SQL

. On saving get an error : com.ibm.db2.jcc.DB2Driver cannot be found

Please advise

Thanks

Suresh

[Former Member]

Your url is wrong. The right one is

<b>jdbc:db2://<host>:<port50000>/<database></b> that means it should be like this

<b>jdbc:db2://testserv.com:1111/testdb</b>

regards

SKM

[Former Member]

If you are using a type 2 JDBC driver, check this note 850116, your XI should have at least SP11. You´ll also need to deploy de drivers & lib files within the inbound proxy bean to the J2EE server.