I am new to the Seam framework. I have too many databases I have to connect to from one application.
I have read the following Knowlegde Base item: http://seamframework.org/Documentation/HowDoIUseMultipleDynamicEntityManagersInSeam
But my problem is a little different, there are about 200 database schemas. There is a databseuser who can reach all the schemas. I thought I could use a single EntityManagerFactory and I would use emf.createEntityManager(map); the map would parameterize the default_schema, because there are no differences between the construction of the different database schemas. I looked it up in the hibernate source code but it isn't supported.
I suppose it is too expensive to configure in component.xml all the 200 database connections to be represented. Or should I use Hibernate SessionFactory methods? Does anybody have any experience about this?