Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

DB2 version 8 Type 4 Data Source

 
Ryan Tang
Greenhorn
Posts: 18
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic