1. "ORA-00907 - missing right parenthesis" problem forum.hibernate.orgI 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 |
2. Oracle missing parenthesis problem forum.hibernate.orgNewbie 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 forum.hibernate.orgHi 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: ... |