Return-Path: 
 <user-java-return-4946-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 39497 invoked from network); 9 Nov 2005 09:14:05 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 9 Nov 2005 09:14:05 -0000
Received: (qmail 65792 invoked by uid 500); 9 Nov 2005 09:14:03 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 65770 invoked by uid 500); 9 Nov 2005 09:14:02 -0000
Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-java-help@ibatis.apache.org>
List-Unsubscribe: <mailto:user-java-unsubscribe@ibatis.apache.org>
List-Post: <mailto:user-java@ibatis.apache.org>
List-Id: <user-java.ibatis.apache.org>
Reply-To: user-java@ibatis.apache.org
Delivered-To: mailing list user-java@ibatis.apache.org
Received: (qmail 65759 invoked by uid 99); 9 Nov 2005 09:14:02 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 09 Nov 2005 01:14:02 -0800
X-ASF-Spam-Status: No, hits=1.6 required=10.0
	tests=MAILTO_TO_SPAM_ADDR,RCVD_IN_BL_SPAMCOP_NET,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (asf.osuosl.org: domain of finsaccanebbia@gmail.com
 designates 66.249.82.195 as permitted sender)
Received: from [66.249.82.195] (HELO xproxy.gmail.com) (66.249.82.195)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 09 Nov 2005 01:13:56 -0800
Received: by xproxy.gmail.com with SMTP id s18so141152wxc
        for <user-java@ibatis.apache.org>;
 Wed, 09 Nov 2005 01:13:41 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
        b=FAS3jsHXleeyP4bCwYJhPMMSeix4GtozYb3AYnLKjP+wvRBOpz10pp75hIyIDCaSdIIoELS4jKpvYl+PoOtp2OB/WWUqFLepjrLYBrcwfwoy8KYB1j+zM4mf5YAxIFnDAKy3e6fxlVY8I3ykSTHe3B0oQy/B9p8JotkyAwQYVPM=
Received: by 10.70.17.19 with SMTP id 19mr489604wxq;
        Wed, 09 Nov 2005 01:13:41 -0800 (PST)
Received: by 10.70.25.10 with HTTP; Wed, 9 Nov 2005 01:13:41 -0800 (PST)
Message-ID: <a02a04880511090113y3b488d9cl@mail.gmail.com>
Date: Wed, 9 Nov 2005 10:13:41 +0100
From: Fabio Insaccanebbia <finsaccanebbia@gmail.com>
To: user-java@ibatis.apache.org
Subject: Re: oracle hints are treated as comments
In-Reply-To: <4371B3A5.70402@tid.es>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: <4371B3A5.70402@tid.es>
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

Try this.. (as a workaround)

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

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