EAP 6.3中如何在persistence.xml中添加2个DBs

Question

我们在一个名为MyProject的项目中引用了两个不同的数据库连接，即'NBDX'和'NBPTS'。我们已经将JBoss5迁移到EAP6.3。我指定了两个不同的perisistence.xml文件。

meta-inf/persistence.xml中的第一个

 <persistence xmlns="http://java.sun.com/xml/ns/persistence"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd"
version="2.0">
<persistence-unit name="nbpts">
    <class>com.myproject.persistence.BookletCode</class>
    <class>com.myproject.persistence.ClipData</class>
    <class>com.myproject.persistence.CronJob</class>
    <class>com.myproject.persistence.ExerciseCodePK</class>
    <class>com.myproject.persistence.ExerciseCode</class>
    <class>com.myproject.persistence.ExportFile</class>
    <class>com.myproject.persistence.Hold</class>
    <class>com.myproject.persistence.InputFile</class>
    <class>com.myproject.persistence.InputRecord</class>
    <class>com.myproject.persistence.MessageLog</class>
    <class>com.myproject.persistence.NbricCodePK</class>
    <class>com.myproject.persistence.NbricCode</class>
    <class>com.myproject.persistence.OEMappingPK</class>
    <class>com.myproject.persistence.OEMapping</class>
    <class>com.myproject.persistence.OERecord</class>
    <class>com.myproject.persistence.Parameters</class>
    <class>com.myproject.persistence.PostEditData</class>
    <class>com.myproject.persistence.PreidRecord</class>
    <class>com.myproject.persistence.ProcessLog</class>
    <class>com.myproject.persistence.Response</class>
    <class>com.myproject.persistence.Score</class>
    <class>com.myproject.persistence.SetupFilePK</class>
    <class>com.myproject.persistence.SetupFile</class>
    <class>com.myproject.persistence.SftpConfig</class>
    <class>com.myproject.persistence.TestMap</class>
    <class>com.myproject.persistence.User</class>
    <class>com.myproject.persistence.DataPrep</class>
    <properties>
        <property name="hibernate.archive.autodetection" value="class" />
        <property name="hibernate.dialect" value="org.hibernate.dialect.Oracle10gDialect" />

        <property name="hibernate.hbm2ddl.auto" value="validate" />

        <property name="hibernate.show_sql" value="false" />
        <property name="hibernate.format_sql" value="false" />
        <property name="hibernate.use_sql_comments" value="false" />
        <property name="hibernate.id.new_generator_mappings" value="false" />
        <property name="hibernate.transaction.manager_lookup_class" value="org.hibernate.transaction.JBossTransactionManagerLookup" />
        <property name="hibernate.cache.use_second_level_cache" value="false"/>
    </properties>
</persistence-unit>
<persistence-unit name="nbdx">
    <properties>
        <property name="hibernate.archive.autodetection" value="class" />
        <property name="hibernate.dialect" value="org.hibernate.dialect.Oracle10gDialect" />            
        <property name="hibernate.show_sql" value="false" />
        <property name="hibernate.format_sql" value="false" />
        <property name="hibernate.use_sql_comments" value="false" />
        <property name="hibernate.id.new_generator_mappings" value="false" />
        <property name="hibernate.transaction.manager_lookup_class" value="org.hibernate.transaction.JBossTransactionManagerLookup" />
        <property name="hibernate.cache.use_second_level_cache" value="false"/>
    </properties>
</persistence-unit>

