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

[Jesper Pedersen (JIRA)]

     [ https://issues.jboss.org/browse/AS7-6624?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jesper Pedersen closed AS7-6624.
--------------------------------

    Resolution: Rejected


Buy a subscription
                
> 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