Re: oracle hints are treated as comments

[Paul Benedict]

I believe the XML spec does not allow the double dash to appear within a body. 
The -- is reserved
for comments. If you're having trouble, wrap a <![CDATA[ ... ]]> around your 
statement:

<statement ...>
<![CDATA[ 
    SELECT --+RULE
       id, name, email
       from ...
]]> 
</statement>

--- Guido Garc&#237;a Bernardo <[EMAIL PROTECTED]> wrote:

> Hi,
> 
> I'm using ibatis sql maps 2.1.5 + Oracle 8, defining the following query
> statement:
> 
> <statement ...>
>     SELECT --+RULE
>        id, name, email
>        from ...
> </statement>
> 
> The SQL that follows the hint is interpreted as a comment. Thus I get:
> 
> Caused by: java.sql.SQLException: ORA-00936: missing expression
> 
> It works fine when I remove the hint.
> Is ibatis removing line breaks? I think this is a bug or at least an
> undesired behaviour in my case. Is there any workaround or idea?
> 
> Thank you very much,
> 
> -- 
> Guido Garc&#237;a Bernardo - [EMAIL PROTECTED]
> Tfn. +34 983 54 89 08
> ITDEUSTO - Valladolid (Spain)
> 



        
                
__________________________________ 
Yahoo! Mail - PC Magazine Editors' Choice 2005 
http://mail.yahoo.com