Read Environment Variables in persistence.xml file

Question

I want to read environment variables inside persistence.xml file.

Idea is that i don't want my database details to be read from properties file as there is a change of getting properties file override.Instead i want to read details from environment variables.

Is there any way to achieve this criteria.

Iam using Spring 3 my standalone application will be deployed in unix machine.

Solution 1

You can update properties in a persistence unit by supplying a Map (see this).

Conveniently, environment variables can be retrieved as a Map (see this).

Put the two together and you can dynamically update properties in your persistence unit with environment variables.

EDIT: simple example...

persistence.xml...

<persistence-unit name="default" transaction-type="RESOURCE_LOCAL">
    <provider>
        oracle.toplink.essentials.PersistenceProvider
    </provider>
    <exclude-unlisted-classes>false</exclude-unlisted-classes>
    <properties>
        <property name="toplink.logging.level" value="INFO"/>
        <property name="toplink.jdbc.driver" value="oracle.jdbc.OracleDriver"/>
        <property name="toplink.jdbc.url" value="jdbc:oracle:thin:@myhost:l521:MYSID"/>
        <property name="toplink.jdbc.password" value="tiger"/>
        <property name="toplink.jdbc.user" value="scott"/>
    </properties>
</persistence-unit>

code that updates persistence.xml "default" unit with environment variables...

Map<String, String> env = System.getenv();
Map<String, Object> configOverrides = new HashMap<String, Object>();
for (String envName : env.keySet()) {
    if (envName.contains("DB_USER")) {
        configOverrides.put("toplink.jdbc.user", env.get(envName)));    
    }
    // You can put more code in here to populate configOverrides...
}

EntityManagerFactory emf =
    Persistence.createEntityManagerFactory("default", configOverrides);

Solution 2

I don't think this will cover EMs created via injection. Worse, I think EMs created through EMF can only be EXTENDED (eg equivalent to the annotation @PersistenceContext(type = PersistenceContextType.TRANSACTION) opposed to EXTENDED) so that if one requires a transaction EM, one must use injection.

I'm wondering if its possible to physically rewrite the persistence.xml file at runtime. Problem one being, ability to rewrite the file (permissions, being able to get to it in META-INF etc), and second, rewriting it before its opened for the first time by JPA (which I thinking happens the first time an injected EM field is actually referenced by application code)

Comments

[Ran]

Hi Zack, Iam not sure how can i provide Map to persistence.xml .Can you provide some sample code for this.

[Zack Macomber]

Example uploaded - i've been finding some good info by googling "persistence.xml"

[Ran]

Hi Zack, the above code requires me to override the env variables every time i create the the EntityManagerFactory object.In that case if i am using this EntityManagerFactory in 10 classes every where i need to change.

[Zack Macomber]

In that case, you should use a single class that does the overriding. You could return an EntityManagerFactory from that one class to the 10 classes and only need to maintain one class for the override.

[Ran]

Thanks!I have implemented in the same way by overriding the properties.