Skip to Content
0
Aug 03, 2016 at 07:52 AM

OpenSQLException: No connection to data source SAPDB available

789 Views

Hi,

I have built a custom JAVA table in PI 7.31 single stack and have built a custom look up service for reading/updating table with SELECT and UPDATE. After deploying this, when many messages are processed then all connection to database are getting full and PI server is going down with following error trace.

com.sap.sql.log.OpenSQLException: No connection to data source SAPDB available. All 200 pooled connections are in use and 31 connection requests are currently waiting.


Please suggest how to get it rid of this connection pool issue.

Br,

Madan