[
https://issues.apache.org/jira/browse/IBATIS-558?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12654860#action_12654860
]
Kai Grabfelder commented on IBATIS-558:
---------------------------------------
could you please check if this happens with the latest iBATIS version as well?
> Field name with # not supported without parameters
> --------------------------------------------------
>
> Key: IBATIS-558
> URL: https://issues.apache.org/jira/browse/IBATIS-558
> Project: iBatis for Java
> Issue Type: Bug
> Components: SQL Maps
> Affects Versions: 2.3.0
> Environment: iOS v5r3
> Reporter: M.H. Avegaart
> Priority: Critical
>
> Assume I have a field named FIELD#. To use this field in SQL I need to
> duplicate the # character (as mentioned in the iBatis FAQ).
> The following statement works:
> <select id="..." parameterClass="..." resultMap="...">
> select FIELD##
> from SCHEMA.TABLE
> where OTHER_FIELD = #value#
> </select>
> But to my surprise, this one doesn't:
> <select id="..." parameterMap="..." resultMap="...">
> select FIELD##
> from SCHEMA.TABLE
> where OTHER_FIELD = ?
> </select>
> (DB2 complains that FIELD## can't be found in SCHEMA.TABLE)
> Apparently the ## is only replaced by # if the SQL string also contains at
> least one #parameter#.
> ps. Before you ask, using a single # is also not supported:
> <select id="..." parameterMap="..." resultMap="...">
> select FIELD#
> from SCHEMA.TABLE
> where OTHER_FIELD = ?
> </select>
> (iBatis complains that "from SCHEMA.TABLE where OTHER_FIELD = ?" is not a
> parameter)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
