RE: mySQL-servlet problem: - Rob Greene - com.mysql.lists.java

5 messages in com.mysql.lists.javaRE: mySQL-servlet problem:

From	Sent On	Attachments
Alker	19 Mar 2000 04:02
Rob Greene	19 Mar 2000 08:15
Mark Matthews	19 Mar 2000 09:40
Tom Quick	20 Mar 2000 03:54
Jitendra Pradhan	20 Mar 2000 06:22

Subject:	RE: mySQL-servlet problem:
From:	Rob Greene (rgre...@pcpros.net)
Date:	03/19/2000 08:15:46 AM
List:	com.mysql.lists.java

I can get you part way as I've run into this with some Oracle servlets I've worked on... the database connection is disconnected after a certain amount of inactivity. I think with MySQL, it's 8 hours or so. One solution would be to check the connection each time (ick) or get a database pooling product (open source or otherwise). A couple I've downloaded and haven't had the time to play with are DbConnectionBroker and PoolMan. The database pooling products will ensure that you've got good connections when requesting them from the pool. -Rob

-----Original Message----- From: Alker [mailto:Raim...@Student.Uni-Augsburg.de] Sent: Sunday, March 19, 2000 6:03 AM To: ja...@lists.mysql.com Subject: mySQL-servlet problem:

Hi everyone!

I have a bad problem with mySQL, jserv & the mm.mysql drivers:

On my local system i use SuSE 6.3, Apache 1.3.6, mySQL 3.22.25 and the blackdown JDK1.2.2. Servlets work fine!

The webserver has (as i know) the same configuration, but when using a servlet connecting to the mysql database, about 24 hours after uploading, the servlet does not retrieve any data from the database (as it has done through 24 hours).

Instead of the data following message is given:

java.sql.SQLException: Error during query: Unexpected Exception: java.sql.SQLException message given: Communication link failure: java.io.IOException

If i´m uploading the same servlet again, it works fine again without restarting the mysql server or anything else for the same 24 hours.

Can anybody help me???

Thanks in advance!!

To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail java...@lists.mysql.com instead.