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]

Reply via email to