CODEWITHSUNDEEP
java
Fffc
Fffc

Reputation: 21

How to test if a database connection is closed successfully?

Normally our framework classes hibernate will handle the opening and closIng of databse connection.

But due to some technical requirement, we are required to open another database connection using a direct call to the database through jndi.

For this case how do we thoroughly test that our open connection and close connection will work correctly as expected?

Beside putting conn.close in an exception finally block?

Upvotes: 2

Views: 4884

Answers (2)

user669083
user669083

Reputation: 151

It actually depends on the database. Most databases show the number of connections to them and can also display the ip address connecting to it. So, check in the database.

Otherwise, try running mock query after close and it should fail, catch the exception so it does not close the connection.

Upvotes: 3

Josh Darnell
Josh Darnell

Reputation: 11433

Putting conn.close() in the finally seems good enough. I suppose after that, you could have another try-catch block where you attempt to execute a query against the database. If you get an exception, that will indicate (most likely) that your connection is closed completely.

Just a thought, hope that helps!

EDIT: Just to be clear, I mean doing something like this after you finally block (note that my Java syntax is a bit rusty, so this might not be exactly right, but you get the idea haha)

try
{
    s.executeQuery(sqlString);
}
catch(SQLException e)
{
    //examine error here to make sure it's because the connection is already closed
}

Upvotes: 2

Related Questions