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

, ,
1

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

2

Please include webMethods environment to my earlier message:

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

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

4

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…

5

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

6

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

7

Amulya, Thanks for your help.

Modified configuration properties and now it’s enabled.

Thanks ALL for your valuable time and suggestions.

-Siva