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).
The autoreconnect
flag that can be used if you create an DB connection works
only if autocommit
is true.
Because this is a
common problem application server are settings the
autocommit
to true after each
transaction - and set it back to false if a transaction is
startet.
May be it is worth
to think about if such an behaviour can be integrated into Castor
JDO.
The quick hack is
to ping the DB all X minutes - so the connection cannot
timeout.
Hope this helps
someone
Michael
Carell
