Execute a UPDATE by QUERY

wladelin · **Posted:** Mon Nov 14, 2005 12:23 pm

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

Is posible execute a update like this:

Code:

public static void expiraPreReserva() throws HibernateException, ParseException {
            
      Session sess = SessionFactory.currentSession();
      Transaction tr = sess.beginTransaction();   
      
      Query q = sess.createQuery( "UPDATE TPreReserva SET status='E' where dataFpr < ?" );
         
      q.setDate( 0, EuroUtil.getDataAtual() );
      q.list();
      
      tr.commit();
      SessionFactory.closeSession();
   }

but this throws the exception:
net.sf.hibernate.QueryException: query must begin with SELECT or FROM: UPDATE [UPDATE TPreReserva SET status='E' where dataFpr < ?]

Thanks JP

jamie_dainton · **Posted:** Mon Nov 14, 2005 12:31 pm

No.

query must begin with SELECT or FROM

wladelin · **Posted:** Mon Nov 14, 2005 12:32 pm

So how can i make a update like that??

kochcp · **Posted:** Mon Nov 14, 2005 12:40 pm

you can use direct jdbc using session.connection(), or session.createSqlQuery might work

jamie_dainton · **Posted:** Mon Nov 14, 2005 12:43 pm

Or upgrade to hibernate 3.x