hello

i am newbie to hibernate, now i am choosing a solution for my project, in this project, it use db2 function in the sql clause as follow:

insert into idstool.access(userid,node,password) values('userid','nodename',encrypt('password','nodename'));


i wonder if i can implement such function by using hibernate, that is if hibrenate can use the db2 function, or user-defined sql functions? if yes, how?


thanks for any helps

you can execute raw sql by calling createSqlQuery on the hibernate session - this should allow you to do what you're looking for, but test it first as it depends on whether the driver supports it