Secure DataSource configuration in Spring

[John McParland]

I am writing a web application using Java/Spring and MySQL.

At the moment I have a datasource configured as follows;

<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> <property name="driverClassName" value="${db.driver}" /> <property name="url" value="${db.jdbcurl}" /> <property name="username" value="${db.username}" /> <property name="password" value="${db.password}" /> </bean>

But the "password" property concerns me. It seems wrong to pass the data source the password explicitly.

I have taken some measures to improve the security of my app including;

chaning the root password

giving my application a userid/password for it alone

ensuring my apps user id can only access the database it needs (and only do what it needs)

But I'm not sure how to configure the data source in a more secure manner. I'd imagine anything which requires a password property at all is off the table.

How do others securely configure their data sources?

Thanks,

John

[Bill Gorder]

Typically in enterprise applications I have worked on we as application developers use jndi to get the database connection, and all the details such as username password are configured by a different group responsible for maintaining that information and setting it up in the J2EE server.

Alternatively you could encrypt the properties file using Jasypt. Of course doing this alone is not enough you would also want to store your encryption passoword in the environment to be used by the application during startup and then you would remove it from the envionment afterwards. There is a nice example of this approach in Spring in Action 3rd edition. I would recommend picking this book up as it is a good read anyway otherwise I am sure google could provide some good examples as well.

Thanks,

[John McParland]

Thanks Bill. The idea of using JNDI and the username/password being configured separately on the server sounds about right. I like how it means the code can be entirely separated from the authentication.

I've got the Spring In Action book but haven't come across that example yet. I'll give it a go.

Thanks

[Manish Sridharan]

Quite agree JNDI would be a better way to go for it. Perhaps you can have a look on this link :Configure JNDI with Spring

Thanks,

[John McParland]

Manish Sridharan wrote:Quite agree JNDI would be a better way to go for it. Perhaps you can have a look on this link :Configure JNDI with Spring

Thanks,

Thanks - I'll certainly use it!

[John McParland]

Hi again.

I tried the example based on Tomcat JNDI Datasource Examples - HOWTO for MySQL and also section 5.2.1 of Spring In Action (2nd Edition) but I haven't had any luck.

Here's what I've got now.

In XAMPP (the web server I'm using for testing just now); I've got a Context.xml file in this location C:\xampp\tomcat\conf\Catalina\localhost
It looks as follows;

<Context> <Resource name="jdbc/testDb" auth="Container" type="javax.sql.DataSource" maxActive="100" maxIdle="30" maxWait="10000" username="someuser" password="password" driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost/testDb"/> </Context>

Then in my Spring Beans property file I have

<?xml version="1.0" encoding="UTF-8"?> <beans xmlns="http://www.springframework.org/schema/beans" xmlns:jee="http://www.springframework.org/schema/jee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:util="http://www.springframework.org/schema/util" xmlns:p="http://www.springframework.org/schema/p" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-2.0.xsd http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee-2.0.xsd"> <bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean" scope="singleton"> <property name="jndiName" value="/jdbc/testDb" /> <property name="resourceRef" value="true" /> </bean> <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate"> <property name="dataSource" ref="dataSource" /> </bean> <bean id="simpleJndi" class="com.mcparland.john.test.jndi.SimpleJndi"> <property name="jdbcTemplate" ref="jdbcTemplate"/> </bean> </beans>

And finally some noddy Java code

/**
 * 
 */
package com.mcparland.john.test.jndi;

import org.springframework.context.ConfigurableApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import org.springframework.dao.DataAccessException;
import org.springframework.jdbc.core.JdbcTemplate;

/**
 * Simple JNDI example
 * 
 * @author John McParland ([e-mail])
 */
public class SimpleJndi {

    /**
     * The JDBC Template to use for querying
     */
    private JdbcTemplate jdbcTemplate = null;

    /**
     * Create a SimpleJndi object
     */
    public SimpleJndi() {

    }

    /**
     * @param jdbcTemplate
     *            the jdbcTemplate to set
     */
    public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
        this.jdbcTemplate = jdbcTemplate;
    }

    /**
     * @return the jdbcTemplate
     */
    public JdbcTemplate getJdbcTemplate() {
        return jdbcTemplate;
    }

    /**
     * Main program
     * 
     * @param args
     *            Program arguments, none required, any provided will be ignored
     */
    public static void main(String[] args) {
        ConfigurableApplicationContext context = new ClassPathXmlApplicationContext(
                "com/mcparland/john/test/jndi/beans.xml");
        context.registerShutdownHook();

        // Main application object
        SimpleJndi simpleJndi = (SimpleJndi) context.getBean("simpleJndi");

        try {
            int num = simpleJndi.getJdbcTemplate().queryForInt("select count(*) from ap_s");
            System.out.println("Num = " + num);
        } catch (DataAccessException dae) {
            System.err.println("DataAccessException encountered: " + dae.getMessage());
            dae.printStackTrace();
        }

    }

}

