JDBC Pools fails

We are seeing the below error when trying to test jdbc pools

[wm-cjdbc37-0020][Oracle JDBC Driver]Error establishing socket to host and port: 89.2.41.72:1521. Reason: No buffer space available (maximum connections reached?): JVM_Bind

Sometimes, restarting integration server will resolve this error and sometimes the physical server has to be restarted to get the IS back.

Does any one know why this error occurs? Please share your thoughts

check with your network team to see if there is firewall between IS and DB which is cutting the connections, or other possible network issue.

Hi Rachana41,

It looks like the maximum connection to the db has been reached therefore this error is thrown. Check on the number of active thread for jdbc. Could you give me more details on your environment like WM fabric version, java version, datadirect driver version and the OS you are running the IS on.

Thank you.

Regards,
Kuhen

Hi Rachna,
You can try changing the settings of ‘Expire Timeout’ value of JDBC connection. You need to decrease the value what ever you have configured right now. Probably whatever ‘tongwang’ has suggested makes more sense but if after folllowing his steps issue is not getting resolved then you can give a try to the one i suggested.

Thanks
Vikas

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.