I am useing Hibernate with Spring. I have a table with no primary key
and trying to update a rwo from UI.

Mapping file
<hibernate-mapping package="com.xxx.model">
<class name="Data" table="tableName">
<composite-id >
<key-property name="scid" column="SCENEID" type="long"></key-property>
<key-property name="penid" column="PERSONID" type="long"></key-property>
<key-property name="neid" column="NODEID" type="long"></key-property>
<key-property name="name" column="NAME" type="java.lang.String"></key-property>
<key-property name="value" column="VALUE" type="java.lang.String"></key-property>
</composite-id>
</class>
</hibernate-mapping>

I tried with save and saveUpdate methods from springTemaplate().
I is not even throughing any exception. I am bale to create,delete,search.
Only update fails.Any help Please Thanks

public void updateData(Data data) throws InfrastructureException{
try {
getHibernateTemplate().saveOrUpdate(data);
} catch (DataAccessException e) {
throw new InfrastructureException(e);
//e.printStackTrace();
}

}

Thanks
Sudhakar

The possible reason for failure would be your where clause.
Your where clause may not fetch any data that's why it is not updating.

Could you share the generated update sql.

It is not even generating sql quuery.

It is generating query for Insert,Delete,Select.

It is not even throwing exception for update

Thanks
Sudhakar

I'm pretty sure you're not allowed to update the key so it's possible that Hibernate isn't being made aware the object is changed and is therefore not doing the update.

Is that the complete mapping or are there additional, not composite-id fields as well ?

That is the content of my mapping file. I have five fields in that table and I have all rights on that table.

I have three records displaying in UI selected one record-goto edit page and edit couple of columns and submit.

My basic question is how hibernate knows which row I have updated when there is no primary key ?. All five fileds become unique but how will it know which record i have selected and updated ?

Here is example data :

3493 111 666 James James Value
3493 33333 6666 Test2 TestValue2
3493 121212 909090 Sudha123 Sudha Value

I alo implimented the two methods in Data bean.

public boolean equals(Object other) {
if ( !(other instanceof Data) ) return false;
Data castOther = (Data) other;
return new EqualsBuilder()
.append(this.getSceneid(), castOther.getSceneid())
.append(this.getPersonid(), castOther.getPersonid())
.append(this.getNodeid(), castOther.getNodeid())
.append(this.getName(), castOther.getName())
.append(this.getValue(), castOther.getValue())
.isEquals();
}

public int hashCode() {
return new HashCodeBuilder()
.append(getSceneid())
.append(getPersonid())
.append(getNodeid())
.append(getName())
.append(getValue())
.toHashCode();
}


Any Help please.

I am still waiting :)....

Experties could you please have a look ?

Well you've answered yourself haven't you?

If the 5 fields combined identify a record by altering one you've created a new record. Thus preventing you from updating because as far as hibernate is concerned you've got a new record.

Then hibernate atleast insert a new row in a table right ? When i use SaveOrUpdate methods. But anyway that is not my requirement. So there is no way it can identify the row I am updating and update the record in DB right? unless i select the row with old values and pass new value and update it

You are not updating the record, you can not update the record, stop even thinking about updating the record.

You are using all 5 fields as a composite key, by altering any of them you create a new record.

If this is a legacy database then I can think of no clear way forward apart from evicting the object from the session and using a jdbc connection to alter the row.

If it's not a legacy database then re-consider your design.