java - 无法在 Wildfly 10 中实例化驱动程序 SQLServerDriver

Question

我有以下错误:

15:02:34,434 ERROR [org.jboss.as.controller.management-operation] (ServerService Thread Pool -- 33) WFLYCTL0013: Operation ("add") failed - address: ([
    ("subsystem" => "datasources"),
    ("jdbc-driver" => "sqlserver")
]) - failure description: "WFLYJCA0034: Unable to instantiate driver class \"com.microsoft.jdbc.sqlserver.SQLServerDriver\". See log (WARN) for more details"

$JBOSS_HOME\modules\com\microsoft\sqlserver\main 中的module.xml:

<module xmlns="urn:jboss:module:1.1" name="com.microsoft.sqlserver" slot="main">

    <resources>
        <resource-root path="sqljdbc42.jar"/>
    </resources>

    <dependencies>
        <module name="javax.api"/>
        <module name="javax.transaction.api"/>
    </dependencies>
</module>

这是sqljdbc42.jar的内容

以及standalone.xml中的驱动定义

<driver name="sqlserver" module="com.microsoft.sqlserver">
    <driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver-class>
</driver>

请帮我找出我没看到的东西

更新:

For historic context: the "com.microsoft.jdbc.sqlserver" package is from the old SQL Server 2000 JDBC driver, they changed it somewhere around 2005 to "com.microsoft.sqlserver.jdbc" by Mark Rotteveel

Answer 1

从jar内容可以看出你驱动中的class包是错误的，试试

<driver name="sqlserver" module="com.microsoft.sqlserver">
    <driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>
</driver>