[Spring] [Mybatis] Request processing failed; nested exception is java.lang.NullPointerException

Spring에서 sqlsession으로 연결 되지 않는 에러 발생시의 한 가지 해결 방법 :

             통하지 않을 경우 다른 블로그로 가세요.

DAO.java

---

@Repository("DAO")

public class DAO {

private static final Logger logger = LoggerFactory.getLogger(DAO.class);

    @Autowired

    private SqlSession sqlSession;

    public void setSqlSession(SqlSession sqlSession) {

        this.sqlSession = sqlSession;

    }

    public List<DTO> selectList(String queryId){

        List<DTO> list = sqlSession.selectList(queryId);

        for(DTO dto : list) {

        System.out.println(dto.getSid());

        }

        return List<DTO>list; 

    } 

}

*-context.xml

---

    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">

        <property name="driverClassName" value="com.mysql.jdbc.Driver"/>

        <property name="url" value="jdbc:mysql://localhost:3306/test"/>

        <property name="username" value="root"/>

        <property name="password" value="u2n..123456"/>

    </bean>

    

<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">

<property name="mapperLocations" value="classpath:com/gluesys/common/mybatis_db.xml"/>

<property name="dataSource" ref="dataSource" />

</bean>        

<bean id="sqlSessionTemplate" class="org.mybatis.spring.SqlSessionTemplate">

<constructor-arg index="0" ref="sqlSessionFactory" />

</bean>

<bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">

  <constructor-arg index="0" ref="sqlSessionFactory" />

</bean>

<bean id = "DAO" class="com.gluesys.common.DAO">

<property name="sqlSession" ref="sqlSession" />

</bean>

참고 : 

http://www.mybatis.org/spring/sqlsession.html