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: 42000
[Error] org.hibernate.util.JDBCExceptionReporter ORA-00907: missing right parenthesis


Thanks
-vijay