jpa 连接多个mysql 数据库_hibernate jpa 实现连接多个数据库

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

先放上配置文件：

net.mllw.exports.entity.old.TBaseGoodsBrand

net.mllw.exports.entity.old.TBaseGoodsClass

net.mllw.exports.entity.old.TBaseGoodsInfo

net.mllw.exports.entity.old.TBaseGoodsLable

net.mllw.exports.entity.old.TBaseGoodsPicture

net.mllw.exports.entity.old.TBaseGoodsRelativeClass

net.mllw.exports.entity.old.TBaseGoodsRelativeLable

net.mllw.exports.entity.old.TGoodsConsult

net.mllw.exports.entity.old.TGoodsEvaluation

true

value="jdbc:mysql:xxx"/>

net.mllw.exports.entity.wen.TGGoods

net.mllw.exports.entity.wen.TGGoodsChannel

net.mllw.exports.entity.wen.TGGoodsCombination

net.mllw.exports.entity.wen.TGGoodsCustomer

net.mllw.exports.entity.wen.TGGoodsPicture

net.mllw.exports.entity.wen.TGGoodsPrice

net.mllw.exports.entity.wen.TGProduct

net.mllw.exports.entity.wen.TGProductProperty

net.mllw.exports.entity.wen.TGPromotion

net.mllw.exports.entity.wen.TGPromotionCombination

net.mllw.exports.entity.wen.TGPromotionCustomer

net.mllw.exports.entity.wen.TGPromotionFavour

net.mllw.exports.entity.wen.TGPromotionPicture

true

value="jdbc:mysql:xxx"/>

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

EntityManagerFactory factory = Persistence.();

EntityManager manager = factory.createEntityManager();

EntityManagerFactory factorynew = Persistence.();

EntityManager managernew = factorynew.createEntityManager();

....

factorynew.close();

factory.close();