Hello,

I am trying to retrieve a row from a oracle 9 db that is synthetisied
by oracle for a compound key. This row is always called "rowid".
The problem is that 'rowid' is also a key word and because of this,
hibernates fails miserably.

Every thing would be fine if the generated SQL were

select a2uebergan0_.rowid, a2uebergan0_.verk_to as verk_to, a2uebergan0_.sec_von as sec_von, a2uebergan0_.sec_nach as sec_nach from UEBERGNG a2uebergan0_ where (a2uebergan0_.sec_von=? )and(a2uebergan0_.sec_nach=? )

instead of

select a2uebergan0_.rowid as rowid, a2uebergan0_.verk_to as verk_to, a2uebergan0_.sec_von as sec_von, a2uebergan0_.sec_nach as sec_nach from UEBERGNG a2uebergan0_ where (a2uebergan0_.sec_von=? )and(a2uebergan0_.sec_nach=? )

Yes, the only problem is the "as rowid" in the generated SQL query.
Anyone a idea how to work around this?

Cheers,

aanno


Hibernate version: 3.0alpha
Full stack trace of any exception that occurs:
2004-11-03 14:43:14,469 ERROR [net.sf.hibernate.util.JDBCExceptionReporter] - Could not execute query
java.sql.SQLException: ORA-00923: Schl