ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Fabio Insaccanebbia <finsaccaneb...@gmail.com>
Subject Re: oracle hints are treated as comments
Date Wed, 09 Nov 2005 09:13:41 GMT
Try this.. (as a workaround)

<statement ...>
    SELECT /*+ RULE +*/
       id, name, email
       from ...
</statement>

2005/11/9, Guido García Bernardo <ggb275@tid.es>:
> 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ía Bernardo - ggarciab@itdeusto.com
> Tfn. +34 983 54 89 08
> ITDEUSTO - Valladolid (Spain)
>

Mime
View raw message