How to know connection pool usage

cancel
Showing results for 
Search instead for 
Did you mean: 
tkim
Member II

How to know connection pool usage

Now, my Alfresco Application causes error like this ;
"exception during job acquisition: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.JDBCConnectionException: Cannot open connection"
This error will be caused by the DB connection pool depleted.
The errors occur continuously, and the application can not response.

My webscript/Java may have problem about connection management. 

I want check connection pool usage in each SHARE operation(and webscript/Java).

Environment:

Alfresco community edition 5.1

Backend database : mysql throuh JDBC

1 Reply
afaust
Master

Re: How to know connection pool usage

There is no way to check the connection pool usage for each Share operation as Share does not directly use any connections. Typically speaking since each Share operation in itself is sequential, you will mostly only use one connection per operation, unless the Repository-tier backend operation does some nested transaction handling which is very uncommon and usually only found in 3rd-party addons.

You can use the OOTBee Support Tools addon to see the current usage of the connection pool in the Alfresco Repository Administration Console.