Can you provide your connection pool configuration, MySQL driver and
server versions ?
If possible, use "auto-commit" based validation itself with finest log
level (as indicated in the INFO message in server.log) for
"resource-adapter" using the command :
asadmin set-log-level javax.enterprise.resource.resourceadapter=FINEST
and post the complete stack trace from server.log ?
Thanks,
-Jagadish
On Mon, 2010-04-05 at 05:58 -0700, Sessizlik wrote:
> Hi,
>
> I tried to change my validation method. But when I try to change it, It does
> not show me which table I have to choose to validate.
>
> Did I miss something?
>
> Thanks
>
>
>
> Shalini Muthukrishnan wrote:
> >
> > Hi,
> >
> > Looks like some of the connections in your pool may have become stale or
> > invalid. The connection validation is turned on in your jdbc connection
> > pool and this will ensure that a connection taken from the pool is in a
> > healthy state.
> >
> > It may so happen that the autocommit values are cached by your jdbc
> > driver. Please change the validation method to "table" to see a more
> > realistic evalutation.
> >
> > HTH,
> > Shalini.
> >
> >
>