Will JBoss3 allow me to specify multiple
datasources for a single CMP
bean? My app supports an asp model where I have physically separate
databases, each with identical schema, and users are bound to one database at
logon. It seems like a waste of resources to uniquely name instances of every bean (even if I
need separate JNDI names to lookup from a specific datasource) in the system for
each database when it doesn't really matter ultimately which datasource was used
to populate the bean instance.
Taken to the logical conclusion, it would be nice
if my findBy... methods could query many datasources and combine the resultsets,
tracking physical database mappings on the back end.
Has anyone had experience doing this? How can
I get JBoss3 to let me choose the datasource for each instance of a bean rather
than each class of beans?
-mike
