Hi Carell, Carell, Michael wrote: > Hi, > > i really do not know what the MySQL Connector J does. MySQL Connector/J is a synonym for the JDBC driver for mySQL. > Fact is that > the application receives the following exception > > java.io.EOFException > at com.mysql.jdbc.MysqlIO.readFully I actually don't think that mySQL or Castor JDO is the problem. Let me ask you a couple of questions:
a) why do you need to keep a connection open for more than 8 hours ? b) how have you configured your connection pool. In other words, can you please show me the tomcat configuration file (assuming that you configured the pool in your server.xml file). > > I already configured the Tomcat to use a pooled Datasource and i > gave a SQL statement to able the database check by tomcat. But > nothing really helps. If i tried to create an object it failed. > > To get more information someone must debug / dig into the > Tomcat / ConnectorJ code. > > Thanks for your statement > Michael Carell > > -----Ursprüngliche Nachricht----- > Von: Stein M. Hugubakken [mailto:[EMAIL PROTECTED] > Gesendet: Freitag, 17. Juni 2005 12:24 > An: [email protected] > Betreff: Re: [castor-dev] JDO / MySQL DB reconnect problem > > > Carell, Michael wrote: > >>Hi again, >> >>perhaps you remember my email from some days before. I have had a >>problem with the MySQL DB and a timeout on the DB connection. >> >>After some investigations i found the source of the problem. MySQL >>disconnects idle connections after some time (may be 8 hours). >> > > > Why have a connection open for 8 hours, shouldn't it be the job for a > connection-pool to give you an open connection? > > Stein > > ------------------------------------------------- > If you wish to unsubscribe from this list, please > send an empty message to the following address: > > [EMAIL PROTECTED] > ------------------------------------------------- > > ------------------------------------------------- > If you wish to unsubscribe from this list, please > send an empty message to the following address: > > [EMAIL PROTECTED] > ------------------------------------------------- > > ------------------------------------------------- If you wish to unsubscribe from this list, please send an empty message to the following address: [EMAIL PROTECTED] -------------------------------------------------
