Sql comments inside sqlMap's select tag, throws exception
---------------------------------------------------------

         Key: IBATIS-203
         URL: http://issues.apache.org/jira/browse/IBATIS-203
     Project: iBatis for Java
        Type: Bug
  Components: SQL Maps  
    Versions: 2.1.5    
 Environment: WinXP
    Reporter: Henrik Westman


Using sql comments i.e. lines prepended with "--", causes an exception.

Seems like ibatis, parses the CDATA content of the select tag, 
into one long line without any newlines.

ex.
<select>
        <![CDATA[
                select * from myTable
               -- here is my comment
                where myCol = 5
        ]]>             
</select>

gets parsed into

                select * from myTable -- here is my comment where myCol = 5

which is now invalid sql.

Not being able to comment is annoying 
when you have very long SQL statements.




-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira

Reply via email to