Hi, I need to execute a query using the table directly, not using the class mapped because I have an atributte in the table that I don't want in the class.
Is it possible with Hibernate?.
Thanks.

Create another class without mapping the column you don't need

What I want to do is execute a query from the table directly, without using the class. Ex:

I 've got a table named "TableClients" with the attributes "id", "name" and "status", and I've got a Class named "Clients" with the attributes "id" and "name". Now I want to execute the following query:

SELECT id, name FROM TableClients WHERE status = 1;

Note that the attribute "status" is not visible from the class "Clients"; for this reason I can't use the session.createQuery or session.Iterate, etc.

What can I do?
Thanx.

I don't really understand your point : either use directly jdbc or Hibernate !
Anyway it doesn't cost a lot to create a bean to do that.

Exists a way to execute a raw sql query using hibernate?

session.connection()

and in Hibernate 2.1

session.createSQLQuery()