i going update password of user:
here query:
@transactional public void resetpassindb(string useremail, string newpass) { query query = userdao.getsession().createquery("update user u set u.password = :password u.email = :email"); query.setparameter("password", newpass); query.setparameter("email", useremail); int result = query.executeupdate(); // 0 } but nothing changes!
update
this not worked too:
query query = userdao.getsession().createquery("from user email= :email"); query.setparameter("email", useremail); user user = (user) query.list().get(0); user.setpassword(newpass); userdao.getsession().update(user); in console:
hibernate: select user0_.id id1_2_, user0_.email email2_2_, user0_.password password3_2_, user0_.username username4_2_ user user0_ user0_.email=? update2
@transactional public void resetpassindb(string useremail, string newpass) { query query = userdao.getsession().createquery("from user email= :email"); query.setparameter("email", useremail); user user = (user) query.list().get(0); system.out.println("retrieved user: " + user); user.setpassword(newpass); userdao.getsession().update(user); system.out.println("updated user: " + user); } console:
hibernate: select user0_.id id1_2_, user0_.email email2_2_, user0_.password password3_2_, user0_.username username4_2_ user user0_ user0_.email=? retrieved user: username: aaaa, password: llkk, email: abc@gmail.com updated user: username: aaaa, password: vvbb, email: abc@gmail.com but nothing changes in user table!
