Spring 3 MVC:java.lang.IllegalArgumentException: Property 'dataSource' is required.How to set JdbcTemplate correctly?
05:24 23 Mar 2014

I'm new to Spring development.And right now,i'm really facing a problem.Here are the code snippets to make you realize my problem clearly.............

Here is my DAO class:

public class LoginDaoImpl {

    private DataSource dataSource;              
    private JdbcTemplate jdbcTemplate;

    public void setDataSource(DataSource dataSource) {
        this.dataSource = dataSource;
    }

    public int checkLoginDetails(LoginVo loginVo){
        String sql = "select count(*) from empsctygrp where username=? and password=?";
        jdbcTemplate = new JdbcTemplate(dataSource);  
        int count = jdbcTemplate.queryForObject(sql,new Object[]{loginVo.getUserName(),loginVo.getPassword()},Integer.class);
        return count;
    }   
}

Now here is my Business-Object(BO) class:

public class LoginBo {

    LoginDaoImpl loginDaoImpl = new LoginDaoImpl();

    public int checkLoginDetails(LoginVo loginVo){      
        return loginDaoImpl.checkLoginDetails(loginVo);
    }
}

Now,here is my dispatcher-servlet xml code:


  
  
  
  
                                     


    

Now whenever i'm trying to run this on server the following exception is given:

SEVERE: Servlet.service() for servlet [dispatcher] in context with path [/A] threw exception [Request processing failed; nested exception is java.lang.IllegalArgumentException: Property 'dataSource' is required] with root cause

java.lang.IllegalArgumentException: Property 'dataSource' is required


Please help me solve this problem.............:(

spring model-view-controller spring-3 spring-jdbc jdbctemplate