Hibernate + Oracle

[news918]

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

[kariem]

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.

[paata.paatal.magtigsm.ge]

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

[news918]

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

[andygibson.contact.andygibson.net]

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.

[news918]

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.