hibernate jpa 实现连接多个数据库

最新推荐文章于 2022-02-16 22:10:36 发布

weixin_34061555

最新推荐文章于 2022-02-16 22:10:36 发布

阅读量478

点赞数

文章标签：数据库 java

原文链接：https://my.oschina.net/mllw/blog/388523

版权

为什么80%的码农都做不了架构师？>>>

最近使用jpa进行数据迁移，由于跨数据库，就直接使用jpa来做。

先放上配置文件：

<?xml version="1.0" encoding="UTF-8"?>
<persistence xmlns="http://xmlns.jcp.org/xml/ns/persistence" version="2.1">
    <persistence-unit name="old" transaction-type="RESOURCE_LOCAL">
        <class>net.mllw.exports.entity.old.TBaseGoodsBrand</class>
        <class>net.mllw.exports.entity.old.TBaseGoodsClass</class>
        <class>net.mllw.exports.entity.old.TBaseGoodsInfo</class>
        <class>net.mllw.exports.entity.old.TBaseGoodsLable</class>
        <class>net.mllw.exports.entity.old.TBaseGoodsPicture</class>
        <class>net.mllw.exports.entity.old.TBaseGoodsRelativeClass</class>
        <class>net.mllw.exports.entity.old.TBaseGoodsRelativeLable</class>
        <class>net.mllw.exports.entity.old.TGoodsConsult</class>
        <class>net.mllw.exports.entity.old.TGoodsEvaluation</class>
        <exclude-unlisted-classes>true</exclude-unlisted-classes>
        <properties>
            <property name="hibernate.connection.url"
                      value="jdbc:mysql:xxx"/>
            <property name="hibernate.connection.driver_class" value="com.mysql.jdbc.Driver"/>
            <property name="hibernate.connection.username" value="xxx"/>
            <property name="hibernate.connection.password" value="xxx"/>
        </properties>
    </persistence-unit>
    <persistence-unit name="new" transaction-type="RESOURCE_LOCAL">
        <class>net.mllw.exports.entity.wen.TGGoods</class>
        <class>net.mllw.exports.entity.wen.TGGoodsChannel</class>
        <class>net.mllw.exports.entity.wen.TGGoodsCombination</class>
        <class>net.mllw.exports.entity.wen.TGGoodsCustomer</class>
        <class>net.mllw.exports.entity.wen.TGGoodsPicture</class>
        <class>net.mllw.exports.entity.wen.TGGoodsPrice</class>
        <class>net.mllw.exports.entity.wen.TGProduct</class>
        <class>net.mllw.exports.entity.wen.TGProductProperty</class>
        <class>net.mllw.exports.entity.wen.TGPromotion</class>
        <class>net.mllw.exports.entity.wen.TGPromotionCombination</class>
        <class>net.mllw.exports.entity.wen.TGPromotionCustomer</class>
        <class>net.mllw.exports.entity.wen.TGPromotionFavour</class>
        <class>net.mllw.exports.entity.wen.TGPromotionPicture</class>
        <exclude-unlisted-classes>true</exclude-unlisted-classes>

        <properties>
            <property name="hibernate.connection.url"
                      value="jdbc:mysql:xxx"/>
            <property name="hibernate.connection.driver_class" value="com.mysql.jdbc.Driver"/>
            <property name="hibernate.connection.username" value="xxx"/>
            <property name="hibernate.connection.password" value="xxx"/>
            <property name="hibernate.show_sql" value="true"/>
            <property name="hibernate.format_sql" value="true"/>
        </properties>
    </persistence-unit>
</persistence>

然后在代码里使用如下代码就可以了。

EntityManagerFactory factory = Persistence.();
EntityManager manager = factory.createEntityManager();


EntityManagerFactory factorynew = Persistence.();
EntityManager managernew = factorynew.createEntityManager();

....

factorynew.close();
factory.close();

转载于:https://my.oschina.net/mllw/blog/388523