Unfortunately when I run this I get an exception;

log4j:WARN No appenders could be found for logger (org.springframework.context.support.ClassPathXmlApplicationContext).
log4j:WARN Please initialize the log4j system properly.
Exception in thread "main" org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in class path resource [com/mcparland/john/test/jndi/beans.xml]: Invocation of init method failed; nested exception is javax.naming.NoInitialContextException: Need to specify class name in environment or system property, or as an applet parameter, or in an application resource file:  java.naming.factory.initial
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1412)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:546)
	at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:872)
	at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:423)
	at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:139)
	at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:83)
	at com.mcparland.john.test.jndi.SimpleJndi.main(SimpleJndi.java:59)
Caused by: javax.naming.NoInitialContextException: Need to specify class name in environment or system property, or as an applet parameter, or in an application resource file:  java.naming.factory.initial
	at javax.naming.spi.NamingManager.getInitialContext(NamingManager.java:645)
	at javax.naming.InitialContext.getDefaultInitCtx(InitialContext.java:288)
	at javax.naming.InitialContext.getURLOrDefaultInitCtx(InitialContext.java:325)
	at javax.naming.InitialContext.lookup(InitialContext.java:392)
	at org.springframework.jndi.JndiTemplate$1.doInContext(JndiTemplate.java:154)
	at org.springframework.jndi.JndiTemplate.execute(JndiTemplate.java:87)
	at org.springframework.jndi.JndiTemplate.lookup(JndiTemplate.java:152)
	at org.springframework.jndi.JndiTemplate.lookup(JndiTemplate.java:178)
	at org.springframework.jndi.JndiLocatorSupport.lookup(JndiLocatorSupport.java:104)
	at org.springframework.jndi.JndiObjectLocator.lookup(JndiObjectLocator.java:105)
	at org.springframework.jndi.JndiObjectFactoryBean.lookupWithFallback(JndiObjectFactoryBean.java:201)
	at org.springframework.jndi.JndiObjectFactoryBean.afterPropertiesSet(JndiObjectFactoryBean.java:187)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1469)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1409)
	... 12 more

I'm not sure exactly where it's gone wrong. Any ideas anyone?

Thanks,

John

[Manish Sridharan]

Just had a glance on the stack trace. it seems either jndi is not initialized properly or it has not retrieved properly in the application. You can try following things to check that.

1. Try changing <property name="jndiName" value="/jdbc/testDb" /> to <property name="jndiName" value="jdbc/testDb" />
I think forward slash might not be required.

2. Create simple main class and try to get datasource object directly from jndi. Try with runtime debugging, it will give lot more information on the jndi.

Another important thing, please initialize log4j properties file and set it to debug level for spring classes. this will give you more logging information where in spring it has failed.
I generally attached the spring source code while debugging to see where the application is failing.


Thanks

[John McParland]

Manish Sridharan wrote:Just had a glance on the stack trace. it seems either jndi is not initialized properly or it has not retrieved properly in the application. You can try following things to check that.

1. Try changing <property name="jndiName" value="/jdbc/testDb" /> to <property name="jndiName" value="jdbc/testDb" />
I think forward slash might not be required.

