Joined: Mon Jan 31, 2011 5:41 am Posts: 1
|
Is the below Hibernate query is correct? Please explain.
public Object doInHibernate(Session session) throws HibernateException, SQLException { final String updateState = "update qrtz_triggers set trigger_state='WAITING'" + "where trigger_name in (" + " select trigger_name" + " from qrtz_triggers" + " where trigger_state like 'ACQUIRED'" + " AND TRIGGER_NAME NOT IN (SELECT TRIGGER_NAME FROM QRTZ_FIRED_TRIGGERS)" + ");"; Query q = session.createQuery(updateState); return q.uniqueResult(); }
|
|