Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:3

Mapping documents:

Name and version of the database you are using:4.1.11

The generated SQL (show_sql=true):

Hi guys,

I am wondering how to query a record without returning all it data, just like :

select 1 from user where user.email = 'user@hibernate.org'
? Thanks in advance !

regards,
Prettyhandling

How about something like

select count(*) from User as u where u.email = :userEmail

http://www.hibernate.org/hib_docs/v3/reference/en/html/queryhql.html

Hi,

I tried to use

getHibernateTemplate().findByNamedQuery("UserByActivateCode",new Object[] {activateCode});
}


<query name="UserByActivateCode"><![CDATA[
select count(*) from User user where user.activateCode = ?
]]></query>

but I got this exception:

java.lang.ClassCastException: java.lang.Integer

pls help, Thanks !

Create an Integer[] instead of Object[].

Also make sure that activeCode is infact a java.lang.Integer.

I set

hibernate.connection.show_sql=true

and noticed that eventhough I change the Hibernate SQL to select count(*), it 's still select everything from the table.