Geek asks and answers

JPA - EclipseLink - How to set up database schema name at run time

I am implementing a web application (JEE6, EJB WebProfile) using Oracle DB. My problem is that I need to change the database schema (name) used without recompiling / repackaging the application. So what I want (this is just an idea, maybe someone has a better one) is to have some configuration (JNDI) on the server that specifies the schema name. But how to configure Eclipse Link to use a different schema name at runtime?

More details:

I am currently using a file orm.xmlto indicate a schema name. But the application uses three different schema names (one for development, one for integration test and one for production), so I need to compile and package (maven) the application 3 times.

I have a JEE6 EJB WebProfile application running on Glassfish using Oracle DB, and the database connection is handled by the application server and verified by the application through JNDI.

Any authority has an idea on how to set up the database schema name at run time.

+5
source share
2 answers

You can use the EclipseLink SessionCustomizer .

package some.java.package;

import org.eclipse.persistence.config.SessionCustomizer; 
import org.eclipse.persistence.sessions.Session; 
import org.eclipse.persistence.sessions.DatabaseLogin; 

public class MySessionCustomizer implements SessionCustomizer {

  private String schema = "some_schema";
  public MySessionCustomizer() {
      schema = ... // read from property, jndi, etc.
  }

  public void customize(Session session) { 
      session.getLogin().setTableQualifier(schema);
  } 
}
+8
source

Configure JPA to use the data source. You can then configure various data sources for applications on your application server.

EntitymanagerFactory, : http://docs.oracle.com/javaee/6/api/javax/persistence/EntityManagerFactory.html#createEntityManager%28java.util.Map%29

+1

More articles:


All Articles