Configure 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.

When we 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, we must add custom properties in WebSphere Application Server at the Application Center data source level.

1. 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 the changes.

Parent topic: Install the application center