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

[Scott Marlow (JIRA)]

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

Scott Marlow commented on AS7-6624:
-----------------------------------

https://community.jboss.org/en/jbossas7 is a better place to ask for help when your not sure if there is a bug.  If you are sure that you are experiencing a bug, try to [recreate with the latest AS version|https://community.jboss.org/thread/167590].

Also, when creating bugs, make sure that the "component(s)" match the bug description (JCA would of been better for this issue).
                
> 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