I've seen this error happen before due to a hot-deploy of a -ds.xml file but I'm now getting this error without a hot-deploy. If I restart the server, everything will be OK for a couple of days, and then we get problems again.
My datasource is configured in a file outside of the EAR and the contents are:
<no-tx-datasource>
<jndi-name>messagingplatform_prod_DS</jndi-name>
<connection-url>jdbc:mysql:/the_ip_of_the_server:3306/database_name</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<user-name>myusername</user-name>
<password>mypassword</password>
<max-pool-size>40</max-pool-size>
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>
<check-valid-connection-sql>select 'x'</check-valid-connection-sql>
</no-tx-datasource>
Can anyone think of any reasons why this error might just start happening?
