Hi,
I am using mysql-connector-5.1.5 and my server is GFv3.
My connection pool configuration is like this.
<jdbc-resource pool-name="TestDSPool" jndi-name="TestDS" />
<jdbc-connection-pool connection-validation-method="auto-commit"
datasource-classname="com.mysql.jdbc.jdbc2.optional.MysqlXADataSource"
res-type="javax.sql.XADataSource" name="TestDSPool"
is-connection-validation-required="true" allow-non-component-callers="true">
<property name="password" value="yyyyyyyyyyyy" />
<property name="username" value="xxxxxxxxxxx" />
<property name="URL" value="jdbc:mysql://x.x.x.x/myapplication" />
</jdbc-connection-pool>
My log file is here
http://old.nabble.com/file/p28141042/log.txt log.txt
Thanks
Jagadish Prasath Ramu wrote:
>
> 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.
>> >
>> >
>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe_at_glassfish.dev.java.net
> For additional commands, e-mail: users-help_at_glassfish.dev.java.net
>
>
>
--
View this message in context: http://old.nabble.com/AutoCommit-based-validation-detected-invalid-connection-tp28137666p28141042.html
Sent from the java.net - glassfish users mailing list archive at Nabble.com.