Obviously there is something wrong with the trivially simple
sqlMap file shown below, but being so new to iBatis I can’t figure out
what it is. If someone would kindly point it out I would appreciate it. Other
folks having this symptom were doing things with Abator and namespaces, which I
am not. The error occurs when I execute the line of code sqlMap.queryForObject("getFoo",
paramMap, resultMap ); I expected to get a hashmap in resultMap consisting of
name/value pairs for all columns of the single row of footable that would be
returned by my select statement if it were executed, but instead I get: com.ibatis.sqlmap.client.SqlMapException: There is no statement named getFoo
in this SqlMap. at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.getMappedStatement(SqlMapExecutorDelegate.java:288) at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:552) at
com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:97) at
com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForObject(SqlMapClientImpl.java:74) at
FooTest.main(FooTest.java:26) I know that my sqlMap xml file is being loaded and parsed
because if I introduce errors into it, the parser throws appropriate
exceptions. As given below, the parser accepts the sqlMap file but I get
the above exception trying to do the query shown above. <sqlMap> <statement id="getFoo"
parameterMap="getFooMap" parameterClass="java.util.Map"
resultClass="java.util.HashMap"> select * from dbo.footable as
foo where foo.id = '#id#' </statement> <parameterMap id="getFooMap"
class="java.util.HashMap"> <parameter property ="id"
jdbcType="VARCHAR" javaType="string" /> </parameterMap> </sqlMap> |
- "There is no statement named getFoo in this sqlMap&qu... Merritt, Norris
- Re: "There is no statement named getFoo in this ... Larry Meadors
- RE: "There is no statement named getFoo in t... Merritt, Norris
- RE: "There is no statement named getFoo in this ... Merritt, Norris
- Re: "There is no statement named getFoo in t... Larry Meadors