com.ibatis.sqlmap.client.SqlMapException: There is no statement named getAll in this SqlMap

[bhavit pant]

hey i am trying to learn ibatis,
i getting the exception as above.
this is ``snapshot of what i did please help where i am wrong.


<?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="TMP_BHAVIT"> <resultMap id="getAllname" class="com.test.TMP_BHAVIT"> <result property="username" column="USERNAME" jdbcType="CHAR"/> <result property="password" column="PASSWORD" jdbcType="CHAR" /> </resultMap> <select id="getAll" resultMap="getAllname"> SELECT * FROM TMP_BHAVIT </select> </sqlMap>
this is SqlMapConfig

<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE sqlMapConfig PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN" http://ibatis.apache.org/dtd/sql-map-config-2.dtd"> <sqlMapConfig> <settings useStatementNamespaces="true"/> <transactionManager type="JDBC"> <dataSource type="SIMPLE"> <property name="JDBC.Driver" value="oracle.jdbc.driver.OracleDriver"/> <property name="JDBC.ConnectionURL" value="jdbc:oracle:thin:@172.166.66.95:1521:gfhy"/> <property name="JDBC.Username" value="ctty"/> <property name="JDBC.Password" value="C5TY"/> </dataSource> </transactionManager> <sqlMap resource="TMP_BHAVIT.xml"/> </sqlMapConfig>
this is main java file

this is what inside java main

 Reader rd = Resources.getResourceAsReader("SqlMapConfig.xml");
               SqlMapClient smc = SqlMapClientBuilder.buildSqlMapClient(rd);
              System.out.println(smc.getDataSource());
               System.out.println("Going to read record.....");
               @SuppressWarnings("unchecked")
                List <TMP_BHAVIT> ems = (List<TMP_BHAVIT>)
               smc.queryForList("getAll", null); // here the exception is thrown  

this is the detailed exception report

com.ibatis.common.jdbc.SimpleDataSource@2bb514
Going to read record.....
Exception in thread "main" com.ibatis.sqlmap.client.SqlMapException: There is no statement named getAll in this SqlMap.
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.getMappedStatement(SqlMapExecutorDelegate.java:231)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:558)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:541)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)
at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:94)
at com.test.IbatisResultMap.main(IbatisResultMap.java:19)