Wildfly 9.0.0.cr1 Unable to connect to MySQL database
travis_salyer Jun 3, 2015 2:34 PMI have been working on setting up a Domain Controller in the "full" profile, and I am running into problems getting the MySQL connection to work properly.
After setting it up and clicking on the "Test Connection" button on the Configuration > Connector > Datasources page, a dialog pops up stating "Failed to create JDBC connection: There are no running servers bound to this datasource.". My database is setup and running on the MySQL version 5.6.16, and can access it from the command prompt. I have also bound the latest MySQL connector of version 5.1.24, in the jdbc-driver page of the Management Model dialog.
Further more, upon enabling the datasource the following line is output in the console.
2015-06-03 10:59:48,317 INFO [org.jboss.as.controller.management-deprecated] (XNIO-1 task-10) WFLYCTL0028: Attribute enabled is deprecated, and it might be removed in future version!
My domain.xml datasource is as followed:
<datasource jta="true" jndi-name="java:/prioritization_tool" pool-name="prioritization_tool" enabled="true" use-ccm="true" statistics-enabled="true">
<connection-url>jdbc:mysql://localhost:3306/prioritization_tool</connection-url>
<driver>mysql</driver>
<pool>
<min-pool-size>10</min-pool-size>
<initial-pool-size>0</initial-pool-size>
<max-pool-size>100</max-pool-size>
<prefill>true</prefill>
<allow-multiple-users>false</allow-multiple-users>
</pool>
<security>
<user-name>sa</user-name>
<password>sa</password>
</security>
<validation>
<valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.mysql.MySQLValidConnectionChecker"/>
<check-valid-connection-sql>select 1</check-valid-connection-sql>
<validate-on-match>false</validate-on-match>
<background-validation>true</background-validation>
<use-fast-fail>false</use-fast-fail>
<exception-sorter class-name="org.jboss.jca.adapters.jdbc.extensions.mysql.MySQLExceptionSorter"/>
</validation>
<timeout>
<set-tx-query-timeout>false</set-tx-query-timeout>
<blocking-timeout-millis>30000</blocking-timeout-millis>
<idle-timeout-minutes>5</idle-timeout-minutes>
<query-timeout>0</query-timeout>
<use-try-lock>0</use-try-lock>
<allocation-retry>0</allocation-retry>
<allocation-retry-wait-millis>0</allocation-retry-wait-millis>
</timeout>
<statement>
<prepared-statement-cache-size>250</prepared-statement-cache-size>
<share-prepared-statements>true</share-prepared-statements>
</statement>
</datasource>
<drivers>
<driver name="h2" module="com.h2database.h2">
<xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class>
</driver>
<driver name="mysql" module="com.mysql">
<xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class>
</driver>
</drivers>
A screenshot of the MySQL Connector data:
Any help on this matter would be greatly appreciated!
Thanks
Travis