[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=12760322#comment-12760322 ] 

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

:) great. What is a connection between subscription and the bug in community version? Listen you can say: if you don't have a subscription do not open the bugs. That's an acceptable point of view (but very strange). But this is NOT what you said. You said "prove it". We proved. Why you reject the bug?
I dont think such policy is contributing much to the companies and individuals which wants to use JBoss, and I am very glad everybody reads our discussion
                
> 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