| Author |
Struts Web Application keeps hanging after 4 transacations with database
|
Sri chirat
Greenhorn
Joined: Aug 19, 2004
Posts: 3
|
|
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 ]
|
 |
Jeanne Boyarsky
internet detective
Marshal
Joined: May 26, 2003
Posts: 26496
|
|
Swetlana, Double check you are closing your connection to the database.
|
[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
|
 |
Sri chirat
Greenhorn
Joined: Aug 19, 2004
Posts: 3
|
|
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
|
 |
 |
|
|
subject: Struts Web Application keeps hanging after 4 transacations with database
|
|
|