2 different <context:property-placeholder: Could not resolve property placeholder

[H Paul]

Loaded via web:

 <listener>
  <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
 </listener>
 
 <context-param>
  <param-name>contextConfigLocation</param-name>
  <param-value>classpath:concepts/dao/jpa/applicationContext-jdbc.xml
  		classpath:concepts/dao/jpa/applicationContext-jpa.xml
 </context-param>
 
 
applicationContext-jdbc.xml

	<context:property-placeholder location="classpath:concepts/dao/jpa/accessdb.properties"/>
	
	<bean id="customerDataSource"
		class="org.springframework.jdbc.datasource.DriverManagerDataSource">
        <property name="driverClassName" value="${driverClassName}"/>
        <property name="url" value="${url_CustomerDSN}"/>
        <property name="username" value="${username}"/>
        <property name="password" value="${password}"/>
	</bean>	
	
applicationContext-jpa.xml

	<context:property-placeholder location="classpath:concepts/dao/jpa/hsqldb.properties"/>
 
 <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
        <property name="driverClassName" value="${driverClassName}"/>
        <property name="url" value="${url}"/>
        <property name="username" value="${username}"/>
        <property name="password" value="${password}"/>
    </bean> 

Exception:

 INFO: No Spring WebApplicationInitializer types detected on classpath
 Feb 12, 2013 2:12:11 PM org.apache.catalina.core.ApplicationContext log
 INFO: Initializing Spring root WebApplicationContext
 ERROR: org.springframework.web.context.ContextLoader - Context initialization failed
 org.springframework.beans.factory.BeanDefinitionStoreException: Invalid bean definition with name 'dataSource' defined in class path resource [concepts/dao/jpa/applicationContext-jpa.xml]: Could not resolve placeholder 'url'
 	at org.springframework.beans.factory.config.PlaceholderConfigurerSupport.doProcessProperties(PlaceholderConfigurerSupport.java:209)
 	at org.springframework.context.support.PropertySourcesPlaceholderConfigurer.processProperties(PropertySourcesPlaceholderConfigurer.java:157)
 	at org.springframework.context.support.PropertySourcesPlaceholderConfigurer.postProcessBeanFactory(PropertySourcesPlaceholderConfigurer.java:134)
 	at org.springframework.context.support.AbstractApplicationContext.invokeBeanFactoryPostProcessors(AbstractApplicationContext.java:681)

Why exception for : <property name="url" value="${url}"/> from applicationContext-jpa.xml

[H Paul]

0. To debug:

	<logger name="org.springframework">
		<level value="debug" />
	</logger>

1. only loaded classpath:concepts/dao/jpa/accessdb.properties

INFO : org.springframework.context.support.PropertySourcesPlaceholderConfigurer - Loading properties file from class path resource [concepts/dao/jpa/accessdb.properties]


2. why exception because classpath:concepts/dao/jpa/hsqldb.properties
was not loaded. So 'url' could not be resolved.

DEBUG: org.springframework.core.env.PropertySourcesPropertyResolver - Searching for key 'url' in [environmentProperties]
DEBUG: org.springframework.core.env.PropertySourcesPropertyResolver - Searching for key 'url' in [servletConfigInitParams]
DEBUG: org.springframework.core.env.PropertySourcesPropertyResolver - Searching for key 'url' in [servletContextInitParams]
DEBUG: org.springframework.core.env.PropertySourcesPropertyResolver - Searching for key 'url' in [jndiProperties]
DEBUG: org.springframework.jndi.JndiTemplate - Looking up JNDI object with name [java:comp/env/url]
DEBUG: org.springframework.jndi.JndiLocatorDelegate - Converted JNDI name [java:comp/env/url] not found - trying original name [url]. javax.naming.NameNotFoundException: Name url is not bound in this Context
DEBUG: org.springframework.jndi.JndiTemplate - Looking up JNDI object with name [url]
DEBUG: org.springframework.jndi.JndiPropertySource - JNDI lookup for name [url] threw NamingException with message: Name url is not bound in this Context. Returning null.
DEBUG: org.springframework.core.env.PropertySourcesPropertyResolver - Searching for key 'url' in [systemProperties]
DEBUG: org.springframework.core.env.PropertySourcesPropertyResolver - Searching for key 'url' in [systemEnvironment]
DEBUG: org.springframework.core.env.PropertySourcesPropertyResolver - Could not find key 'url' in any property source. Returning [null]
DEBUG: org.springframework.core.env.PropertySourcesPropertyResolver - Searching for key 'url' in [localProperties]
DEBUG: org.springframework.core.env.PropertySourcesPropertyResolver - Could not find key 'url' in any property source. Returning [null]

3. 1 possible solution:

	<context:property-placeholder location="classpath:concepts/dao/jpa/accessdb.properties, 
						classpath:concepts/dao/jpa/hsqldb.properties"/>

4. The best is yet to come. (propose a better one if have.)

[Bill Gorder]

for you scenario you only need one, there is nothing wrong with loading multiple propery files using one configurer. If you really needed multiples you should use the 'order' property.