[jboss-jira] [JBoss JIRA] (AS7-6624) Jboss connection pool is not auto reconnects to mySQl (XA-datasource)

[Alexey S. (JIRA)]

    [ https://issues.jboss.org/browse/AS7-6624?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12760304#comment-12760304 ] 

Alexey S. commented on AS7-6624:
--------------------------------

Hello again.

We provided in https://community.jboss.org/message/801760 the detailed test case, including code, EAR archive, configuration etc.
During two week we didn't get any proof that the mess was in our side, misconfiguration etc.
Therefor we consider it as full evidence of the fact that this is a critical issue in Jboss 7.1.1.
We'll be glad to provide any other infos, codes, test cases  etc, but we think that this bug should be reopened.

Best Regards,
Alexey
                
> Jboss connection pool is not auto reconnects to mySQl (XA-datasource)
> ---------------------------------------------------------------------
>
>                 Key: AS7-6624
>                 URL: https://issues.jboss.org/browse/AS7-6624
>             Project: Application Server 7
>          Issue Type: Bug
>          Components: JCA
>    Affects Versions: 7.1.1.Final
>            Reporter: Alexey S.
>            Assignee: Stefano Maestri
>
> I am using JPA Hibernate in Timer EJB.
> After MySQL's restarted, JBOSS connection pool should be restarted also to renew the transaction, but it doesnt happened.
> my datasource is
>   <xa-datasource jndi-name="java:jboss/datasources/db" pool-name="db" enabled="true" use-java-context="true">
>                     <xa-datasource-property name="ServerName">
>                         localhost
>                     </xa-datasource-property>
>                     <xa-datasource-property name="DatabaseName">
>                         db
>                     </xa-datasource-property>
>                     <xa-datasource-property name="User">
>                         root
>                     </xa-datasource-property>
>                     <xa-datasource-property name="Password">
>                         xxxxx
>                     </xa-datasource-property>
>                     <xa-datasource-property name="AutoReconnectForPools">
>                         true
>                     </xa-datasource-property>
>                     <xa-datasource-property name="FailOverReadOnly">
>                         false
>                     </xa-datasource-property>
>                     <xa-datasource-property name="MaxReconnects">
>                         100
>                     </xa-datasource-property>
>                     <xa-datasource-property name="ReconnectAtTxEnd">
>                         true
>                     </xa-datasource-property>
>                     <driver>com.mysql</driver>
>                     <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
>                     <validation>
>                         <valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.mysql.MySQLValidConnectionChecker"/>
>                         <check-valid-connection-sql>select 1</check-valid-connection-sql>
>                         <exception-sorter class-name="org.jboss.jca.adapters.jdbc.extensions.mysql.MySQLExceptionSorter"/>
>                     </validation>
>                 </xa-datasource>

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira