how to execute a native sql update statement

j2eeprofessional · **Joined:** Thu Aug 24, 2006 2:16 am **Posts:** 4

hi guys,
i need to use a native sql update statement...eg. UPDATE usertable SET password=MD5('testing') WHERE userid=?

how do i do this in hibernate ????

max · **Posted:** Thu Aug 24, 2006 4:06 am

with session.connection() or simply s.createSQLQuery(....).executeUpdated().

the last one is only available in 3.2.x

j2eeprofessional · **Joined:** Thu Aug 24, 2006 2:16 am **Posts:** 4

executeUpdate() gives an exception "Update queries only supported through HQL"

how can we use <sql-insert> or <sql-iupdate>...any ideas ??

max · **Posted:** Thu Aug 24, 2006 5:01 am

"the last one is only available in 3.2.x"

how to use sql-update is described in the docs.

j2eeprofessional · **Joined:** Thu Aug 24, 2006 2:16 am **Posts:** 4

it is described as in hbm file....but how do i invoke that using java code is not there...i need help in that...could u pls guide me through..

max · **Posted:** Thu Aug 24, 2006 5:47 am

<sql-update> is invoked when your object is updated while being associated to a session (e.g. its persistent)

sql-update is not something you call explicit.