2 Replies Latest reply on Feb 22, 2017 3:32 AM by husseinco

    Failed to add datasource MySQL in Wildfly 10.1.0




      I found an issue when I deploying datasource of MySQL in Wildfly 10.1.0. I try to test the connection in the Administrator Console in the browser, that is the error:


      Unexpected HTTP response: 500



        "address" => [

        ("subsystem" => "datasources"),

        ("data-source" => "MySqlDS")


        "operation" => "test-connection-in-pool"



      Internal Server Error


        "outcome" => "failed",

        "failure-description" => "WFLYJCA0040: failed to invoke operation: WFLYJCA0047: Connection is not valid",

        "rolled-back" => true


      I installed the driver JAR for mysql mysql-connector-java-6.0.5

      I test the connection with the data base and I don't have any problem, I reload the Wildfly server and restarted and I obtain the same error,

      the JNDI that I used it:     java:/jboss/datasources/MySqlDS

      The URL connection is:  jdbc:mysql://localhost:3306/mcm_inventario


      Could anyone help me, please?

      Thank you for your time.