4 Replies Latest reply on Sep 14, 2007 4:37 AM by Dean Pullen

    Hibernate Oracle Problem: ORA-00907: missing right parenthes

    Dean Pullen Novice

      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?