2. Create simple main class and try to get datasource object directly from jndi. Try with runtime debugging, it will give lot more information on the jndi.

Another important thing, please initialize log4j properties file and set it to debug level for spring classes. this will give you more logging information where in spring it has failed.
I generally attached the spring source code while debugging to see where the application is failing.


Thanks

Thanks Manish. I tried suggestion one and put trace logging on for all. I'm not sure exactly where I could put a breakpoint on since it fails early on.

2012-04-10 22:10:01,125 INFO org.springframework.context.support.ClassPathXmlApplicationContext - Refreshing org.springframework.context.support.ClassPathXmlApplicationContext@e2eec8: startup date [Tue Apr 10 22:10:01 BST 2012]; root of context hierarchy
2012-04-10 22:10:01,171 INFO org.springframework.beans.factory.xml.XmlBeanDefinitionReader - Loading XML bean definitions from class path resource [com/mcparland/john/test/jndi/beans.xml]
2012-04-10 22:10:01,187 DEBUG org.springframework.beans.factory.xml.DefaultDocumentLoader - Using JAXP provider [com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderFactoryImpl]
2012-04-10 22:10:01,218 TRACE org.springframework.beans.factory.xml.PluggableSchemaResolver - Trying to resolve XML entity with public id [null] and system id [http://www.springframework.org/schema/beans/spring-beans.xsd]
2012-04-10 22:10:01,218 DEBUG org.springframework.beans.factory.xml.PluggableSchemaResolver - Loading schema mappings from [META-INF/spring.schemas]
2012-04-10 22:10:01,234 DEBUG org.springframework.beans.factory.xml.PluggableSchemaResolver - Loaded schema mappings: {http://www.springframework.org/schema/lang/spring-lang-2.5.xsd=org/springframework/scripting/config/spring-lang-2.5.xsd, http://www.springframework.org/schema/lang/spring-lang.xsd=org/springframework/scripting/config/spring-lang-3.0.xsd, http://www.springframework.org/schema/context/spring-context-2.5.xsd=org/springframework/context/config/spring-context-2.5.xsd, http://www.springframework.org/schema/util/spring-util-3.0.xsd=org/springframework/beans/factory/xml/spring-util-3.0.xsd, http://www.springframework.org/schema/context/spring-context.xsd=org/springframework/context/config/spring-context-3.0.xsd, http://www.springframework.org/schema/util/spring-util-2.0.xsd=org/springframework/beans/factory/xml/spring-util-2.0.xsd, http://www.springframework.org/schema/task/spring-task-3.0.xsd=org/springframework/scheduling/config/spring-task-3.0.xsd, http://www.springframework.org/schema/util/spring-util-2.5.xsd=org/springframework/beans/factory/xml/spring-util-2.5.xsd, http://www.springframework.org/schema/tool/spring-tool-3.0.xsd=org/springframework/beans/factory/xml/spring-tool-3.0.xsd, http://www.springframework.org/schema/jdbc/spring-jdbc.xsd=org/springframework/jdbc/config/spring-jdbc-3.0.xsd, http://www.springframework.org/schema/tx/spring-tx-2.0.xsd=org/springframework/transaction/config/spring-tx-2.0.xsd, http://www.springframework.org/schema/tool/spring-tool-2.0.xsd=org/springframework/beans/factory/xml/spring-tool-2.0.xsd, http://www.springframework.org/schema/context/spring-context-3.0.xsd=org/springframework/context/config/spring-context-3.0.xsd, http://www.springframework.org/schema/task/spring-task.xsd=org/springframework/scheduling/config/spring-task-3.0.xsd, http://www.springframework.org/schema/tx/spring-tx-2.5.xsd=org/springframework/transaction/config/spring-tx-2.5.xsd, http://www.springframework.org/schema/tool/spring-tool-2.5.xsd=org/springframework/beans/factory/xml/spring-tool-2.5.xsd, http://www.springframework.org/schema/beans/spring-beans-2.0.xsd=org/springframework/beans/factory/xml/spring-beans-2.0.xsd, http://www.springframework.org/schema/beans/spring-beans-2.5.xsd=org/springframework/beans/factory/xml/spring-beans-2.5.xsd, http://www.springframework.org/schema/jee/spring-jee.xsd=org/springframework/ejb/config/spring-jee-3.0.xsd, http://www.springframework.org/schema/beans/spring-beans.xsd=org/springframework/beans/factory/xml/spring-beans-3.0.xsd, http://www.springframework.org/schema/tool/spring-tool.xsd=org/springframework/beans/factory/xml/spring-tool-3.0.xsd, http://www.springframework.org/schema/tx/spring-tx.xsd=org/springframework/transaction/config/spring-tx-3.0.xsd, http://www.springframework.org/schema/jee/spring-jee-3.0.xsd=org/springframework/ejb/config/spring-jee-3.0.xsd, http://www.springframework.org/schema/jee/spring-jee-2.0.xsd=org/springframework/ejb/config/spring-jee-2.0.xsd, http://www.springframework.org/schema/tx/spring-tx-3.0.xsd=org/springframework/transaction/config/spring-tx-3.0.xsd, http://www.springframework.org/schema/jee/spring-jee-2.5.xsd=org/springframework/ejb/config/spring-jee-2.5.xsd, http://www.springframework.org/schema/beans/spring-beans-3.0.xsd=org/springframework/beans/factory/xml/spring-beans-3.0.xsd, http://www.springframework.org/schema/lang/spring-lang-3.0.xsd=org/springframework/scripting/config/spring-lang-3.0.xsd, http://www.springframework.org/schema/lang/spring-lang-2.0.xsd=org/springframework/scripting/config/spring-lang-2.0.xsd, http://www.springframework.org/schema/jdbc/spring-jdbc-3.0.xsd=org/springframework/jdbc/config/spring-jdbc-3.0.xsd, http://www.springframework.org/schema/util/spring-util.xsd=org/springframework/beans/factory/xml/spring-util-3.0.xsd}
2012-04-10 22:10:01,234 DEBUG org.springframework.beans.factory.xml.PluggableSchemaResolver - Found XML schema [http://www.springframework.org/schema/beans/spring-beans.xsd] in classpath: org/springframework/beans/factory/xml/spring-beans-3.0.xsd
2012-04-10 22:10:01,265 DEBUG org.springframework.beans.factory.xml.DefaultBeanDefinitionDocumentReader - Loading bean definitions
2012-04-10 22:10:01,296 DEBUG org.springframework.beans.factory.xml.XmlBeanDefinitionReader - Loaded 3 bean definitions from location pattern [com/mcparland/john/test/jndi/beans.xml]
2012-04-10 22:10:01,296 DEBUG org.springframework.context.support.ClassPathXmlApplicationContext - Bean factory for org.springframework.context.support.ClassPathXmlApplicationContext@e2eec8: org.springframework.beans.factory.support.DefaultListableBeanFactory@152c4d9: defining beans [dataSource,jdbcTemplate,simpleJndi]; root of factory hierarchy
2012-04-10 22:10:01,312 DEBUG org.springframework.context.support.ClassPathXmlApplicationContext - Unable to locate MessageSource with name 'messageSource': using default [org.springframework.context.support.DelegatingMessageSource@1c9b9ca]
2012-04-10 22:10:01,328 DEBUG org.springframework.context.support.ClassPathXmlApplicationContext - Unable to locate ApplicationEventMulticaster with name 'applicationEventMulticaster': using default [org.springframework.context.event.SimpleApplicationEventMulticaster@6e293a]
2012-04-10 22:10:01,328 INFO org.springframework.beans.factory.support.DefaultListableBeanFactory - Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@152c4d9: defining beans [dataSource,jdbcTemplate,simpleJndi]; root of factory hierarchy
2012-04-10 22:10:01,328 DEBUG org.springframework.beans.factory.support.DefaultListableBeanFactory - Creating shared instance of singleton bean 'dataSource'
2012-04-10 22:10:01,328 DEBUG org.springframework.beans.factory.support.DefaultListableBeanFactory - Creating instance of bean 'dataSource'
2012-04-10 22:10:01,343 DEBUG org.springframework.beans.factory.support.DefaultListableBeanFactory - Eagerly caching bean 'dataSource' to allow for resolving potential circular references
2012-04-10 22:10:01,359 TRACE org.springframework.beans.CachedIntrospectionResults - Getting BeanInfo for class [org.springframework.jndi.JndiObjectFactoryBean]
2012-04-10 22:10:01,359 TRACE org.springframework.beans.CachedIntrospectionResults - Caching PropertyDescriptors for class [org.springframework.jndi.JndiObjectFactoryBean]
2012-04-10 22:10:01,359 TRACE org.springframework.beans.CachedIntrospectionResults - Found bean property 'beanClassLoader' of type [java.lang.ClassLoader]
2012-04-10 22:10:01,359 TRACE org.springframework.beans.CachedIntrospectionResults - Found bean property 'cache' of type [boolean]
2012-04-10 22:10:01,359 TRACE org.springframework.beans.CachedIntrospectionResults - Found bean property 'class' of type [java.lang.Class]
2012-04-10 22:10:01,359 TRACE org.springframework.beans.CachedIntrospectionResults - Found bean property 'defaultObject' of type [java.lang.Object]
2012-04-10 22:10:01,359 TRACE org.springframework.beans.CachedIntrospectionResults - Found bean property 'expectedType' of type [java.lang.Class]
2012-04-10 22:10:01,359 TRACE org.springframework.beans.CachedIntrospectionResults - Found bean property 'exposeAccessContext' of type [boolean]
2012-04-10 22:10:01,359 TRACE org.springframework.beans.CachedIntrospectionResults - Found bean property 'jndiEnvironment' of type [java.util.Properties]
2012-04-10 22:10:01,359 TRACE org.springframework.beans.CachedIntrospectionResults - Found bean property 'jndiName' of type [java.lang.String]
2012-04-10 22:10:01,359 TRACE org.springframework.beans.CachedIntrospectionResults - Found bean property 'jndiTemplate' of type [org.springframework.jndi.JndiTemplate]
2012-04-10 22:10:01,359 TRACE org.springframework.beans.CachedIntrospectionResults - Found bean property 'lookupOnStartup' of type [boolean]
2012-04-10 22:10:01,359 TRACE org.springframework.beans.CachedIntrospectionResults - Found bean property 'object' of type [java.lang.Object]
2012-04-10 22:10:01,359 TRACE org.springframework.beans.CachedIntrospectionResults - Found bean property 'objectType' of type [java.lang.Class]
2012-04-10 22:10:01,359 TRACE org.springframework.beans.CachedIntrospectionResults - Found bean property 'proxyInterface' of type [java.lang.Class]
2012-04-10 22:10:01,359 TRACE org.springframework.beans.CachedIntrospectionResults - Found bean property 'proxyInterfaces' of type [[Ljava.lang.Class;]
2012-04-10 22:10:01,359 TRACE org.springframework.beans.CachedIntrospectionResults - Found bean property 'resourceRef' of type [boolean]
2012-04-10 22:10:01,359 TRACE org.springframework.beans.CachedIntrospectionResults - Found bean property 'singleton' of type [boolean]
2012-04-10 22:10:01,375 TRACE org.springframework.beans.TypeConverterDelegate - Converting String to [boolean] using property editor [org.springframework.beans.propertyeditors.CustomBooleanEditor@b0ce8f]
2012-04-10 22:10:01,375 DEBUG org.springframework.beans.factory.support.DefaultListableBeanFactory - Invoking afterPropertiesSet() on bean with name 'dataSource'
2012-04-10 22:10:01,375 DEBUG org.springframework.jndi.JndiTemplate - Looking up JNDI object with name [java:comp/env/jdbc/testDB]
2012-04-10 22:10:01,375 DEBUG org.springframework.jndi.JndiObjectFactoryBean - Converted JNDI name [java:comp/env/jdbc/testDB] not found - trying original name [jdbc/testDB]. javax.naming.NoInitialContextException: Need to specify class name in environment or system property, or as an applet parameter, or in an application resource file:  java.naming.factory.initial
2012-04-10 22:10:01,375 DEBUG org.springframework.jndi.JndiTemplate - Looking up JNDI object with name [jdbc/testDB]
2012-04-10 22:10:01,375 INFO org.springframework.beans.factory.support.DefaultListableBeanFactory - Destroying singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@152c4d9: defining beans [dataSource,jdbcTemplate,simpleJndi]; root of factory hierarchy
Exception in thread "main" org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in class path resource [com/mcparland/john/test/jndi/beans.xml]: Invocation of init method failed; nested exception is javax.naming.NoInitialContextException: Need to specify class name in environment or system property, or as an applet parameter, or in an application resource file:  java.naming.factory.initial
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1412)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:546)
	at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:872)
	at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:423)
	at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:139)
	at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:83)
	at com.mcparland.john.test.jndi.SimpleJndi.main(SimpleJndi.java:59)
