JDBC driver for DB2 version 8.1. Which JDBC driver type and How to get?

, ,
1

Hello,

webMethods environment:
wM 6.1 SP-1 and JDBC 6.0.3 adapter running on Windows 2003 .

DB environment:
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

Siva,

Please search this site on JDBC driver for DB2 you will see different resultsets,see this link too…

[URL=“wmusers.com”]wmusers.com

HTH,
RMG

3

A few seconds spent with Google suggests that the Type 4 JDBC driver you are looking for is db2cc.jar. Usually JDBC drivers are shipped with the database software. Ask your company’s or client’s DBA for assistance in getting a copy.

Mark

4

Mark, RMG,
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

5

My guess is that the data source class is incorrect. Has the JDBC Adapter User Guide been any help at all?

6

Rob, You are correct.

Rob, Mark, TMG, Thanks very much for your valuable time and sugesstions in helping me for a smooth start.

After trying various combinations and looking class files in jdbc driver for DataSource class, now my jdbe adapter is enabled.

My confiuration properties are:

Transaction Type : LOCAL_TRANSACTION
DataSource Class : com.ibm.db2.jcc.DB2DataSource
serverName : IP ADDRESS
Valid user name/password supplied
database : database name
port : port number
Other Properties : driverType=4

Thanks,
Siva

7

Hi Siva,
Glad it worked.
Though the WmJDBC User guide sugestes to use the DataSource Class as com.ibm.db2.jcc.DB2SimpleDataSource and there is no mention of com.ibm.db2.jcc.DB2DataSource there.

I have tested both to work fine though.