We have Orion 1.1.37 with MySQL (mm.mysql driver). MySQL is used as a non-pooled
data-source. Everything works fine, but when server is left running for the night, at
the morning the DB connection has "crashed":
java.sql.SQLException: Lost connection to server during query
at org.gjt.mm.mysql.Connection.execSQL(Connection.java)
at org.gjt.mm.mysql.Connection.execSQL(Connection.java)
at org.gjt.mm.mysql.Statement.execute(Statement.java)
at org.gjt.mm.mysql.jdbc2.Statement.execute(Statement.java:114)
....
This happens in both Win NT and Linux.
Have you had similar problems? Is this a bug in the driver (as it would seem) or in
Orion, or a configuration issue?
Here's my datasource config:
<data-sources>
<data-source
name="Project data-source"
class="com.evermind.sql.ConnectionDataSource"
location="jdbc/ProjectDS"
inactivity-timeout="0"
max-connections="100"
pooled-location="jdbc/ProjectPooledDS"
xa-location="jdbc/xa/NProjectXADS"
ejb-location="jdbc/ProjectEJBDS"
url="jdbc:mysql://info02.infomates.net:3306/project"
connection-driver="org.gjt.mm.mysql.Driver"
/>
</data-sources>
