DB config with datasource in local properties file

[Brian Mulholland]

I am SOOO close to having what I want work. The plan is to move 99% of our properties to database. But we want the datasource's jndi setting to remain in a local properties file as it has always been. Everything works if I hardcode the ds name in the app.xml, but when I specify ${ds.jndi} to point to our property file, it fails. Here's what I got:

<bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"> <property name="location" value="/WEB-INF/app.properties" /> <property name="order" value="10" /> </bean> <bean id="propertyConfigurer2" class="org.springframework.beans.factory.config.PropertyOverrideConfigurer"> <property name="properties" ref="dbConfigFactory" /> <property name="order" value="20" /> </bean> <jee:jndi-lookup id="myDataSource" jndi-name="${ds.jndi}" /> <bean id="dbConfigFactory" class="org.apache.commons.configuration.ConfigurationConverter" factory-method="getProperties"> <constructor-arg ref="databaseConfigurator" /> </bean> <bean id="databaseConfigurator" class="org.apache.commons.configuration.DatabaseConfiguration"> <constructor-arg type="javax.sql.DataSource" ref="myDataSource" /> <constructor-arg name="table" value="k702prdr.APPLICATION_PROPERTIES_T" /> <constructor-arg name="nameColumn" value="APPLICATION" /> <constructor-arg name="keyColumn" value="PROPERTY_NAME" /> <constructor-arg name="valueColumn" value="PROPERTY_VALUE" /> <constructor-arg name="name" value="APP_NAME" /> </bean>

The error basically just says "WTF is ${ds.jndi}?" It's trying to resolve that literally as a jndi name. Clearly, the creation of the databaseConfigurator is happening BEFORE the propertyConfigurer pointed at the local property file can do it's job. I tried setting order, and many other permutations, and none work. I have apps using spring 4 and spring 3.2, so ideally a solution that works in both is preferred, but if I had to, I could live with hard-coding in 3.2 until we get permission to upgrade those apps. Any ideas?