I've checked my code and verified that both these measures are implemented where I query the db. However, I don't think my problem has to do with the code itself because I'm running versions identical to that of the problem machine on my other app servers and those are running without a hitch.
Larry -----Original Message----- From: William Stranathan [mailto:[EMAIL PROTECTED] Sent: Monday, March 14, 2005 5:35 PM To: Tomcat Users List Subject: Re: tomcat freezes when accessing db after several queries 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]