You should take a look at Slice module of OpenJPA. It will simplify your application against heterogeneous databases (i.e. DB2 ND SQLServer in your case) . OpenJPA will manage/remember which database the entities comes from or where should they be updated. The application controls where a new instance be persisted (because OpenJPA, by itself, can not make that decision:).
----- Pinaki -- View this message in context: http://openjpa.208410.n2.nabble.com/How-to-find-entity-belong-which-EntityManger-tp6470903p6471039.html Sent from the OpenJPA Users mailing list archive at Nabble.com.
