[Hibernate-issues] [Hibernate-JIRA] Commented: (HB-305) net.sf.hibernate.Query / Oracle 8 vs 8i / ORDER BY / ORA-00907: missing right parenthesis

[<leg...@at...>]

The following comment has been added to this issue:

     Author: Gavin King
    Created: Wed, 3 Sep 2003 8:47 PM
       Body:
Ummmmm. Sorry? What are we expected to do about this?


Looks like a bug in Oracle, right?
---------------------------------------------------------------------
View the issue:

  http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-305


Here is an overview of the issue:
---------------------------------------------------------------------
        Key: HB-305
    Summary: net.sf.hibernate.Query / Oracle 8 vs 8i / ORDER BY / ORA-00907: missing right parenthesis
       Type: Bug

     Status: Unassigned
   Priority: Major

    Project: Hibernate2
 Components: 
             core
   Versions:
             2.0.2
             2.0.3

   Assignee: 
   Reporter: W. Muir

    Created: Tue, 2 Sep 2003 7:38 PM
    Updated: Tue, 2 Sep 2003 7:38 PM
Environment: Oracle 8.0.5 / Oracle 8.1.5

Description:
Using "ORDER BY" in a query string does NOT work on Oracle 8.0.5, but works fine on Oracle 8.1.5.  

Exception: ORA-00907: missing right parenthesis

...
Query accountQuery = session.createQuery( "FROM com.something.Account x ORDER BY x.identifier" ); 
accountQuery.setFirstResult( 10 );   
accountQuery.setMaxResults( 100 );
accountQuery.list();

java.sql.SQLException: ORA-00907: missing right parenthesis
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.ja
        at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
        at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
        at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1
        at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Pr
        at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleS
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(O
        at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(
        at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(O
        at net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImp
        at net.sf.hibernate.loader.Loader.getResultSet(Loader.java:5
        at net.sf.hibernate.loader.Loader.doFind(Loader.java:140)
        at net.sf.hibernate.loader.Loader.find(Loader.java:620)
        at net.sf.hibernate.hql.QueryTranslator.find(QueryTranslator
        at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1
        at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:76)


---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.

If you think it was sent incorrectly contact one of the administrators:
   http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa

If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira