Hello,

I have a collection and modifications to the collections work in sync with the table. But this is only when I remove the unique and not null constraints on the association table(Association table has a reference to a parent object that is not null at the time of execution). After I add the constraints again the console starts showing the exceptions. Can anyone throw some light on this ? how is it internally executed ?

What I can conclude from this is first an update is fired to database for the changes and then the records are deleted. Hibernate is smart enough to track all this. Is there any other way out other than removing the constraint ?

Exception I get with null constraint :
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

nitin

This is a FAQ. Please read "parent child relationship" doc.

Thanx gavin,

I did change the mappings but still not working for me. The insert query is giving me an exception. Can I see the values somehow that it is trying to insert ?

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

Child :
<many-to-one name="parentSubject" class="com.imc.sts.domain.the.Subject" column="SUBJECT_ID" not-null="true" />

Exception :
Hibernate: insert into STS.METADATA_SUBJECT_APHASIA (TIMESTAMP, SUBJECT_ID, APHASIA_ID, ID) values (?, ?, ?, ?)
WARN [http8080-Processor2] JDBCExceptionReporter.logExceptions(38) | SQL Error: 1, SQLState: 23000
ERROR [http8080-Processor2] JDBCExceptionReporter.logExceptions(46) | ORA-00001: unique constraint (STS.SYS_C002207) violated

WARN [http8080-Processor2] JDBCExceptionReporter.logExceptions(38) | SQL Error: 1, SQLState: 23000
ERROR [http8080-Processor2] JDBCExceptionReporter.logExceptions(46) | ORA-00001: unique constraint (STS.SYS_C002207) violated

ERROR [http8080-Processor2] JDBCException.<init>(38) | Could not execute JDBC batch update
java.sql.SQLException: ORA-00001: unique constraint (STS.SYS_C002207) violated

Constraints :
- AphasiaId not null
- SubjectId not null
- Unique constraint on combination of AphasiaId and SubjectId
- Referential Integrity for AphasiaId and SubjectId,
- ID Primary key



nitin