Info about update

b.devis@witboy.com · **Joined:** Thu Feb 24, 2005 2:34 pm **Posts:** 80

Hibernate version: 3rc1

Hi, i have this simple sql query (jdbc style)

Code:

"update sdgtwb_dat.aynau00f set pven$a=? where fili$a=? and mode$a=? and mate$a=? and colo$a=? and vari$a=?"

,

in hibernate it's correct to use hql as this (i don't know if work)

Code:

     Query sql = session.createQuery("update CScontrinoVO as ay set ay.pvena=?  where ay.staga=? and ay.modea=? and ay.tgsia=? and ay.pk.filia=?");

or there a best pratices for update, not a single record but more records.
Can you help me
Devis

emmanuel · **Posted:** Wed May 04, 2005 4:00 am