no statement error[spring + ibatis] 새로올립니다.
원술
-applicationContext.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
xsi:schemaLocation=http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd
bean id=dataSource class=org.apache.commons.dbcp.BasicDataSource destroy-method=close
property name=driverClassName value=${jdbc.driverClassName}/
property name=url value=${jdbc.url}/
property name=username value=${jdbc.username}/
property name=password value=${jdbc.password}/
/bean
!-- 트랜잭션 관리 --
bean id=transactionManager class=org.springframework.jdbc.datasource.DataSourceTransactionManager
property name=dataSource ref=dataSource/
/bean
!-- SqlMap setup for iBATIS Database Layer --
bean id=sqlMapClient class=org.springframework.orm.ibatis.SqlMapClientFactoryBean
property name=dataSource ref=dataSource/
property name=configLocation value=classpath:dao/ibatis/sqlmaps/sqlMapConfig.xml/
/bean
!-- ========================= DAO DEFINITIONS: IBATIS IMPLEMENTATIONS ========================= --
bean id=sqlMap class=dao.ibatis.SqlMapUserDao
property name=sqlMapClient ref=sqlMapClient/
/bean
/beans-sqlMapConfig.xml-
?xml version=1.0 encoding=UTF-8?
!DOCTYPE sqlMapConfig PUBLIC -//iBATIS.com//DTD SQL Map Config 2.0//EN
http://www.ibatis.com/dtd/sql-map-config-2.dtdsqlMapConfig
settings enhancementEnabled=true
maxTransactions=5
maxRequests=32
maxSessions=10
useStatementNamespaces=true/
sqlMap resource=dao/ibatis/sqlmaps/sql.xml/
/sqlMapConfig
-sql.xml-
?xml version=1.0 encoding=UTF-8 ?
!DOCTYPE sqlMap PUBLIC -//ibatis.apache.org//DTD SQL Map 2.0//EN
http://ibatis.apache.org/dtd/sql-map-2.dtd
sqlMap namespace=List
sql id=select
select ..........
/sql
/sqlMap=========================================================================================
com.ibatis.sqlmap.client.SqlMapException: There is no statement named List.select in this SqlMap.
==========================================================================================extends SqlMapClientDaoSupport한 클래스 파일 중에..
--- getSqlMapClientTemplate().queryForList(List.select);이쪽부분에서 에러가나네요
네임스페이스 설정을 해지해서 select하여도 같은 에러메세지가 나네요. .....no statement named select......
-
캔서 2025-04-28
우선은 spring version 에 맞는 !DOCTYPE 을 선언해 주세요...