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# /
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.
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
: 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
Jeff,
Great, this works.
Thanks !!
Markus
-Ursprüngliche Nachricht-
Von: Jeff Butler [mailto:jeffgbut...@gmail.com]
Gesendet: Donnerstag, 25. Juni 2009 15:00
An: user-java@ibatis.apache.org
Betreff: Re: Issue with special character
Escape the column name by doubling the hash mark