-
1. Re: Hibernate + Oracle
kariem Apr 17, 2008 12:20 PM (in response to news918)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.paatal.magtigsm.ge Apr 17, 2008 12:23 PM (in response to news918)post you java code for more information.
there is many reason for it. -
3. Re: Hibernate + Oracle
news918 Apr 17, 2008 3:46 PM (in response to 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
-
4. Re: Hibernate + Oracle
andygibson.contact.andygibson.net Apr 17, 2008 9:05 PM (in response to news918)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
news918 Apr 17, 2008 10:51 PM (in response to 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.