Christophe LE NABAT wrote:
>
> After some hours of inactivity, the connection of my connection pool closed
> and an exception is thrown :
> SQLException: Communication link failure: java.net.SocketException
MySQL is closing the connections after an amount of idle time (six
hours in default configuration, i think). You have to let JBoss close
the connections, too.
Change the following attributes in your jboss.jcml to true:
<attribute name="GCEnabled">true</attribute>
<attribute name="IdleTimeoutEnabled">true</attribute>
> Is it possible to have an example of database.xml?
> Because the parameters of Jboss seems different to the xml database file.
<database name="castorDB" engine="mysql">
<jndi name="java:/mySQL"/>
<mapping href="mapping.xml"/>
</database>
Ralf
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
