[jbossseam-issues] Multiple Datasources with Seam-Generated POJO entities, creates all tables in both datasources

Summary of previous posts: http://lists.jboss.org/pipermail/jboss-user/2007-January/036530.html http://lists.jboss.org/pipermail/jboss-user/2007-January/032850.html Both give a general how-to story http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4071027#... http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4034669#... Both give partial examples, ending with Code: @PersistenceContext(unitName="db1-PU") private EntityManager db1EntityManager; There are two problems: 1) The seam-gen created code doesn't use an explicit EntityManager, but just an @Entity-annotated POJO for the model and two helper classes, ClassNameHome (extends EntityHome<ClassName>) and ClassNameList extends EntityQuery, neither of which has an EntityManager field. Annotating the various classes with the PersistenceContext does not help. Secondly, perhaps as a result, all the entities get created in both databases. Third, how can we make sure that import.sql is only applied against one of the datasources? TIA Ian Darwin