Sending push notifications from WebSphere Application Server – IBM DB2

To issue push notifications from a WebSphere Application Server that uses IBM DB2 as its database, a custom property must be added.

If we use WebSphere Application Server with an IBM DB2 database, errors can arise when you try to send push notifications. To resolve this situation, we must add a custom property in WebSphere Application Server, at the data source level.

1. Log in to the WebSphere Application Server admin console.

2. Select Resources > JDBC > Data sources > 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 to save the changes.

7. Select custom property resultSetHoldability.

8. In the Value field, type 1.

9. Click OK to save the changes.

Parent topic: Push notification