ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Larry Meadors" <lmead...@apache.org>
Subject Re: "There is no statement named getFoo in this sqlMap" error when there IS a statement with that exact id...
Date Fri, 07 Jul 2006 21:23:06 GMT
Do you have namespaces enabled in sqlmapconfig?

I bet lunch that you do. :-)

Larry


On 7/7/06, Merritt, Norris <norris.merritt@hp.com> wrote:
>
>
>
>
> 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>

Mime
View raw message