-
1. Re: Reconnecting after a MySQL failure
dnovo Feb 18, 2015 10:29 AM (in response to meetoblivion)Try this
<datasource jndi-name="java:jboss/datasources/MySqlDS" pool-name="MySqlDS" enabled="true">
<connection-url>${jdbc.url}</connection-url>
<driver>com.mysql</driver>
<transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
<new-connection-sql>SELECT 1</new-connection-sql>
<pool>
<min-pool-size>10</min-pool-size>
<max-pool-size>100</max-pool-size>
<prefill>true</prefill>
</pool>
<security>
<user-name>${jdbc.user}</user-name>
<password>${jdbc.pass}</password>
</security>
<validation>
<check-valid-connection-sql>SELECT 1</check-valid-connection-sql>
</validation>
<statement>
<prepared-statement-cache-size>32</prepared-statement-cache-size>
<share-prepared-statements>true</share-prepared-statements>
</statement>
</datasource>
-
2. Re: Reconnecting after a MySQL failure
meetoblivion Feb 18, 2015 11:08 AM (in response to dnovo)Thanks, almost did it. I added more to the validation section as well.
<validation>
<validate-on-match>true</validate-on-match>
<background-validation>false</background-validation>
<check-valid-connection-sql>SELECT 1</check-valid-connection-sql>
<valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.mysql.MySQLValidConnectionChecker" />
<exception-sorter class-name="org.jboss.jca.adapters.jdbc.extensions.mysql.MySQLExceptionSorter" />
</validation>