parenthesis « Oracle « JPA Q&A

1. "ORA-00907 - missing right parenthesis" problem

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

2. Oracle missing parenthesis problem

Newbie Joined: Fri Nov 02, 2007 12:19 pm Posts: 1 I am using hibernate core 3.2.5, annotations 3.3.0, em 3.3.1 with glassfish and have run into what appears to be another missing right parenthesis bug. I am using an Oracle 8i DB and the latest JDBC drivers from Oracle. I have a class with an embedded PK: Code: public class CompanyBookContent ...

3. java.sql.SQLException: ORA-00907: missing right parenthesis

Hi All, I am using the persistence API to execute a query as follows . My persistence provider is Hibernate. Query coutnQuery = entityManager.createQuery("SELECT COUNT(c) FROM XlDocument c"); //XlDocument is my entity class. countQuery.getSingleResult()//error throws here as follows. Please guide me. Hibernate: select count((xldocument0_.PREFIX, xldocument0_.ENGINEID, xldocument0_.INITIALENGINEID, xldocument0_.WFDNAME, xldocument0_.WFINSTANCEID, xldocument0_.WFDREVISION, xldocument0_.EXPRESSIONID)) as col_0_0_ from XLDOCUMENT_HBN xldocument0_ [Warning] org.hibernate.util.JDBCExceptionReporter SQL Error: 907, SQLState: ...