Hibernate 2.1.2 in Oracle10g app server.

code as following:
Query query = session.createSQLQuery("select count(*) cnt FROM PP_SCHOLARSHIP {ss} WHERE 1=1 and ss.COLLEGE_DISP like '%a%'",
"ss", com.onefbusa.cs.dataaccess.domaindata.college.Scholarship.class);
List lst = query.list();

exception throws:
net.sf.hibernate.JDBCException: SQLException occurred

can someone tell me thow to execute select count(*) using SQL Base Query.
thanks!

You can't. use direct JDBC.

btw, what you are doing there can be easily done with HQL.

I am using Hibernate to implement pagination. For some functions, I can use HQL directly, however some functions contains specific oracle sql statement such as "contains" for text query and I think HQL can not support this function, so I want to use SQL Based Query API that Hibernate provides.

Using CONTAINS() in the where clause is no problem for HQL.
Have you tried it?