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 <[EMAIL PROTECTED]> 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
>
