how to update the value of particular cell in table using HQL

[harithapriya]

public void saveSinglePercentage(String singlePassPercentage,
            String userName) throws ApplicationException {
 
        int singlePercent = Integer.valueOf(singlePassPercentage);
          String[] params = { PASS_SPERCENT,USER_ID_PARAM };
         Object[] values = {singlePassPercentage};
         System.out.println(singlePercent);
         System.out.println(userName);
         getHibernateTemplate().update("update TUserModule tuserMod  set tuserMod.passPercentage=:singlePercent where TUser.userName=:userName"); 

when i use this i have got this error "org.springframework.orm.hibernate3.HibernateSyste mException: Unknown entity: java.lang.String; nested exception is org.hibernate.MappingException: Unknown entity: java.lang.String " please help me, Thanks in advance.

[r035198x]

What is TUser in your query?
Did you mean to write

 update TUserModule tuserMod  set tuserMod.passPercentage=:singlePercent where tuserMod.tUser.userName=:userName"

?

[harithapriya]

The UserId is present in Tuser class which have reference in tusermodule class

[r035198x]

You can't just start accessing it in the query without using the alias that you have created.

[harithapriya]

not only that any small query is not executed in that update method.can u please suggest me to use which method from hibernate template class?

[r035198x]

You should see the API specs for that class before using it. You are using a method that expects an entity and you are passing it a query instead. If you want to use that method then you should edit the values on your entity class and pass that entity to the method instead.

[harithapriya]

thanks so much !! I have used bulk update instead of update which take string and its working fine :)