ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From <Markus.K...@bafin.de>
Subject AW: Issue with special character
Date Thu, 25 Jun 2009 11:11:48 GMT
Thanks for the hint, but 
 select * from ZAHLINST.AGENTEN where <![CDATA[ID#]]> = #id#
does not work 
I get the following exception:
Caused by: com.ibatis.sqlmap.client.SqlMapException: Incorrect inline
parameter map format (missmatched name=value pairs):  = 



Von: Nicholoz Koka Kiknadze [mailto:kiknadze@gmail.com] 
Gesendet: Donnerstag, 25. Juni 2009 13:06
An: user-java@ibatis.apache.org
Betreff: Re: Issue with special character

Have you tried enclosing field names containing # with CDATA ?  Maybe it
will help...

On Thu, Jun 25, 2009 at 2:56 PM, <Markus.Kopp@bafin.de> wrote:


	in our DB2 database, some columns have a # in their name, e.g.
	This conflicts now with the iBatis placeholder character #, e.g.

	select * from table where ID# = #myId# 

	does not work. 

	Also the resultMap mapping 
	  <resultMap id="TableResult" class="Table"> 
	    <result property="id" column="ID#" /> 

	Does not work. 

	Does anybody know, how to escape # in iBatis? 

	Thanks a lot 

View raw message