[Logo]
Forums Register Login
Struts Web Application keeps hanging after 4 transacations with database
I am using Eclipse/Struts1.1/tomcat5.0/MySql

some of my applications are getting stuck after 4 or 5 inserts into the database, then on the tomcat console it keeps printing...

..org.apache.struts.legacy.GenericDatasource getConnection
INFO: check for timeout, activeCount=10, useCount=10
..org.apache.struts.legacy.GenericDatasource getConnection
INFO: sleep until next test....

this keeps printing on the console...I can't even stop the tomcat..

I know it is not problem with tomcat...because some of other applications
are working fine on same environment....

Any one saw this before...any ideas.....

Thanks in advance
[ August 19, 2004: Message edited by: swetlana chi ]
Swetlana,
Double check you are closing your connection to the database.
Thanks for the input...
I am closing the connection properly I believe....following is my DAO.java

public void addFamily(Familyclient familyclient)
throws DatastoreException, SQLException {
PreparedStatement psfamilyclient = null;
ResultSet rs=null;
try {
if (conn.isClosed()) {
throw new IllegalStateException("error.unexpected");
}
psfamilyclient = conn.prepareStatement(SQL_INSERT_FAMILY);
psfamilyclient.setString(1,familyclient.getHomeName());
......
psfamilyclient.execute();
psfamilyclient.close();
conn.close();
} catch (NumberFormatException nfe) {
nfe.printStackTrace();
} finally {
try {
if (psfamilyclient != null) {
psfamilyclient.close();
conn.close();
}
} catch (SQLException e) {
e.printStackTrace();
throw new RuntimeException("error.unexpected");
}
}
}

****Is this correct?

Thanks
Wink, wink, nudge, nudge, say no more ... https://richsoil.com/cards



All times above are in ranch (not your local) time.
The current ranch time is
Nov 22, 2017 15:01:44.