Thank you Fabio, it worked. I still think this is an undesired behaviour of ibatis SQL Maps.
Fabio Insaccanebbia wrote:
Try this.. (as a workaround) <statement ...> SELECT /*+ RULE */ id, name, email from ... </statement> 2005/11/9, Guido García Bernardo <[EMAIL PROTECTED]>: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)
