ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brandon Goodin <brandon.goo...@gmail.com>
Subject Re: DynamicSql Help needed...
Date Sat, 23 Apr 2005 03:36:53 GMT
common mistake.

your  <![CDATA[]]> shouldn't wrap any other tags. Only text content.
Besides there is no reason to use  <![CDATA[]]> in this particular
case.

Brandon

On 4/22/05, KK <kkn006@gmail.com> wrote:
> Hi guys,
>    Finally I am able to use iBatis for all my CRUD sql operations.
> Feeling Good :).
> 
> Now I am trying to make a dynamic sql to work....but I am at no
> luck...can someone help me with this..
> 
> my sqlmap xml file I have the following
> 
>      <statement id="getActions_DynaSql"  resultClass="com.app.Action">
>         <![CDATA[
>         Select *
>         From Action
>             <dynamic prepend="WHERE">
>                 <isNotNull prepend="AND" property="actionID">
>                     ACTION_ID = #actionID#
>                 </isNotNull>
>             </dynamic>
>             order by actionID
>         ]]>
>     </statement>
> 
> I have an actionID field in com.app.Action javabean
> 
> when I am trying use sqlMap.queryForList for above sql I get the
> following error,
> 
> com.ibatis.common.jdbc.exception.NestedSQLException:
> --- The error occurred in iBatisTest/sqlMaps/Action.xml.
> --- The error occurred while applying a parameter map.
> --- Check the getActions_DynaSql-InlineParameterMap.
> --- Check the statement (query failed).
> --- Cause: java.sql.SQLException: ORA-00933: SQL command not properly ended
> 
> Caused by: java.sql.SQLException: ORA-00933: SQL command not properly ended
> 
>         at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:154)
>         at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:99)
>         at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:341)
>         at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:326)
>         at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:77)
>         at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:54)
> 
> Can someone help figure out what's wrong I am doing here...is there
> any thing I am missing.
> 
> Btw, this is the statement logged in log file
> 
> {pstm-100004} PreparedStatement: Select * From Action <dynamic
> prepend="WHERE"> <isNotNull prepend="AND" property="actionID">
> ACTION_ID = ? </isNotNull> </dynamic> order by actionID
> 
> Thanks in advance,
> KK
>

Mime
View raw message