ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jeff Butler <jeffgbut...@gmail.com>
Subject Re: Issue with special character
Date Thu, 25 Jun 2009 12:59:47 GMT
Escape the column name by doubling the hash mark:

Select id## from ...

Jeff Butler


On 6/25/09, Markus.Kopp@bafin.de <Markus.Kopp@bafin.de> wrote:
> 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: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:
>
>
> 	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
>
>
>

-- 
Sent from my mobile device

---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org


Mime
View raw message