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

    Failed to add datasource MySQL in Wildfly 10.1.0

    jonnathan.corredor
    jonnathan.corredor Jan 9, 2017 6:34 PM

      Hello,

       

      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

      Request

      {

        "address" => [

        ("subsystem" => "datasources"),

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

        ],

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

      }

      Response

      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.