CODEWITHSUNDEEP
javaspringproperties-file
jlars62
jlars62

Reputation: 7353

Access property values inside Spring config file

I have a simple properties file at WEB-INF/local.db.properties:

db.driverClassName=org.postgresql.Driver
db.url=jdbc:postgresql://localhost:5432/db_name
db.username=postgres
db.password=password

I am trying to access these properties inside of my Spring configuration file (towards the end): 

<beans xmlns="http://www.springframework.org/schema/beans"
    xmlns:context="http://www.springframework.org/schema/context"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:mvc="http://www.springframework.org/schema/mvc"
    xmlns:util="http://www.springframework.org/schema/util"
    xsi:schemaLocation="
         http://www.springframework.org/schema/beans
         http://www.springframework.org/schema/beans/spring-beans-3.1.xsd
         http://www.springframework.org/schema/util
         http://www.springframework.org/schema/util/spring-util-3.1.xsd
         http://www.springframework.org/schema/mvc
        http://www.springframework.org/schema/mvc/spring-mvc.xsd
         http://www.springframework.org/schema/context
         http://www.springframework.org/schema/context/spring-context-3.0.xsd">

 <context:component-scan base-package="controllers" />

 <mvc:annotation-driven/>
 <mvc:default-servlet-handler/>

 <bean id="tilesConfigurer" class="org.springframework.web.servlet.view.tiles3.TilesConfigurer">
     <property name="definitions">
         <list>
             <value>/WEB-INF/tiles-config.xml</value>
         </list>
     </property>
 </bean>

 <bean id="viewResolver" class="org.springframework.web.servlet.view.UrlBasedViewResolver">
     <property name="viewClass" value="org.springframework.web.servlet.view.tiles3.TilesView"/>
 </bean>

 <util:properties id="dbProperties" location="WEB-INF/local.db.properties" />
 <bean id="dbDataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
     <property name="driverClassName" value="${db.driverClassName}" /> <!--ERROR -->
     <property name="url" value="${db.url}" />
     <property name="username" value="${db.username}" />
     <property name="password" value="${db.password}" />
 </bean>
</beans>

The error is Could not load JDBC driver class [${db.driverClassName}]. The error is pretty clear to me - it is not trying to look up the property it is just using the raw string.

How do I fix this?

This is a Maven 3, Spring 4, Postgresql project.

Upvotes: 3

Views: 1190

Answers (2)

Luiggi Mendoza
Luiggi Mendoza

Reputation: 85779

You're not loading the properties file in Spring configuration. Add this line:

<context:property-placeholder location="classpath:/WEB-INF/local.db.properties"/>

or

<bean class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
    <property name="location" value="/WEB-INF/local.db.properties"/>
</bean>

If you have several properties file, change the above configuration for:

<bean class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
    <!-- locations, not location, check the S at the end -->
    <property name="locations">
        <list>
            <value>
                /WEB-INF/local.db.properties
            </value>
            <value>
                <!-- Path of another properties file -->
            </value>
        </list>
    </property>
</bean>

More info: PropertySourcesPlaceholderConfigurer

Upvotes: 3

Dino Tw
Dino Tw

Reputation: 3321

If you are using Eclipse, try right click on project -> Properties -> Java Build Path -> Source, then Add Folder or Link Source to your property files.

Upvotes: -1

Related Questions