Hello,

When I get the set from the persistent object the set has say 3 objects with ids 1,2,3. Now if I modify the collection and select only one of them say 2 it should reflect the database right ? I read the One Shot Delete and following the same method.

HashSet hs = PO.getAphasiaSet();
hs.clear(); // Clearing the old values
hs.add(dao.getAphasia(2)); // Adding new value
PO.setAphasiaSet(hs);
save(PO);

waiting for replies,


nitin

"one shot delete" does not apply to one-to-many associations, only many-to-many and collections of values

You need cascade="all-delete-orphan".

Thanx gavin,

I am still getting these exceptions.. And I cannot see a single delete query being fired on database.

Hibernate: update STS.METADATA_SUBJECT_APHASIA set SUBJECT_ID=null where SUBJECT_ID=? and ID=?
WARN [http8080-Processor2] JDBCExceptionReporter.logExceptions(38) | SQL Error: 1407, SQLState: 72000
ERROR [http8080-Processor2] JDBCExceptionReporter.logExceptions(46) | ORA-01407: cannot update ("STS"."METADATA_SUBJECT_APHASI
A"."SUBJECT_ID") to NULL

WARN [http8080-Processor2] JDBCExceptionReporter.logExceptions(38) | SQL Error: 1407, SQLState: 72000
ERROR [http8080-Processor2] JDBCExceptionReporter.logExceptions(46) | ORA-01407: cannot update ("STS"."METADATA_SUBJECT_APHASI
A"."SUBJECT_ID") to NULL

ERROR [http8080-Processor2] JDBCException.<init>(38) | Could not execute JDBC batch update
java.sql.SQLException: ORA-01407: cannot update ("STS"."METADATA_SUBJECT_APHASIA"."SUBJECT_ID") to NULL
.
.
.
ERROR [http8080-Processor2] SessionImpl.execute(2343) | Could not synchronize database state with session
net.sf.hibernate.JDBCException: Could not execute JDBC batch update


nitin

My set tag looks like this ..

<set name="aphasiaTypes" cascade="all-delete-orphan">
<key column="SUBJECT_ID"/>
<one-to-many class="com.imc.sts.domain.the.SubjectAphasia" />
</set>

nitin