This content has been marked as final.
Show 2 replies
-
1. Re: Seam EntityQuery and multiple data sources
trouby Mar 14, 2009 3:53 AM (in response to paulmkeogh)You can have two different EntityQueries,
In your class that extends EntityQuery, you can override
@Override protected String getPersistenceContextName() { return "your_2nd_persistence_context_name"; }
Asaf.
-
2. Re: Seam EntityQuery and multiple data sources
gonorrhea Mar 14, 2009 6:11 AM (in response to paulmkeogh)if you want to read data (i.e. SELECT) from more than one db on multiple db servers in one query, you have the following options:
1) use a product like jboss metamatrix or teiid
2) use a stored proc with four part naming convention to span multiple servers (e.g. SERVER01.fooDB.dbo.barTable)
3) use a native query