org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class '${driver}'

Question

I am a beginner in spring. Here is my beans.xml

<?xml version="1.0" encoding="UTF-8"?>

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


<bean id="propertyPlaceholderConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
        <property name="location" value="DB.properties" />
    </bean>

    <bean id="myDataSource" class="org.apache.commons.dbcp.BasicDataSource" >
        <property name="driverClassName" value="${driver}"/>
        <property name="url" value="${url}"/>
        <property name="username" value="${uname}"/>
        <property name="password" value="${pwd}"/>
    </bean>
</beans>

And DB.properties is given below:

#database connection propertiess
driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/Payment
uname=root
pwd=renu@193

I am getting this error given below:

        Apr 04, 2014 11:07:25 PM org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions
INFO: Loading XML bean definitions from class path resource [beans.xml]
org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class '${driver}'
    at org.apache.commons.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1429)
    at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1371)
    at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
    at com.student.spring.test.RunClass.main(RunClass.java:22)
Caused by: java.lang.ClassNotFoundException: ${driver}

    at java.net.URLClassLoader$1.run(URLClassLoader.java:366)
    at java.net.URLClassLoader$1.run(URLClassLoader.java:355)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.net.URLClassLoader.findClass(URLClassLoader.java:354)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:425)
    at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:358)
    at org.apache.commons.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1420)
    ... 3 more

I know what is this error. This error is about class BasicDataSource. This class is not found...... but i already included the required jars in build path in my project. Jars is as given below...... a)/home/praveen/Downloads/commons-dbcp-1.4.jar b)/home/praveen/Downloads/org.apache.commons.pool.jar

I have read some where that may be the version of jars causing the problem... and interfering with each other.....

The jars are already available in project build path.... Please help me to solve this problem. Any help would be appreciated by me....

The RunClass.java is given below:

package com.student.spring.test;

import java.sql.Connection;
import java.sql.SQLException;

import org.apache.commons.dbcp.BasicDataSource;
import org.springframework.beans.factory.BeanFactory;
import org.springframework.beans.factory.xml.XmlBeanFactory;
import org.springframework.core.io.ClassPathResource;
import org.springframework.core.io.Resource;

@SuppressWarnings("deprecation")
public class RunClass {
    public static void main(String[] args) {
        Resource resource = new ClassPathResource("beans.xml");
        BeanFactory factory = new XmlBeanFactory(resource);


        BasicDataSource bds = (BasicDataSource) factory.getBean("myDataSource");        
        Connection connection;
        try {
            connection = bds.getConnection();
            System.out.println(bds.getDriverClassName());
            System.out.println(bds.getUrl());
            System.out.println(bds.getUsername());
            System.out.println(bds.getPassword());
            connection.close();
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }

    }
}

Show us your RunClass class. How are you loading your beans.xml context? — Sotirios Delimanolis
– Sotirios Delimanolis, Commented Apr 4, 2014 at 18:18

Prasad · Accepted Answer · 2014-04-04 19:39:36Z

2

If you are not using maven, make sure if your DB.properties is in location as below:

    src-|-package1
        |-package2
        .
        .
        .
        |-packageN
        |-beans.xml
        |-DB.properties

else specify your full classpath for file location as:

<bean id="propertyPlaceholderConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
    <property name="location" value="classpath:packageName.jdbc1.properties" />
</bean>

and then change your code as pointed by @Sotirios and @Ramesh:

    ApplicationContext ctx = new ClassPathXmlApplicationContext("beans.xml");
    BasicDataSource bds = (BasicDataSource) ctx.getBean("myDataSource");

answered Apr 4, 2014 at 19:39

Prasad

3,7932 gold badges16 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Prasad Over a year ago

Oh, you figured it out.

Noumenon Over a year ago

And yet he accepted an answer that didn't work for him instead of yours.

Ramesh Kotha · Accepted Answer · 2014-04-04 18:41:04Z

1

Check your jars once, is spring-expression.jar there?

And create applicationContext like below and check

ApplicationContext context = new ClassPathXmlApplicationContext("beans.xml");

BasicDataSource bds = (BasicDataSource) context.getBean("myDataSource");

edited Apr 4, 2014 at 18:41

answered Apr 4, 2014 at 18:09

Ramesh Kotha

8,35217 gold badges68 silver badges91 bronze badges

15 Comments

Ramesh Kotha Over a year ago

It is not loading your DB.properties file. Can you check once.

Reeinku Over a year ago

After applying your code... i am getting error given below

Reeinku Over a year ago

Exception in "main" java.lang.NoClassDefFoundError: org/springframework/expression/PropertyAccessor at org.springframework.context.support.AbstractApplicationContext.prepareBeanFactory(AbstractApplicationContext.java:538) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:439) at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:139) at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:83).RunClass.main(RunClass.java:19)

Reeinku Over a year ago

Caused by: java.lang.ClassNotFoundException: org.springframework.expression.PropertyAccessor

Ramesh Kotha Over a year ago

add spring-expression.jar to your classpath

|

Sotirios Delimanolis · Accepted Answer · 2014-04-04 18:25:38Z

1

XmlBeanFactory is a deprecated class since 3.1 and a BeanFactory. A BeanFactory is only responsible for generating beans. The task of processing (or rather registering the processes for processing) beans belongs to ApplicationContext subclasses.

Therefore use ClassPathXmlApplicationContext to produce your beans and retrieve them

ApplicationContext ctx = new ClassPathXmlApplicationContext("test.xml");
BasicDataSource bds = (BasicDataSource) ctx.getBean("myDataSource");

answered Apr 4, 2014 at 18:25

Sotirios Delimanolis

281k62 gold badges718 silver badges744 bronze badges

Collectives™ on Stack Overflow

org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class '${driver}'

3 Answers 3

2 Comments

15 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

15 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related