iBatis and Parameter Map

[Thara Visu]

I always get an exception SQL command not properly ended with the following query

    
Select id from table_name where name = #value#

and the parameter map has value property defined

The error is
Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred while applying a parameter map.
--- Check the getSearch-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: java.sql.SQLException: ORA-00933: SQL command not properly ended

In fact I am not able to apply any parameter maps/class
Any help would be appreciated.
Thanks in advance

[Ernest Friedman-Hill]

We've got a whole forum devoted to Object-Relational Mapping tools -- I'm going to move this there where it will get more attention.

[anoop sudhakaran]

Have you tried following way?
<statement id="exampleID" parameterClass="java.lang.String" resultClass="java.lang.String">
Select id from table_name where name = #value#
</statement>

[Thara Visu]

I used <select> instead of statement.

And oddly, if use $ instead of # it works.
# works only if i have condition statement like <isPropertyAvailable> etc.

Is it supposed to work that way?