[
https://issues.jboss.org/browse/AS7-6624?page=com.atlassian.jira.plugin.s...
]
Alexey S. commented on AS7-6624:
--------------------------------
Jesper, I dont understand why it rejected? Are you saying this is not a bug? I give all
needed information for reproduce, in the user forums it seems that similar problems are
unresolved not only at my thread but also in similar threads, so why its rejected?
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