Jboss可以建立两个以上的数据源吗？

Question

配两个mssql-service.xml 不行？（文件名当然不一样）

Answer 1

我已经搞定了！！
下一贴我把mssql-service.xml发上！

Answer 2

<?xml version="1.0" encoding="UTF-8"?>
<server>
<!-- ===================================================================== -->
<!--                                                                       -->
<!--  第一个数据源                                                         -->
<!--                                                                       -->
<!-- ===================================================================== -->
  <mbean code="org.jboss.resource.connectionmanager.LocalTxConnectionManager" name="jboss.jca:service=LocalTxCM,name=MSSQLDS">
    <depends optional-attribute-name="ManagedConnectionFactoryName">
      <mbean code="org.jboss.resource.connectionmanager.RARDeployment" name="jboss.jca:service=LocalTxDS,name=MSSQLDS">        <attribute name="JndiName">MSSQLDS</attribute>        <attribute name="ManagedConnectionFactoryProperties">
          <properties>
            <config-property name="ConnectionURL" type="java.lang.String">jdbc:JSQLConnect://localhost/database=Account</config-property>
            <config-property name="DriverClass" type="java.lang.String">com.jnetdirect.jsql.JSQLDriver</config-property>
            <config-property name="UserName" type="java.lang.String">sa</config-property>
            <config-property name="Password" type="java.lang.String">1023</config-property>
          </properties>
        </attribute>
        <depends optional-attribute-name="OldRarDeployment">jboss.jca:service=RARDeployment,name=JBoss LocalTransaction JDBC Wrapper</depends>
      </mbean>
    </depends>    <depends optional-attribute-name="ManagedConnectionPool">
      <mbean code="org.jboss.resource.connectionmanager.JBossManagedConnectionPool" name="jboss.jca:service=LocalTxPool,name=MSSQLDS">        <attribute name="MinSize">0</attribute>
        <attribute name="MaxSize">50</attribute>
        <attribute name="BlockingTimeoutMillis">5000</attribute>
        <attribute name="IdleTimeoutMinutes">15</attribute>
        <attribute name="Criteria">ByContainer</attribute>
      </mbean>    </depends>
    <depends optional-attribute-name="CachedConnectionManager">jboss.jca:service=CachedConnectionManager</depends>    <depends optional-attribute-name="JaasSecurityManagerService">jboss.security:service=JaasSecurityManager</depends>    <attribute name="TransactionManager">java:/TransactionManager</attribute>
    <depends>jboss.jca:service=RARDeployer</depends>  </mbean><!-- ===================================================================== -->
<!--                                                                       -->
<!--  第二个数据源                                                         -->
<!--                                                                       -->
<!-- ===================================================================== -->  
    <mbean code="org.jboss.resource.connectionmanager.LocalTxConnectionManager" name="jboss.jca:service=LocalTxCM,name=MSSQLDSCard">
    <depends optional-attribute-name="ManagedConnectionFactoryName">
      <mbean code="org.jboss.resource.connectionmanager.RARDeployment" name="jboss.jca:service=LocalTxDS,name=MSSQLDSCard">        <attribute name="JndiName">MSSQLDSCard</attribute>        <attribute name="ManagedConnectionFactoryProperties">
          <properties>
            <config-property name="ConnectionURL" type="java.lang.String">jdbc:JSQLConnect://localhost/database=Card</config-property>
            <config-property name="DriverClass" type="java.lang.String">com.jnetdirect.jsql.JSQLDriver</config-property>
            <config-property name="UserName" type="java.lang.String">sa</config-property>
            <config-property name="Password" type="java.lang.String">1023</config-property>
          </properties>
        </attribute>
        <depends optional-attribute-name="OldRarDeployment">jboss.jca:service=RARDeployment,name=JBoss LocalTransaction JDBC Wrapper</depends>
      </mbean>
    </depends>    <depends optional-attribute-name="ManagedConnectionPool">
      <mbean code="org.jboss.resource.connectionmanager.JBossManagedConnectionPool" name="jboss.jca:service=LocalTxPool,name=MSSQLDSCard">        <attribute name="MinSize">0</attribute>
        <attribute name="MaxSize">50</attribute>
        <attribute name="BlockingTimeoutMillis">5000</attribute>
        <attribute name="IdleTimeoutMinutes">15</attribute>
        <attribute name="Criteria">ByContainer</attribute>
      </mbean>    </depends>
    <depends optional-attribute-name="CachedConnectionManager">jboss.jca:service=CachedConnectionManager</depends>    <depends optional-attribute-name="JaasSecurityManagerService">jboss.security:service=JaasSecurityManager</depends>    <attribute name="TransactionManager">java:/TransactionManager</attribute>
    <depends>jboss.jca:service=RARDeployer</depends>  </mbean>
</server>