Hi,

There is an error we very frequently get for exceeding the max connection.

Connection Failed Connection Failed
Error Message: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: User 'jp_yf_admin' has exceeded the 'max_user_connections' resource (current value: 30)

We have set Max user connection limit as 30 at data source level.

When we checked at the back end all connections are not open or active.Most of the connections are in sleep mode. I assume the application should automatically close those connection if they are in sleep.This is what is leading to exceed the user connection limit.

Even if we increase the limit of user connection the problem would surely persist.

Is there is any way we can avoid or close those connection which are not in use or in sleep mode?

Thanks,
Mala