Not getting instance of jdbcTemplate using spring annotations

Question

I'm using Spring jdbcTemplate for making database call but i'm not getting jdbcTemplate instance although i've autowired it.

package com.mypackage.dao
@Repository
public class CustomerDaoImpl implements CustomerDao {

private JdbcTemplate jdbcTemplate;

@Autowired
public void setDataSource(DataSource dataSource) {
    this.jdbcTemplate = new JdbcTemplate(dataSource);
}

public Customer findCustomer(){
      ........... 
    jdbcTemplate.execute ......
      ...........
  }
}

In Spring applicationContext.xml

  <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
    <property name="driverClassName" value="${database.driverClassName}" />
    <property name="url" value="${database.url}" />
    <property name="username" value="${database.username}" />
    <property name="password" value="${database.password}" />
    <property name="initialSize" value="1" />
    <property name="maxActive" value="3" />
</bean>

 <context:component-scan base-package="com.mypackage">
    <context:exclude-filter expression="org.springframework.stereotype.Controller"
        type="annotation" />
</context:component-scan>

database.properties file

database.url=jdbc:oracle:thin:@myhost:1521:OQA1
database.username=my_app
database.password=my_app_password
database.driverClassName=oracle.jdbc.OracleDriver

In which area i'm making mistake ?

----------------Edit : Adding the upper layer ----------------

 package com.mypackage.rest

  @Service("customerResource")
  @Path("/customer")
  public class CustomerResource extends AbstractResource{

  @Autowired
  private CustomerDao customerDao;

   }

This looks ok, what exception are you getting ? Is your database.properties file loaded by Spring ? Did you enable tx:annotation-driven ? — Frederic Close, Sep 30 '13 at 20:19
@FredClose Close I don't see any exception except NullPointer due to jpaTemplate instance is not being initialized. I havn't enabled tx:annotation-driven, will that cause this issue ? — Pankaj, Sep 30 '13 at 21:09
Please show the class where you are injecting the `CustomerDaoImpl` and is that class in the `com.mypackage`? — Sotirios Delimanolis, Sep 30 '13 at 22:24
@SotiriosDelimanolis I've added the upper layer in which i'm injecting the CustomerDao and update the package as well — Pankaj, Sep 30 '13 at 22:50
Yes. I'm able to access all other API in which i'm not having db call (i.e jpaTemplate) — Pankaj, Sep 30 '13 at 22:59
I honestly don't see it. Try this: make a `JdbcTemplate` bean declaration and autowire that instead of the `DataSource`. — Sotirios Delimanolis, Sep 30 '13 at 23:04
How does your service access the customerDao ? Which version of Spring ? — Frederic Close, Oct 01 '13 at 05:37

score 0 · Answer 1 · answered Sep 30 '13 at 22:15

0

Driver class is wrong it should be

database.driverClassName=oracle.jdbc.driver.OracleDriver

answered Sep 30 '13 at 22:15

Karthik Prasad

9,662
10
64
112

That would make the app unable to startup. The issue is the field isn't autowired. – Sotirios Delimanolis Sep 30 '13 at 22:18
Yes I agree, since he is getting null pointer exception for jdbcTemplate but only the difference I could notice was the driver class – Karthik Prasad Sep 30 '13 at 22:25
Note that there is a `oracle.jdbc.OracleDriver` class in the `odjbc14.jar`. I don't know for other jars or if that is the correct driver for thin oracle. – Sotirios Delimanolis Sep 30 '13 at 22:26
I'm using ojdbc6-11.1.0.7.0.jar which has oracle.jdbc.driver.OracleDriver. I changed the configuration but still getting the same issue. I guess, it must be because of spring annotations. – Pankaj Sep 30 '13 at 22:32
oh, I was using ojdbc6-11.2.0 – Karthik Prasad Sep 30 '13 at 22:34
How are accessing CustomerDaoImpl? – Karthik Prasad Sep 30 '13 at 22:35

Not getting instance of jdbcTemplate using spring annotations

1 Answers1