A client developing custom Java applications faced the following error while testing one of their apps:
com.sap.sql.log.OpenSQLException: No connection to data source SAPSIDDB available. All 50 pooled connections are in use and 7 connection requests are currently waiting. The connection pool size might need to be adjusted.
Solution basically consisted on two parts:
- Code optimization
- Adjusting the following parameter on the template of the configtool: