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

[Alexey S. (JIRA)]

Alexey S. created AS7-6624:
------------------------------

             Summary: 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: JPA / Hibernate
    Affects Versions: 7.1.1.Final
            Reporter: Alexey S.
            Assignee: Scott Marlow


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