JBoss 双数据源配置。sql server的报错，不能创建连接问题

收获de季节 2015-04-23 04:21:55

错误代码如下
----------------------------------------------------------------------------------------------------
16:10:14,315 WARN [org.jboss.as.connector.subsystems.datasources] (ServerService Thread Pool -- 27) JBAS010402: Unable to instantiate driver class "com.microsoft.sqlserver.jdbc.SQLServerXADataSource": java.lang.ClassCastException: class com.microsoft.sqlserver.jdbc.SQLServerXADataSource
16:10:14,331 ERROR [org.jboss.as.controller.management-operation] (ServerService Thread Pool -- 27) Operation ("add") failed - address: ([
("subsystem" => "datasources"),
("jdbc-driver" => "mssqlxa")
]) - failure description: "JBAS010434: Unable to instantiate driver class \"com.microsoft.sqlserver.jdbc.SQLServerXADataSource\". See log (WARN) for more details"

-----------------------------------------------------------------------------------------------------

环境：
应用服务器：jboss 7.1
数据库：oracle SQL Server 2008
jboss的配置文件方式如下：

<datasources>

                <datasource jndi-name="java:jboss/datasources/JBLDB" pool-name="JBLDB" enabled="true" use-java-context="true">

                    <connection-url>jdbc:oracle:thin:@12.1.3.123:1521:ds</connection-url>

                    <driver>com.oracle</driver>

                    <pool>

                        <min-pool-size>5</min-pool-size>

                        <max-pool-size>50</max-pool-size>

                        <prefill>true</prefill>

                    </pool>

                    <security>

                        <user-name>dds</user-name>

                        <password>dsafdda</password>

                    </security>

                    <validation>

                        <check-valid-connection-sql>SELECT 1 from dual</check-valid-connection-sql>

                        <validate-on-match>false</validate-on-match>

                        <background-validation>false</background-validation>

                        <use-fast-fail>false</use-fast-fail>

                    </validation>

                </datasource>

                <datasource jndi-name="java:jboss/datasources/mssql" pool-name="mssql" enabled="true" use-java-context="true">

                    <connection-url>jdbc:sqlserver://12.1.9.12:1433;database=TestData</connection-url>

                    <driver>mssqlxa</driver>

                    <pool>

                        <min-pool-size>1</min-pool-size>

                        <max-pool-size>3</max-pool-size>

                        <prefill>true</prefill>

                    </pool>

                    <security>

                        <user-name>123sd</user-name>

                        <password>123456</password>

                    </security>

                    <validation>

                        <check-valid-connection-sql>select getdate()</check-valid-connection-sql>

                        <validate-on-match>false</validate-on-match>

                        <background-validation>false</background-validation>

                        <use-fast-fail>false</use-fast-fail>

                    </validation>

                </datasource>

                <drivers>

                    <driver name="com.oracle" module="com.oracle">

                        <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>

                    </driver>

                    <driver name="mssqlxa" module="com.microsoft.sqlserver.jdbc">

                        <xa-datasource-class>com.microsoft.sqlserver.jdbc.SQLServerXADataSource</xa-datasource-class>

                    </driver>

                </drivers>

            </datasources>