[hibernate-issues] [Hibernate-JIRA] Resolved: (HHH-2409) Oracle incorrect SQL causes ORA-00907: missing right parenthesis

Oracle incorrect SQL causes ORA-00907: missing right parenthesis ---------------------------------------------------------------- Key: HHH-2409 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2409 Project: Hibernate3 Issue Type: Bug Affects Versions: 3.2.2 Environment: Hibernate version 3.2.2ga (also reproduced in 3.2.1ga and 3.2.0ga) Database: Oracle Database 10.2 XE Reporter: Greg Till Priority: Critical Hibernate incorrectly inserts the "AS" keyword when aliasing a table name on Oracle. Oracle reports this as a missing parenthesis error. See forum post http://forum.hibernate.org/viewtopic.php?p=2340268#2340268 for more details.