Cannot get a connection, pool error Timeout waiting for idle object

Avatar

Avatar
Level 1
SebasRios34
Level 1

Likes

0 likes

Total Posts

4 posts

Correct reply

0 solutions
View profile

Avatar
Level 1
SebasRios34
Level 1

Likes

0 likes

Total Posts

4 posts

Correct reply

0 solutions
View profile
SebasRios34
Level 1

22-06-2021

Hello everyone,

 

We are having an issue with our JDBC connection pool on the Manager Web Console
Configuration. We have created several custom workflow components that access a SQL Server Database and perform updates and inserts to the database. 

SebasRios34_0-1624381714803.png

When it reaches the third component (Bulk Update Part 3), it triggers the following error: Cannot get a connection, pool error Timeout waiting for idle object, but it works just fine with the other two.

 

I was able to find this article on how to create a DataSourcePool: http://scottsdigitalcommunity.blogspot.com/2013/09/injecting-datasourcepool-service-into.html

 

Any ideas what I could change in the data source pool configuration?

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Boost 500
MVP
Vijayalakshmi_S
MVP

Likes

573 likes

Total Posts

728 posts

Correct reply

240 solutions
Top badges earned
Boost 500
Give Back 50
Give Back 5
Ignite 10
Ignite 5
View profile

Avatar
Boost 500
MVP
Vijayalakshmi_S
MVP

Likes

573 likes

Total Posts

728 posts

Correct reply

240 solutions
Top badges earned
Boost 500
Give Back 50
Give Back 5
Ignite 10
Ignite 5
View profile
Vijayalakshmi_S
MVP

22-06-2021

Hi @SebasRios34,

If you are closing the connections upon usage correctly in other process components/wherever it is used and in need to additional connections through the connection pool,

  • You can increase the number of connections (Pool size - highlighted in red) in your respective OSGI factory config instance. 

If you are sure that the available number of connections is suffice(you already have greater number on Pool size based on the need) but still the timeout error is observed,

  • Increase the wait time (Pool wait - highlighted in green)

Vijayalakshmi_S_0-1624385652767.png

Answers (0)