Caused by: javax.naming.NoInitialContextException: Need to specify class name in environment or system property, or as an applet parameter, or in an application resource file:  java.naming.factory.initial
	at javax.naming.spi.NamingManager.getInitialContext(NamingManager.java:645)
	at javax.naming.InitialContext.getDefaultInitCtx(InitialContext.java:288)
	at javax.naming.InitialContext.getURLOrDefaultInitCtx(InitialContext.java:325)
	at javax.naming.InitialContext.lookup(InitialContext.java:392)
	at org.springframework.jndi.JndiTemplate$1.doInContext(JndiTemplate.java:154)
	at org.springframework.jndi.JndiTemplate.execute(JndiTemplate.java:87)
	at org.springframework.jndi.JndiTemplate.lookup(JndiTemplate.java:152)
	at org.springframework.jndi.JndiTemplate.lookup(JndiTemplate.java:178)
	at org.springframework.jndi.JndiLocatorSupport.lookup(JndiLocatorSupport.java:104)
	at org.springframework.jndi.JndiObjectLocator.lookup(JndiObjectLocator.java:105)
	at org.springframework.jndi.JndiObjectFactoryBean.lookupWithFallback(JndiObjectFactoryBean.java:201)
	at org.springframework.jndi.JndiObjectFactoryBean.afterPropertiesSet(JndiObjectFactoryBean.java:187)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1469)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1409)
	... 12 more

