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.
post you java code for more information.
there is many reason for it.
I developed a test application with seam-gen using some existing tables in an Oracle 18.104.22.168 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
DW.DW.tablelooks 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.
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 !!