Eclipse Community Forums: Gemini » Gemini JPA / DBAccess - best way to configure JDBC properties?

Home » Eclipse Projects » Gemini » Gemini JPA / DBAccess - best way to configure JDBC properties?(How can I maintain DB connection info in a separate properties file?)

Show: Today's Messages :: Show Polls :: Message Navigator

Gemini JPA / DBAccess - best way to configure JDBC properties? [message #1002312]

Fri, 18 January 2013 11:36

Simon Watson

Messages: 30
Registered: September 2011

Member

I've just migrated an OSGi application to Gemini JPA / DBAccess with MySQL, running on Virgo 3.6. Currently I have the jdbc connection property values set in the persistence.xml file. Is it possible to store these properties in a separate configuration file? I'd like to change files for different environments e.g. development, production.

Previously, I had my own OSGi bundle which created a datasource using a C3P0 connection pool. This used a property-placeholder bean which referenced a configuration artefact loaded by Virgo:

<!--  Create a connection pool data source (using C3P0 lib) for the DB -->
    <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"
             p:driverClass="${db.driverClass}"
             p:jdbcUrl="${db.url}"
             p:user="${db.username}"
             p:password="${db.password}"
             />

     <context:property-placeholder properties-ref="configProperties"/>

     <osgi-compendium:cm-properties id="configProperties" persistent-id="db_config"/>

     <!-- ========================= OSGi SERVICES ========================= -->

     <osgi:service ref="dataSource" interface="javax.sql.DataSource"/>

Report message to a moderator

Re: Gemini JPA / DBAccess - best way to configure JDBC properties? [message #1002376 is a reply to message #1002312]

Fri, 18 January 2013 13:32

Michael Keith

Messages: 243
Registered: July 2009

Senior Member

First, Gemini JPA supports multiple persistence descriptors so you can break things up statically that way.
Second, there is support for dynamic definition using the OSGi config admin service. See http://wiki.eclipse.org/Gemini/JPA/Documentation/OtherTopics#Configuration_Admin

-Mike

Report message to a moderator