5 Replies Latest reply on Apr 17, 2008 10:51 PM by N ews

    Hibernate + Oracle

    N ews Newbie


      I'm facing an error ORA-00907: missing right parenthesis in my new implementation using seam-2.0.2-CR1 with Oracle9i.
      I have found some information about a bug in Hibernate but I couldn't found how to solve it.

      I'll really appreciate your help.


        • 1. Re: Hibernate + Oracle
          Kariem Hussein Newbie


          This might not be enough information to understand the problem. Could you provide some information to answer the following questions?

          • Can you provide the hibernate SQL output?

          • Under what circumstances does this error occur?

          • What are the differences in your application between your previous version and Seam 2.0.2.CR1?

          That could make it easier for someone here to answer to your post.

          • 2. Re: Hibernate + Oracle
            Paata Lominadze Newbie

            post you java code for more information.
            there is many reason for it.

            • 3. Re: Hibernate + Oracle
              N ews Newbie

              I developed a test application with seam-gen using some existing tables in an Oracle database. Model and pages where generated without problems but when I'm trying to run the application I get following error:

              08:36:31,156 INFO  [Authenticator] authenticating demo
              08:36:35,765 INFO  [STDOUT] Hibernate: 
                      ( select
                          datasource0_.ID as ID0_,
                          datasource0_.CREATED_BY as CREATED2_0_,
                          datasource0_.CREATED_DATE as CREATED3_0_,
                          datasource0_.DESCRIPTION as DESCRIPT4_0_,
                          datasource0_.MODIFIED_BY as MODIFIED5_0_,
                          datasource0_.MODIFIED_DATE as MODIFIED6_0_,
                          datasource0_.NAME as NAME0_ 
                          DW.DW.DS_TYPE ds0_ ) 
                      rownum <= ?
              08:36:36,109 WARN  [JDBCExceptionReporter] SQL Error: 907, SQLState: 42000
              08:36:36,109 ERROR [JDBCExceptionReporter] ORA-00907: missing right parenthesis

              • 4. Re: Hibernate + Oracle
                Andy Gibson Novice

                That DW.DW.table looks suspicious. Do you have DW set as the user and schema and catlog or something like that? Check your datasource-ds.xml, and see if you are specifying 'dw' all over the place.

                If it has two '.', it is probably expecting the parenthesis after the text following the first period.

                • 5. Re: Hibernate + Oracle
                  N ews Newbie


                  You're absolutely right!!. I were using both schema and catalog. After remove the catalog line in the persistence.xml file everything works as expected.

                  Thanks a lot !!