« Return to Thread: Issue with special character

AW: Issue with special character

by Markus.Kopp :: Rate this Message:

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@...]
Gesendet: Donnerstag, 25. Juni 2009 13:06
An: user-java@...
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@...> 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

« Return to Thread: Issue with special character