Also, make sure you have a finally block that always closes the connection so the connection is returned to the pool.
Will Stranathan On Mon, 14 Mar 2005 15:27:29 -0700, George Sexton <[EMAIL PROTECTED]> wrote: > Look for something like this: > > Try { > statement.execUupdate("some statement"); > } catch (SQLException se){ > } > > Make sure that the catch has: > > conn.rollback(); > > > -----Original Message----- > > From: Larry Johnson [mailto:[EMAIL PROTECTED] > > Subject: tomcat freezes when accessing db after several queries > > > > Hi all, > > > > I've encountered a rather strange error that I need some help > > getting to the bottom of. Recently I lost the hard drive on > > one of my tomcat > > application servers. I've since reinstalled and set everything on the > > effected machine to mirror the configuration of my other app > > servers (which > > are working fine). However, now when I access the webapp on > > this server > > tomcat seems to freeze (like it's waiting for something) after several > > queries to the database are executed. After this happens I am --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]