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
|
