Datasource test connection fails in EAP 6
Issue
- The datasource fails the Test Connection with the message below. Tried other database on another database server and got same error message.
Unknown error
Unexpected HTTP response: 500
Request
{
"address" => [
("subsystem" => "datasources"),
("data-source" => "TestDS")
],
"operation" => "test-connection-in-pool"
}
Response
Internal Server Error
{
"outcome" => "failed",
"failure-description" => "JBAS010440: failed to invoke operation: JBAS010447: Connection is not valid",
"rolled-back" => true
}
- Datasource test connection fails with the below error in the
server.log:
15:44:01,491 WARN [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool] (HttpManagementService-threads - 187) IJ000604: Throwable while attempting to get a new connection: null: javax.resource.ResourceException: Could not create connection
at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:288) [ironjacamar-jdbc-1.0.23.1.Final-redhat-1.jar:1.0.23.1.Final-redhat-1]
at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:246) [ironjacamar-jdbc-1.0.23.1.Final-redhat-1.jar:1.0.23.1.Final-redhat-1]
---
---
Caused by: java.lang.NoSuchMethodError: com.microsoft.sqlserver.jdbc.Util.asGuidByteArray(Ljava/util/UUID;)[B
at com.microsoft.sqlserver.jdbc.SQLServerConnection.Prelogin(SQLServerConnection.java:1376)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1319)
---
---
Environment
- Red Hat JBoss Enterprise Application Platform (EAP)
- 6.x.x
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
