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

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

Siva,

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

http://www.wmusers.com/forum/showthread.php?t=945&highlight=jdbc+driver+for+db2

HTH,
RMG

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

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

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

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

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.