openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Michael Dick (JIRA)" <>
Subject [jira] Created: (OPENJPA-1551) Allow connectionFactoryName to be specified when creating an EntityManager
Date Fri, 05 Mar 2010 15:34:27 GMT
Allow connectionFactoryName to be specified when creating an EntityManager

                 Key: OPENJPA-1551
             Project: OpenJPA
          Issue Type: Improvement
          Components: jpa
            Reporter: Michael Dick
            Assignee: Michael Dick
             Fix For: 2.0.0

Some application utilize the same table definitions across a several schemas or separate database
instances to isolate customer data.

A pure JPA solution to this problem would be to create a separate EntityManagerFactory for
each schema & database instance. This approach scales poorly, and results in a lot of
duplicate processing time, and memory used. 

As an alternative we could provide the ability to specify the connectionFactory to use when
the EntityManager is created. Effectively this allows the EntityManagers to share a MetaDataRepository
but communicate with different databases. 

There are some limitations to this support, obviously the table definitions must be identical
for each database used, if the OR mappings include a schema that schema must exist (and be
writeable) in each database come to mind, but in the long run for applications which follow
this specific pattern this function could be a large benefit. 

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message