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

    Hibernate + Oracle

    N ews Newbie

      Hi,


      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.


      Rgds,
      Julio

        • 1. Re: Hibernate + Oracle
          Kariem Hussein Newbie

          Julio,


          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 9.2.0.1 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
                      * 
                  from
                      ( 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_ 
                      from
                          DW.DW.DS_TYPE ds0_ ) 
                  where
                      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

                  Andy,


                  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 !!



                  Julio.