i added
testOnBorrow="true"
validationQuery="SELECT 1"
to the descriptor, I'l wait and see what happens.
Dennis
2006/1/5, Thomas Dudziak <[EMAIL PROTECTED]>:
>
> 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]
>
>
--
mvg,
Dennis
