"ORA-00907 - missing right parenthesis" problem

danielcamara · **Posted:** Fri Jan 23, 2004 12:06 pm

I have this code in a test program and it returns the oracle error ORA-00907 - missing right parenthesis

-----
Query query = s.createQuery("from User WHERE User.name like '%' FOR UPDATE NOWAIT");
query.setLockMode("User", LockMode.UPGRADE_NOWAIT);
query.list();

------

Any one knows either if may code is wrong, or if this is a hibernate bug?

Best regards....

Daniel Camara

michael · **Posted:** Fri Jan 23, 2004 1:19 pm

Do not put the FOR UPDATE NOWAIT in your query string

danielcamara · **Posted:** Fri Jan 23, 2004 1:56 pm

And where should I put it?!?!?!?

michael · **Posted:** Fri Jan 23, 2004 2:15 pm

Nowhere. Just use query.setLockMode("User", LockMode.UPGRADE_NOWAIT); and look at the generated SQL ...

danielcamara · **Posted:** Fri Jan 23, 2004 2:39 pm

I tryed it before, but then I got other error : ORA-01002 Fetch Out Of Sequence ?!?!? :(

Any clue?!

michael · **Posted:** Fri Jan 23, 2004 2:50 pm

Look at the generated SQL.

danielcamara · **Posted:** Fri Jan 23, 2004 2:59 pm

select user0_.id as id, user0_.nomeCompleto as nomeComp2_, user0_.login as login from User user0_ for update nowait

michael · **Posted:** Fri Jan 23, 2004 3:17 pm

Well thats just what you wanted isn't it?

danielcamara · **Posted:** Fri Jan 23, 2004 3:30 pm

Well.... Yes but with out the error :)

I will try to figure out what is happening. Thanks a lot for your help :)

Best regards....

Daniel

denance · **Joined:** Wed Jul 28, 2004 2:12 pm **Posts:** 1

Daniel-
did you ever find a solution to this?
I am seeing the same ORA-01002 error that you are seeing with hibernate 2.1.4 and Oracle 9.2.0.1
thanks

rstearns01 · **Joined:** Wed Jan 18, 2006 5:41 pm **Posts:** 1

I am getting this error with H3.1 and Oracle 9.2.0.4 when parsing an HQL statement. The column lists in the subqueries are getting surrounded by unwanted (by Oracle) parens. This occurs using both Oracle and Oracle9Dialects.

Code:

SELECT provider0_.PROVIDER_ID AS PROVIDER1_8_, provider0_.ACTIVE AS ACTIVE8_, provider0_.PROVIDER_NAME AS PROVIDER3_8_, provider0_.PROVIDER_NAME_UPPER AS PROVIDER4_8_, provider0_.PROVIDER_NAME_SOUNDEX AS PROVIDER5_8_, provider0_.CREATION_DATE AS CREATION6_8_, provider0_.CREATION_USER AS CREATION7_8_, provider0_.MODIFICATION_DATE AS MODIFICA8_8_, provider0_.MODIFICATION_USER AS MODIFICA9_8_, provider0_.SOURCE_ID AS SOURCE10_8_, provider0_.SOURCE_PIN AS SOURCE11_8_, provider0_.SOURCE_MODIFICATION AS SOURCE12_8_, provider0_.SEARCHABLE_DATE AS SEARCHABLE13_8_, provider0_.HOME_URL AS HOME14_8_, provider0_.CONFIRMED AS CONFIRMED8_, provider0_.CONFIRMATION_DATE AS CONFIRM16_8_, provider0_.CONFIRMATION_USER AS CONFIRM17_8_, provider0_.ACTIVE_DATE AS ACTIVE18_8_, provider0_.DATA_SOURCE AS DATA19_8_, provider0_.PROVIDER_TYPE AS
PROVIDER20_8_ FROM PROVIDER provider0_, PROVIDER_ATTRIBUTE providerat1_ WHERE provider0_.ACTIVE='Y' AND provider0_.PROVIDER_ID=providerat1_.PROVIDER_ID AND providerat1_.ATTRIBUTE='FIRST_PUBLISHED_DATE' 
AND 
(EXISTS (SELECT (providerfl2_.PROVIDER_ID, providerfl2_.LINEITEM_ID) FROM PROVIDER_FLAGS providerfl2_ WHERE providerfl2_.PUBLISHCDLISTING='Y' AND providerfl2_.PROVIDER_ID=providerat1_.PROVIDER_ID)) 
AND 
(EXISTS (SELECT (providerco3_.PROVIDER_ID, providerco3_.REGION_ID, providerco3_.COUNTRY_ID, providerco3_.STATE_ID, providerco3_.METRO_ID) FROM PROVIDER_COVERAGE providerco3_ WHERE providerco3_.PROVIDER_ID=providerat1_.PROVIDER_ID)) ORDER BY providerat1_.MODIFICATION_DATE DESC

How can I get it to stop? Thanks.