]
Tomaz Cerar closed WFLY-6408.
-----------------------------
Assignee: (was: Jason Greene)
Resolution: Rejected
This is type of discussion that belongs to user forums not bug tracker.
Forums can be found at
Failed to add datasource of sql server in Wildfly 9
---------------------------------------------------
Key: WFLY-6408
URL:
https://issues.jboss.org/browse/WFLY-6408
Project: WildFly
Issue Type: Bug
Reporter: vlad ZHANG
Hello,
I encounter a problem in deploying datasource of sql server in Wildfly 9.
The Wildfly version I have downloaded is Wildfly 9.2.0.Final. I added a user and entered
the Administrator Console in a browser.
The sql server version I have downloaded is sql server 2008. I want to deploy a
datasource of sql server.
I started to download a JDBC Driver. The version I have downloaded is "Microsoft
JDBC Drivers 6.0 (Preview), 4.2, 4.1, and 4.0 for SQL Server" from
"https://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=11774".
I succeeded in adding this driver by choosing deployment--->add--->Upload a new
deployment in the Administration Console. But when I try to add a datasource, I had a
problem.
In the "configuration" of Administration Console, I chose
Subsystems--->Datasources--->Non-XA--->add. Then I chose the driver I had
deployed. But I always cannot create this datasource, the error is always:
Failed to create JDBC connection.
An internal error occurred.
Unexpected HTTP response: 500
Request
{
"address" => [
("subsystem" => "datasources"),
("data-source" => "MSSQLDS")
],
"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,
"response-headers" => {"process-state" =>
"reload-required"}
}
And I don't know why. Could anyone help me, please? Thank you in advance.