11 Replies Latest reply on Jun 9, 2015 9:40 AM by Harald Pehl

    Wildfly 9.0.0.cr1 Unable to connect to MySQL database

    Travis Salyer Newbie

      I 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:

      MySQL_Connector_Data.png

       

      Any help on this matter would be greatly appreciated!

       

      Thanks

       

       

      Travis