Failed to add datasource MySQL in Wildfly 10.1.0

[jonnathan.corredor]

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.

[husseinco]

Same issue but for MS sqlserver Please help

[husseinco]

I found a solution which is to remove the word (microsoft ) from the connection url ,
from <connection-url>jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=URDB</connection-url>
to be like this <connection-url>jdbc:sqlserver://localhost:1433;DatabaseName=URDB</connection-url>
and it will do the magic