aspose file tools*
The moose likes Struts and the fly likes Struts Web Application keeps hanging after 4 transacations with database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Frameworks » Struts
Bookmark "Struts Web Application keeps hanging after 4 transacations with database" Watch "Struts Web Application keeps hanging after 4 transacations with database" New topic
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
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 30764
    
156

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
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Struts Web Application keeps hanging after 4 transacations with database