JDBC driver for DB2 version 8.1. Which JDBC driver type and

Hello,

     We are using database DB2 version 8.1 (UDB) installed on AIX version 5.3. I would need to get JDBC driver for this DB version.

     Could anyone suggest, Which JDBC driver to use and Where I can get this driver?

      I searched IBM website, but could not find useful link.

Thanks in advance fot your inputs and time,

-Siva

Please include webMethods environment to my earlier message:

    wM 6.1 SP-1 and JDBC 6.0.3 adapter running on Windows 2003

Hi Siva,

unfortunately I dont know of any JDBC Type 4 driver from IBM for their DB.

A Type 2 driver and a Type 3 driver is bundled with the DB, but it requires the native client libs on the host.

Type 4 drivers can be obtained from:

There are evaluation versions availabe for these drivers.
They are platform indepedent and do not require any natives.

Regards,
Holger

How about the IBM DB2 Universal Type 4 driver? It’s supported by the JDBC Adapter 6.0.3 for use with IBM DB2 8.1 and 8.2.

James…

Holger, James,

      Thanks for your valuable inputs.

I downloaded db2jcc.jar and licence file db2jcc_licence_cu.jar and this been added to IS classpath.

But, after this, I have some issue while enabling. Please find error below.

Configuration details are: other properties are set to default:

Transaction Type : LOCAL_TRANSACTION
DataSource Class : com.ibm.db2.jcc.DB2Driver
serverName : jdbc:db2://IP ADDRESS:50000/tpetest
Valid user name/password supplied
Other Properties : driverType=thin

Error message:

[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager. com.ibm.db2.jcc.DB2Driver

Any help is greatly appreciated.

Thanks,
Siva

Siva,
The DataSource class supported is com.ibm.db2.jcc.DB2DataSource. If you are using JCC driver, the connection parameters should look like this

Transaction Type LOCAL_TRANSACTION
DataSource Class com.ibm.db2.jcc.DB2DataSource
serverName
user
password ******
databaseName
portNumber <Port#>
networkProtocol
Other Properties driverType=4

Hope this helps
Amulya

Amulya, Thanks for your help.

Modified configuration properties and now it’s enabled.

Thanks ALL for your valuable time and suggestions.

-Siva