Thanks for your hint. The PDF can be reached at:
http://www.tv-wetzlar-badminton.de/errorMessageTomcat.pdf
the code from the Method conOK:
public boolean conOK(int pointer) {
PreparedStatement pstmt = null;
try {
pstmt = con[pointer].prepareStatement("SELECT * FROM kostensaetze");
pstmt.executeQuery();
} catch (Exception e) {
return false;
} finally {
try {
if (pstmt != null)
pstmt.close();
} catch (Exception e) {}
}
return true;
}
This method should test if the connection is still ok. I hope someone can help
me.
tia, Oli
PS:
I think the DB close the connection while the tomcat is running and I don't
know (at my Connection-Pool) how to know when that happened. Because isClosed()
don’t care about that problem. :-(
> -----Ursprüngliche Nachricht-----
> Von: Propes, Barry L [mailto:[EMAIL PROTECTED]
> Gesendet: Mittwoch, 4. Oktober 2006 23:27
> An: Tomcat Users List; [EMAIL PROTECTED]
> Betreff: RE: error while running a webapp
>
> pdf didn't come through.
>
> -----Original Message-----
> From: Oliver Wagner [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, October 04, 2006 4:21 PM
> To: users@tomcat.apache.org
> Subject: error while running a webapp
>
>
> Hello,
> I wrote a web application (JSPs, Beans, JDBC and MYSQL) and use the tomcat
> container. But if the container runs a while the strange error occurs. I
> don't know how to solve this problem. While the problem occurs the other
> web applications are still running without a problem. After a restart of
> the tomcat-Container the problem is gone and the web application (with the
> problem before) works again - but some hours later the error comes again.
>
> I attached the message as a pdf-File and hope someone can help me to solve
> the problem, because I don't have any ideas anymore.
>
> Tia and greets
>
> Oli
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
