*
The moose likes JDBC and the fly likes DB2 version 8 Type 4 Data Source Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "DB2 version 8 Type 4 Data Source" Watch "DB2 version 8 Type 4 Data Source" New topic
Author

DB2 version 8 Type 4 Data Source

Ryan Tang
Greenhorn

Joined: Aug 20, 2003
Posts: 18
Hi,

I am using com.ibm.db2.jcc.DB2ConnectionPoolDataSource and have set the driverType property to 4, but the connection drawn from the data source does not support updatable ResultSet. Websphere application server reports that the JDBC driver version is 2.

How can I configure a DB2 data source such that the connection got from the data source support updatable ResultSet?

Thank you.

Ryan
Jim Fowler
Greenhorn

Joined: Feb 24, 2005
Posts: 1
Make sure you have specifed for WebSphere to use the Universal database driver for DB2. On many platforms, the default database driver does not support updatable ResultSets, but the Universal driver does.

--
Jim Fowler
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: DB2 version 8 Type 4 Data Source
 
Similar Threads
Can we extract the data from resultset after the connection get closed.
can any one help me how to solve th problem with jdbc driver for DB2
Db2 invalid column name error
WebSphere - DB2 DataSource Connection Problem
how to use Scrollable ResultSet on WebSphere 4.0