File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Object Relational Mapping and the fly likes Java Persistence API: Multiple Persistence Units problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Java Persistence API: Multiple Persistence Units problem " Watch "Java Persistence API: Multiple Persistence Units problem " New topic
Author

Java Persistence API: Multiple Persistence Units problem

Aurelio Calegari
Ranch Hand

Joined: Nov 25, 2005
Posts: 54
Hi Ranchers,

I'm working with Java EE 5 and using the Java Persistence API 1.0. I have two databases, one db2 and one mysql. The connection to them are set properly and I have one table in each of these databases. I also have one Entity class for each table. The issue is that I'm getting troubles to connect both dbs in one operation. Here's my persistence.xml file:



And here's my session facade:



I'm getting the following exception:


I'm wondering if this problem is related to the fact I want both to be container managed... Any ideas on how to resolve this?

Thanks in advance

Aurelio
Edvins Reisons
Ranch Hand

Joined: Dec 11, 2006
Posts: 364
The exception you are getting means that your database connections do not support distributed transactions. Check the drivers for XA compliance, and see, for example, this discussion.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Java Persistence API: Multiple Persistence Units problem