Hi,

I m using Hibernate3 and SQL Server.
There is no primary Key in my table.

Insert and Delete operation are working properly but When I Try to update a record.....It niether Update record nor giving any error/exception.

My Mapping File is:

<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!--
Mapping file autogenerated by MyEclipse - Hibernate Tools
-->
<hibernate-mapping>
<class name="com.solversa.bean.Ttcmcs047550" table="ttcmcs047550" schema="dbo">
<composite-id name="id" class="com.solversa.bean.Ttcmcs047550Id">
<key-property name="TCkon" type="java.lang.String">
<column name="t_ckon" />
</key-property>
<key-property name="TGrno" type="java.lang.Short">
<column name="t_grno" />
</key-property>
<key-property name="TDsca" type="java.lang.String">
<column name="t_dsca" length="30" />
</key-property>
<key-property name="TFfno" type="java.lang.Integer">
<column name="t_ffno" />
</key-property>
<key-property name="TComp" type="java.lang.Short">
<column name="t_comp" />
</key-property>
<key-property name="TBlck" type="java.lang.String">
<column name="t_blck" />
</key-property>
<key-property name="TRefcntd" type="java.lang.Integer">
<column name="t_Refcntd" />
</key-property>
<key-property name="TRefcntu" type="java.lang.Integer">
<column name="t_Refcntu" />
</key-property>
<key-property name="hash1" type="java.lang.String">
<column name="hash1" />
</key-property>
</composite-id>
</class>
</hibernate-mapping>

My code is:

org.hibernate.Query query = session.createQuery("from com.solversa.bean.Ttcmcs047550 " +
"where t_dsca = '"+desc+"' and t_grno = "+serialNo+
" and t_ffno = "+ffNum+" and t_comp = "+company);

Iterator iterate=query.iterate();

if(iterate.hasNext())
{
//Create the object to retrieve value from list
Ttcmcs047550 ttcmcs047550=(Ttcmcs047550)iterate.next();
Ttcmcs047550 t_data=(Ttcmcs047550)session.get(Ttcmcs047550.class,ttcmcs047550.getId());

t_data.getId().setTDsca(NewDesc);
session.update(t_data);

}

Does anyone have any idea why UPDATE operation isn't performed.

Thanks.

Hi Kinshu.....

Sorry we have not work with Composite ID......

hope so some other poerson will give you the anser that you want.


Byeeeeeeeee

Hi

You are loading a object t_data and you are going to update object ttcmcs047550
it should
session.update(t_data);

Amila

(Don't forget to rate if helps)

Thanks but it does not make any diffence in result...

Hi


You can use two methods

session.saveorUpdate(t_data);

or

session.update with serId


Amila

(Don't forget to rate if helps)

Hi,

Thanks again....

But I have tried saveOrUpadate method but it is also not giving any result.

Hi,

Thanks again....

But I have tried saveOrUpadate method but it is also not giving any result.

With Hibernate you CAN'T modify a key value.