I've been assembling an app using OpenJPA 1.2.1 for a few weeks now. I've just come to the conclusion that the app is going to require reading data from more than one database datasource. One user schema has most of the tables, but another user has some other tables. There are some references between those groups of tables.
There's no way to specify multiple datasources in a single persistence unit, but I suppose I could implement multiple persistence units. Is it possible to have an entity from one persistence unit reference an entity from another persistence unit?