Hi Dirk, I made the changes according to your suggestions. But I am still getting the exception after 8 hours of inactive time.
My db connection URL looks like this: jdbc:mysql://localhost:3306/datavase?autoReconnect=true&autoReconnectForPools=true Is it correct? On 4/13/05, Dirk Verbeeck <[EMAIL PROTECTED]> wrote: > The first config doesn't work, that should be something like: > <set-property property="connectionProperties" > value="autoReconnect=true" /> > > but most people use your second solution (the url version) > > -- Dirk > > Sanjeet Joshi wrote: > > > Hi, > > > > I am facing a problem with Connections to the database. > > > > Here is the development environment in short: > > > > Struts, Jsp, Servlets and MySQL 4.1 > > I am using DBCP connection pooling. The datasource configuration is > > in struts-config.xml file. I am using container managed security for > > authentication. > > > > I get EOFException when I try to login (or access the db for any other > > purpose). This happens only after a long period of db inactivity. > > Otherwise everything works fine. > > > > When I searched for a solution, I found out that MySQL closes all > > inactive connections after 8 hours. I also found out that setting a > > MySQL attribute autoReconnect=true solves this. I tried setting it > > along with my datasource config in struts-config.xml as follows: > > > > <data-sources> > > <data-source key="xyz" > > type="org.apache.commons.dbcp.BasicDataSource"> > > <set-property property="driverClassName" > > value="com.mysql.jdbc.Driver" /> > > <set-property property="url" > > value="jdbc:mysql://localhost:3306/xyz" /> > > <set-property property="autoReconnect" value="true" /> > > <set-property property="username" value="***" /> > > <set-property property="password" value="***" /> > > </data-source> > > </data-sources> > > > > Is this the correct way of setting autoReconnect to true? Some > > solutions suggested setting it along with the url i.e. like > > > > <set-property property="url" > > value="jdbc:mysql://localhost:3306/xyz?autoReconnect=true" /> > > > > Which of these is correct? > > > > To test this solution I tried to reduce the wait_timeout and > > interactive_timeout (both MySQL variables) from 8 hours to one minute. > > The connections were closed after a minutes inactivity. But my webapp > > worked absolutely fine (without autoReconnect="true") So I could not > > get EOFException on my development machine. > > > > Is there anyone who has faced this problem and solved it? Any Pointers > > to any reading material about this? > > > > Any help is appreciated. > > > > Thanks in advance. > > Sanjeet > > > > --------------------------------------------------------------------- > > 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] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