[Manish Sridharan]

2012-04-10 22:10:01,375 DEBUG org.springframework.jndi.JndiTemplate - Looking up JNDI object with name [java:comp/env/jdbc/testDB] 2012-04-10 22:10:01,375 DEBUG org.springframework.jndi.JndiObjectFactoryBean - Converted JNDI name [java:comp/env/jdbc/testDB] not found - trying original name [jdbc/testDB]. javax.naming.NoInitialContextException: Need to specify class name in environment or system property, or as an applet parameter, or in an application resource file: java.naming.factory.initial 2012-04-10 22:10:01,375 DEBUG org.springframework.jndi.JndiTemplate - Looking up JNDI object with name [jdbc/testDB]

From this log it seems, jndi object itself is not created. You should check if your context.xml is getting loaded in your application or not. As far as I can see from the log, it is not getting loaded.

Thanks

[Dariusz Majewski]

Hi John,

You've just created a simple java application with spring context that doesn't know anything about tomcat.

After you've defined db resource in tomcat, to be able to use it, you have to create a web application and deploy it in tomcat.

In your web.xml you you'll have to add something like this:

<listener> <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class> </listener> <context-param> <param-name>contextConfigLocation</param-name> <param-value> classpath*:beans.xml </param-value> </context-param> <resource-ref> <res-ref-name>jdbc/testDb</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> <res-sharing-scope>Shareable</res-sharing-scope> </resource-ref>

and to quickly test if it works you can create a simple servlet which will use WebApplicationContextUtils to retrieve spring context and your bean.

hope this helps.


Dariusz