紧急求救!!!在jboss中怎样配置多个数据库。。。。（在线等）

Question

http://www.csdn.net/develop/article/26/26474.shtm
http://www.csdn.net/develop/article/26/26790.shtm上面两个帖子是教你怎么配置JBoss中的Datasource的，你如果要用多个数据库，可以把mssql-ds.xml（见上面帖子）中的内容复制一下，然后修改为对应不同数据库的
<?xml version="1.0" encoding="UTF-8"?>
<datasources>
  <local-tx-datasource>
    <jndi-name>MySql</jndi-name>
    <connection-url>jdbc:mysql://10.0.0.18:3306/test</connection-url>
    <driver-class>org.gjt.mm.mysql.Driver</driver-class>
    <user-name>root</user-name>
    <password></password>
  </local-tx-datasource>
</datasources>

Answer 1

每一个ejb都对应一个数据库而不是同一数据库的表，这样做的目的是什么呢？那就要为建立多个数据源，方法就是
<datasources>
<local-tx-datasource>
</local-tx-datasource>
<local-tx-datasource>
</local-tx-datasource>
<local-tx-datasource>
</local-tx-datasource>
</datasources>

Answer 2

单个数据库的已经成功了得，但是不同的CMP对应不同数据库的就行不通，只能插入一个数据库，不知道该怎么修改那几个配置文件，能否讲详细点谢谢了

Answer 3

虽然没有做过，但是我想是可以的，当你在mssql-ds.xml配置好多个数据源后，只要为每个ejb指定相应的数据源就应该可以了，每个ejb在jbossscmp-jdbc.xml中都如下写：<entity>
         <ejb-name>A</ejb-name>
<datasource>java:/MSSQLDS</datasource>
<datasource-mapping>MS SQLSERVER2000</datasource-mapping>
         <create-table>true</create-table>
         <table-name>a</table-name>
         <cmp-field>
         </cmp-field>
         ......
</entity>        <entity>
         <ejb-name>B</ejb-name>
<datasource>java:/MSSQLDS2</datasource>
<datasource-mapping>MS SQLSERVER2000</datasource-mapping>
         <create-table>true</create-table>
         <table-name>a</table-name>
         <cmp-field>
         </cmp-field>
         ......
</entity>        

Answer 4

我的jbossscmp-jdbc.xml实在jb中自动生成的，里面没有<datasource>这个tag，我手懂加上去后发布，jboss报错，说不允许有<datasource>，以至jbossscmp-jdbc.xml无效，请问到底该怎么给每个CMP指定一个数据源呢

Answer 5

一个CMP可以定义一个jar或者是EJB模型
每个模型可以使用一个jbossscmp-jdbc.xml
这样看看
我想应该是可以的
JB中应该里有<datasource>这个tag
我的JB9生成的例子
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE jbosscmp-jdbc PUBLIC "-//JBoss//DTD JBOSSCMP-JDBC 3.2//EN" "http://www.jboss.org/j2ee/dtd/jbosscmp-jdbc_3_2.dtd">
<jbosscmp-jdbc>
    <defaults>
        <datasource>java:/MSSQLDS</datasource>
        <datasource-mapping>MS SQLSERVER2000</datasource-mapping>
        <fk-constraint>true</fk-constraint>
    </defaults>
    <enterprise-beans>
        <entity>
            <ejb-name>TblUser</ejb-name>
            <table-name>tbl_user</table-name>
            <cmp-field>
                <field-name>email</field-name>
                <column-name>email</column-name>
            </cmp-field>
            <cmp-field>
                <field-name>password</field-name>
                <column-name>password</column-name>
            </cmp-field>
        </entity>
        <entity>
            <ejb-name>UserInfo</ejb-name>
            <table-name>UserInfo</table-name>
            <cmp-field>
                <field-name>firstName</field-name>
                <column-name>firstName</column-name>
            </cmp-field>
            <cmp-field>
                <field-name>middleName</field-name>
                <column-name>middleName</column-name>
            </cmp-field>
            <cmp-field>
                <field-name>lastName</field-name>
                <column-name>lastName</column-name>
            </cmp-field>
            <cmp-field>
                <field-name>email</field-name>
                <column-name>email</column-name>
            </cmp-field>
            <cmp-field>
                <field-name>dept</field-name>
                <column-name>dept</column-name>
            </cmp-field>
            <cmp-field>
                <field-name>workPhone</field-name>
                <column-name>workPhone</column-name>
            </cmp-field>
            <cmp-field>
                <field-name>extention</field-name>
                <column-name>extention</column-name>
            </cmp-field>
            <cmp-field>
                <field-name>homePhone</field-name>
                <column-name>homePhone</column-name>
            </cmp-field>
            <cmp-field>
                <field-name>employee</field-name>
                <column-name>Employee</column-name>
            </cmp-field>
        </entity>
        <entity>
            <ejb-name>LocalRole</ejb-name>
            <table-name>LocalRole</table-name>
            <cmp-field>
                <field-name>name</field-name>
                <column-name>name</column-name>
            </cmp-field>
            <cmp-field>
                <field-name>description</field-name>
                <column-name>description</column-name>
            </cmp-field>
        </entity>
    </enterprise-beans>
    <relationships>
        <ejb-relation>
            <ejb-relation-name>tblUser-userInfo</ejb-relation-name>
            <foreign-key-mapping />
            <ejb-relationship-role>
                <ejb-relationship-role-name>TblUserRelationshipRole</ejb-relationship-role-name>
                <key-fields>
                    <key-field>
                        <field-name>email</field-name>
                        <column-name>email</column-name>
                    </key-field>
                </key-fields>
            </ejb-relationship-role>
            <ejb-relationship-role>
                <ejb-relationship-role-name>UserInfoRelationshipRole</ejb-relationship-role-name>
            </ejb-relationship-role>
        </ejb-relation>
        <ejb-relation>
            <ejb-relation-name>userInfo-localRole</ejb-relation-name>
            <relation-table-mapping />
        </ejb-relation>
    </relationships>
</jbosscmp-jdbc>

Answer 6

拿不同数据源的CMP不能放在一个模型里吗？必须分开？？我在jb9中自动生成的jbosscmp-jdbc.xml怎么会没有<datasource〉,有没有人实际做过配置多个数据库的？

Answer 7

找到问题所在了，就再standardjbosscmp-jdbc.xml，里面<defaults>的datasource我设置了一个，所以就只能插入一张表，可是我该怎么设置两个呢？另外standardjbosscmp-jdbc.xml和jbosscmp-jdbc.xml能共存吗？两个文件是否都有用？