Hi All,

I have just started to work with Hibernate and I am using it with Spring MVC framework. My problem is that I need to use a user defined SQL function when updating the password. Now I have no idea how can I do this while using Hibernate version:3

aTaxPayerAccount = (TaxPayerAccount)this.getHibernateTemplate().get(TaxPayerAccount.class, user_id);
aTaxPayerAccount.setPassword("dbo.EncMe("+password+")");
aTaxPayerAccount.setReset_flg("Y");
this.getHibernateTemplate().update(aTaxPayerAccount);


Error stack trace of the exception:
org.springframework.dao.DataIntegrityViolationException: Hibernate operation: co
uld not update: [com.etax.admin.resetpassword.model.TaxPayerAccount#Harsh]; SQL
[update T_USER_PROFILE set password=?, hintQuestion=?, hintAnswer=?, email=?, re
set_flg=? where userid=?]; [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer
]String or binary data would be truncated.; nested exception is java.sql.SQLExce
ption: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]String or binary da
ta would be truncated.
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Str
ing or binary data would be truncated.


Name database :SQL SERVER 2000. jdbc.microsoft.sqlserver driver


I would appreciate all your inputs. Thanks!

Regards,
Harsh

I think the simplest of all would be to use the SQL directly instead of HQL. But I am sure that would be something better than this. I would keep this as my last option, unless there is anything else that can be done.

Hi All,

I want to use a User defined SQL Procedure while updating a fld but have no clue how to do that. Following is the description of my problem statement:

I want to update a user's password. But before writing it in the DB, want to encrypt it. This encryption is done using a SQL Procedure. So tried:



where dbo.EncMe is that SQL Procedure. This gives the UnsupportedOperationException exception.


I tried another (funny) way:



and it sure didn't work. Can anyone please suggest me how to get this done. I hope I was able to make my problem statement clear.

I would appreciate all inputs.

Thanks!!