Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

iBatis and Parameter Map

 
Thara Visu
Ranch Hand
Posts: 87
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I always get an exception SQL command not properly ended with the following query



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
author and iconoclast
Marshal
Pie
Posts: 24212
35
Chrome Eclipse IDE Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 87
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic