How to get connection pool information from Hibernate?

Question

Possible Duplicate:
How to monitor c3p0 connections

How can I get database connection pool information such as total connections in use, connection remaining etc ?. I want this information for logging (troubleshooting) purposes. I am using Hibernate with C3P0.

http://stackoverflow.com/questions/4104125/how-to-monitor-c3p0-connections — Vlad, Aug 02 '11 at 10:13

score 2 · Answer 1 · answered Nov 09 '11 at 10:37

2

We used getStatistics and getConnectCount on it, but it doesnt have any particular function to show current open connections. The getConnectCount displays the total number of connections opened

answered Nov 09 '11 at 10:37

jyo

21
2

score 1 · Answer 2 · answered Aug 02 '11 at 09:47

1

Use getStatistics() method of your SessionFactory as per documentation.

answered Aug 02 '11 at 09:47

Vlad

10,602
2
36
38

i tried Statistics, as you mentioned, but i am unable to get required information. Can you please pin point any particular function, which you think should work for me. Thanks – Umer Hayat Aug 02 '11 at 09:56

How to get connection pool information from Hibernate?

2 Answers2