Hi, i'm new in Hibernate.
I have to execute two sentences in a transaction with Hibernate, but i don´t know how can i do it.

The sentence in Sql is:
1.-
delete from historico_accion
where idsesion in
(select idsesion from Historico_Sesion
where f_ultimo_click <= TO_DATE('29/10/2005 23:59:59', 'DD/MM/YYYY HH24:MI:SS'))
2.-
delete from Historico_Sesion
where f_ultimo_click <= TO_DATE('29/10/2005 23:59:59', 'DD/MM/YYYY

I don´t know how works the "in" operator with hibernate
Somebody can help me???

In Spanish:
Hola, tengo que ejecutar unas sentencias dentro de una transacción, y no se como hacerlo.
Las sentencias usando Sql son las que aparecen arriba.
Tengo dos objetos Historico_Sesion y historico_accion que funcionan bien con hibernate, pero no se como hacer para relacionarlos mediante el operador in.
Necesito ayuda!!!

in operator is similar sql , but it is better using exists (performance are better and exists problem when subquery return too much results)