I am using Jboss, Hibernate and MySQL. I want to know how many connections are opened after each business operation done. Can you please let me know the steps to follow for getting this done?

Thanks in advace,
Kalpesh

Why would you want to know how many connections are sitting open and idle in a connection pool in JBoss?

Do you mean that you want to see the current connection usage level, as multiple requests are in-progress?

At some place, we have used JDBC and in some cases we used hibernate to access database. Now, after some business operations, we are running out of connections. So, I want to know after each business operation how many connections are opened to database collectively by direct JDBC call and hibernate. While getting connection from JDBC, we have used the same data source, we declared in hibernate configuration. So, I want to know whether hibernate provide such functionality. I tried the following code snippet but gives 0 all the time.

dBSession.getSessionFactory().getStatistics().getConnectCount()

Thanks,
Kalpesh

We created a LoggedDataSource and LoggedConnection which manage a counter tracking the number of active connections.

The LoggedDataSource just delegates to a DataSource and wraps calls to getConnection with a LoggedConnection decorator.

DataSource.getConnection adds 1
Connection.close subtracts 1

We use Spring and just change our config when we want to look at max no. of concurrent connections during testing. This gives us an idea of the user to connection ratio needed.

The Counter object is configured in Spring also so its pretty easy to expose this as JMX if you want to watch it via a JMX console.

So, there is no direct way to know the numbe of open connections with hibernate API? Is that what you mean?

Don't know. I think you want to measure open connections at the datasource level, like I said.