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

When you use WebSphere Application Server with an IBM DB2 database, this exception could occur:
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

  1. Log in to the WebSphere Application Server administration console.
  2. Select Resources > JDBC > Data sources > Application Center DataSource name > Custom properties and click New.
  3. In the Name field, enter allowNextOnExhaustedResultSet.
  4. In the Value field, type 1.
  5. Change the type to java.lang.Integer.
  6. Click OK.
  7. Click New.
  8. In the Name field, enter resultSetHoldability.
  9. In the Value field, type 1.
  10. Change the type to java.lang.Integer.
  11. Click OK and save your changes.
Parent topic: Configuring Application Center after installation