...This is entitled "Know Thy Driver" :-)
After Holger's email I started digging inside the driver code, and it turns
out that the solution can be external to Cayenne. Simple parameter passed
to MySQL JDBC driver will enable automated reconnect. Database URL of a
MySQL data node should be something like this:
jdbc:mysql://localhost/test?autoReconnect=true
Bingo, it simply works!! (For the tests I used
mysql-connector-java-2.0.14). We should document such things somewhere in
the FAQ...
Andrus
At 03:38 AM 1/5/2003 +0100, Holger Hoffstätte wrote:
>Andrus,
>
> > The problem with ConnectionEventListener is that the pooled connection
> > wrapper is not in the stack trace, so pool objects can't catch such
> > exceptions and are generally unaware of them. If you look at these lines:
>
>That doesn't look right (or maybe I'm just too tired - it's 3:40 AM here
>in Germany). PoolManager already implements the ConnectionEventListener
>error handling methods, and if they are not triggered by ConnectEvents I'd
>say the driver is at fault.
>Have you tried the new 3.0.3beta driver form mysql.com? It's a drop-in
>replacement but much, much newer with lots of bug fixes, I've been using
>it without problems. Maybe it does the right thing?
>
>Holger
This archive was generated by hypermail 2.0.0 : Sat Jan 04 2003 - 22:03:49 EST