tomcat and mysql

[Sury Balasubramanian]

Hello all,
I run tomcat connecting to two separate instances (one mySQL instance)
running on the same machine and the other one is oracle.

If i leave tomcat idle overnight and come back the next day, it doesn't
reconnect to mySQL even though i have the following in the JNDI settings..



<Resource   name="jdbc/mysql_gaeaglobalvrmanager"
            auth="Container"
            type="javax.sql.DataSource"
            driverClassName="com.mysql.jdbc.Driver"
            maxIdle="15"
            maxWait="10000"
            username="root"
            url="jdbc:mysql://localhost:3306/mscore?autoReconnect=true"
            maxActive="2000"
            removeAbandoned="true"
            removeAbandonedTimeout="60"/>

I dont have the reconnect option at all for oracle and the connection works
fine.

Is this a question to be posed to a mySQL forum. apologize if this is out of
place?

Thanks

Sury