You need a finally at the end of the try block's to make sure your
connections close. What could be happening is your connections are not being
closed from time to time. Most Oracle ora.ini files are set up for only 30
or so open connections (this is usually ok), but should never be more than
300
When you get the connection you will need to put it in a try and catch.
At the end use a finally to return the connection.
e.g.
try
{
Connection c = YourClass.getConnection();
}
catch (SQLException ex)
{
//Do something with the exception
}
finally
{
