Connection Pooling Error

Technical queries
#1

Hello Helical Team,

I am using dynamic DB switching. For the same, I am using Groovy Plain JDBC data source. The connection id for the same is 12 and it is in /hi/hi-repository/dynamicSwitch directory.
When many users are using multiple dashboards, I am getting an error saying “ConnectionException: Too many connections” . How can I resolve this?

Thank You
Linapag

1 Like
#2

Hello Linapag,

Temporarily the problem can be fixed by increasing the maximum number of connections from database side based on the number of users using that connection.
reference : "Too Many Connections": How to Increase the MySQL Connection Count To Avoid This Problem - DZone Java

This is not the optimal solution and in our next release, this issue will be fixed. Solution for this is a managed connection, but as of now managed connection doesn’t support Dynamic DB Switching.

connection-error

Thank You
Team Helical