<persistence xmlns="http://java.sun.com/xml/ns/persistence"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd"
version="2.0">
<persistence-unit name="nbpts">
    <jta-data-source>java:/nbptsDS</jta-data-source>
    <class>com.myproject.persistence.BookletCode</class>
    <class>com.myproject.persistence.ClipData</class>
    <class>com.myproject.persistence.CronJob</class>
    <class>com.myproject.persistence.ExerciseCodePK</class>
    <class>com.myproject.persistence.ExerciseCode</class>
    <class>com.myproject.persistence.ExportFile</class>
    <class>com.myproject.persistence.Hold</class>
    <class>com.myproject.persistence.InputFile</class>
    <class>com.myproject.persistence.InputRecord</class>
    <class>com.myproject.persistence.MessageLog</class>
    <class>com.myproject.persistence.NbricCodePK</class>
    <class>com.myproject.persistence.NbricCode</class>
    <class>com.myproject.persistence.OEMappingPK</class>
    <class>com.myproject.persistence.OEMapping</class>
    <class>com.myproject.persistence.OERecord</class>
    <class>com.myproject.persistence.Parameters</class>
    <class>com.myproject.persistence.PostEditData</class>
    <class>com.myproject.persistence.PreidRecord</class>
    <class>com.myproject.persistence.ProcessLog</class>
    <class>com.myproject.persistence.Response</class>
    <class>com.myproject.persistence.Score</class>
    <class>com.myproject.persistence.SetupFilePK</class>
    <class>com.myproject.persistence.SetupFile</class>
    <class>com.myproject.persistence.SftpConfig</class>
    <class>com.myproject.persistence.TestMap</class>
    <class>com.myproject.persistence.User</class>
    <class>com.myproject.persistence.DataPrep</class>
    <properties>
        <property name="hibernate.archive.autodetection" value="class" />
        <property name="hibernate.dialect" value="org.hibernate.dialect.Oracle10gDialect" />

        <property name="hibernate.hbm2ddl.auto" value="validate" />

        <property name="hibernate.show_sql" value="false" />
        <property name="hibernate.format_sql" value="false" />
        <property name="hibernate.use_sql_comments" value="false" />
        <property name="hibernate.id.new_generator_mappings" value="false" />
        <property name="hibernate.transaction.manager_lookup_class" value="org.hibernate.transaction.JBossTransactionManagerLookup" />
        <property name="hibernate.cache.use_second_level_cache" value="false"/>
    </properties>
</persistence-unit>
<persistence-unit name="nbdx">
    <jta-data-source>java:/nbdxDS</jta-data-source>
    <properties>
        <property name="hibernate.archive.autodetection" value="class" />
        <property name="hibernate.dialect" value="org.hibernate.dialect.Oracle10gDialect" />            
        <property name="hibernate.show_sql" value="false" />
        <property name="hibernate.format_sql" value="false" />
        <property name="hibernate.use_sql_comments" value="false" />
        <property name="hibernate.id.new_generator_mappings" value="false" />
        <property name="hibernate.transaction.manager_lookup_class" value="org.hibernate.transaction.JBossTransactionManagerLookup" />
        <property name="hibernate.cache.use_second_level_cache" value="false"/>
    </properties>
</persistence-unit>

我指的是数据源。对于nbdx，它是nbdxDS和nbpts，它是nbptsDS，这两个DB连接具有相同的表名，称为exercise_codes。所以它会变得很困惑，并选择其他表，而不是部署war文件。

这里是错误

16:13:47,277信息[org.hibernate.tool.hbm2ddl.TableMetadata]（ServerService线程池--48）HHH000261:找到表:nbdx_dev.exerforise_codes

JBAS014777:无法启动的服务：服务jboss.persistenceUnit。“nbpts.war#nbpts”：org.jboss.msc.service.StartException在服务jboss.persistenceUnit中。“nbpts.war#nbpts”：javax.persistence.persistenceException：[persistenceUnit:nbpts]无法生成EntityManagerFactory

16:13:47,733信息[org.jboss.as]（控制器引导线程）JBAS015961:Http管理接口监听Http://127.0.0.1:9990/management

16:13:47,733信息[org.jboss.as]（控制器引导线程）JBAS015951:Admin console Listing on http://127.0.0.1:9990

16:13:47,733错误[org.JBoss.AS]（控制器引导线程）JBAS015875:JBoss EAP 6.3.0.GA(AS 7.4.0.final-redhat-19)在10702ms中启动（有错误）-启动了279个服务中的219个（20个服务失败或缺少依赖项，59个服务是惰性的、被动的或按需的）

你能帮帮我吗？

Answer 1

我回味了一下。由于某些原因，EAP没有获得正确的架构名称，因此必须在properties name hibernate.default_schema 中设置架构名称