hi forum,

"delete from Accessed as acc where acc.userid=:user_id order by acc.dat limit 1 ";


does this query work with hibernate?
does limit function work with hibernate?

i am new to hibernate concepts.

No, but look at Query.setMaxResults()

hi

this is my query:
delete from Accessed as acc where acc.userid=:user_id and acc.dat=:min_date

how should i set the parameter "min_date" using the setParameter method ?

mindate contains the date object to be set in the query.

what change should i make to the below stated code to work correctly?
query2.setParameter("min_date", mindate, Hibernate.DATE);


this is only my second request to the forum. yesterday i got a fine reply from the forum. thanks a lot hibernate forum...