(And I don't know what it will do to my DB2/400 version)
-J :-)
On 11/10/05, Paul Benedict <[EMAIL PROTECTED]> wrote:
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í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ía Bernardo - [EMAIL PROTECTED]
> Tfn. +34 983 54 89 08
> ITDEUSTO - Valladolid (Spain)
>
__________________________________
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.com
