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

DeanoUK do-not-reply at jboss.com
Thu Sep 13 06:40:12 EDT 2007

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#4083859

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4083859

More information about the jboss-user mailing list