This week's book giveaway is in the OCMJEA forum. We're giving away four copies of OCM Java EE 6 Enterprise Architect Exam Guide and have Paul Allen & Joseph Bambara on-line! See this thread for details.
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?
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.