[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - Hibernate Oracle Problem: ORA-00907: missing right parenthes

Hi all. I'm using JBoss 4.2.1GA, and Oracle 10g, and attempting to perform a query. I've been receiving a "ORA-00907: missing right parenthesis" error when attempting to perform the query. Now this is apparently due to Hibernate using the 'as' keyword in the query - something that has been fixed in Hibernate 3.3.0ga. So I updated these Hibernate libs in \server\default\lib: hibernate-entitymanager.jar (3.3.1ga) hibernate-annotations.jar (v 3.3.0ga) hibernate-commons-annotations.jar (within Hibernate Annotations.rar\lib) ejb3-persistence.jar (within Hibernate Annotations.rar\lib) hibernate3.jar (v 3.2.5.ga) But still get the same error. The query still contains the 'as' keyword. Can anyone help? View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4083859#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...