ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From j-lists <jamisonli...@gmail.com>
Subject Re: oracle hints are treated as comments
Date Thu, 10 Nov 2005 12:00:08 GMT
iBatis does remove the line breaks.... and if it stops it'll break my
production DB2 app!
(And I don't know what it will do to my DB2/400 version)
-J :-)

On 11/10/05, Paul Benedict <paul4christ79@yahoo.com> 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 <ggb275@tid.es> 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 - ggarciab@itdeusto.com
> > Tfn. +34 983 54 89 08
> > ITDEUSTO - Valladolid (Spain)
> >
>
>
>
>
>
> __________________________________
> Yahoo! Mail - PC Magazine Editors' Choice 2005
> http://mail.yahoo.com
>

Mime
View raw message