We have a JDBC connection set up for Sybase 17.
There is a Polling Notification.
Whenever the notification picks up a record from buffer table, it publishes the notification document and trigger invokes the subscription service.
The subscription service then uses SELECT adapter service to fetch record from the transaction table.
Whilst performing this activity, many a times few calls fails with below error:
(JZ0C0/0) JZ0C0: Connection is already closed."
JZ0C0: Connection is already closed.
Records are getting populated in the buffer table quite frequently, because of which the JDBC connection may be used by many parallel executions of the subscription service.
I have set below pool settings for the JDBC connection:
|Enable Connection Pooling|true|
|Minimum Pool Size|1|
|Maximum Pool Size|1000|
|Pool Increment Size|1|
|Block Timeout (msec)|10000|
|Expire Timeout (msec)|10000|
Kindly assist with optimal settings to ensure this error does not occur.
Thanks & Regards,