On 1/5/06, Dennis Bekkering <[EMAIL PROTECTED]> wrote: > I asked my provider and they didn't change anything. They pointed out the > possible absence of autoReconnect=true in my JDBC url. Does anybody knows if > that might help. I'd rather have that than a ping query for every call.
Hmm, autoReconnect = true might be ignored by the MySql driver when autoCommit is set to false for a transaction (e.g. http://lists.mysql.com/java/4928). This might be the case as the OJB doc for 1.0.4 suggests for your setting of useAutoCommit = 1: http://db.apache.org/ojb/docu/guides/repository.html#Attributes-N10127 You could try to set the custom attribute initializationCheck to true (as the above link suggests). Btw, I think (though I'm not sure) that the validation query is only used when a connection is retrieved from the connection pool. You could configrue one and check with P6Spy. Tom --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
