Configuring properties of DB2 JDBC driver in WebSphere Application Server
Add some JDBC custom properties to avoid DB2® exceptions from a WebSphere® Application Server that uses the IBM® DB2 database.
About this task
Invalid operation: result set is closed. ERRORCODE=-4470, SQLSTATE=null
To avoid such exceptions, you must add custom properties in WebSphere Application Server at the Application Center data source level.
Procedure
- Log in to the WebSphere Application Server administration console.
- Select New. and click
- In the Name field, enter allowNextOnExhaustedResultSet.
- In the Value field, type 1.
- Change the type to java.lang.Integer.
- Click OK.
- Click New.
- In the Name field, enter resultSetHoldability.
- In the Value field, type 1.
- Change the type to java.lang.Integer.
- Click OK and save your changes.