|

»

»

iBATIS - User - Java

Issue with special character

View: New views

5 Messages — Rating Filter: Alert me

	Issue with special character by Markus.Kopp :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message Issue with special character 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
	Re: Issue with special character by Nicholoz Koka Kiknadze :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message 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
	AW: Issue with special character by Markus.Kopp :: Rate this Message: Reply to Author \| View Threaded \| Show Only 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
	Re: Issue with special character by Jeff Butler-2 :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message Escape the column name by doubling the hash mark: Select id## from ... Jeff Butler On 6/25/09, Markus.Kopp@... <Markus.Kopp@...> 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@...] > 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 > > > -- Sent from my mobile device --------------------------------------------------------------------- To unsubscribe, e-mail: user-java-unsubscribe@... For additional commands, e-mail: user-java-help@...
	AW: Issue with special character by Markus.Kopp :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message Jeff, Great, this works. Thanks !! Markus -----Ursprüngliche Nachricht----- Von: Jeff Butler [mailto:jeffgbutler@...] Gesendet: Donnerstag, 25. Juni 2009 15:00 An: user-java@... Betreff: Re: Issue with special character Escape the column name by doubling the hash mark: Select id## from ... Jeff Butler On 6/25/09, Markus.Kopp@... <Markus.Kopp@...> 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@...] > 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 > > > -- Sent from my mobile device --------------------------------------------------------------------- To unsubscribe, e-mail: user-java-unsubscribe@... For additional commands, e-mail: user-java-help@... --------------------------------------------------------------------- To unsubscribe, e-mail: user-java-unsubscribe@... For additional commands, e-mail: user-java-help@...