AW: Issue with special character

[Markus.Kopp]

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):  = 

Markus

________________________________

Von: Nicholoz Koka Kiknadze [mailto:kikna...@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.k...@bafin.de> wrote:


        Hi, 

        in our DB2 database, some columns have a # in their name, e.g.
ID# 
        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#" /> 
           ... 
          </resultMap> 


        Does not work. 

        Does anybody know, how to escape # in iBatis? 

        Thanks a lot 
        Markus