Hi all,

Issue: I have 4 tables, PortSetup, Application and Scenario have each a one-to-many relationship with Mapping (for the current issue I provided Application to Mapping only but they all give me the same issue).

The issue happens when I try to have one of the relationship null (i.e. PortSetup and Scenario without an Application). For setup purposes, the user may want to make a partial setup then save to come back latter and finish it.

An example is creating a template of Application - mapping - PortSetup then letting the user assign it to given scenarios.

Every time I try to save the Mapping without assigning the Application I get the Exception : Caused by: java.sql.SQLException: Duplicate key or integrity constraint violation message from server: "Cannot add or update a child row: a foreign key constraint fails (`rtim`.`mapping`, CONSTRAINT `FK5CB7A4AE9970147B` FOREIGN KEY (`MAPPING_ID`) REFERENCES `application` (`APPLICATION_ID`))"


Hibernate version:3.3.1

-------------->Mapping Mapping:
<hibernate-mapping>
<class name="database.items.Mapping" table="MAPPING">
<id name="lMappingID" column="MAPPING_ID">
<generator class="native"/>
</id>

<property name="strMappingName"/>
<property name="strComment"/>
<property name="nLinkLocation"/>

<many-to-one name="TheScenario"
column="SCENARIO_ID"
not-null="false" class="database.items.Scenario"/>

<many-to-one name="TheApplication"
column="APPLICATION_ID"
not-null="false" class="database.items.Application"/>

<many-to-one name="ThePortSetup"
column="PORTSETUP_ID"
not-null="false" class="database.items.PortSetup"/>

</class>
</hibernate-mapping>


---------> Mapping Application:
<hibernate-mapping>
<class name="database.items.Application" table="APPLICATION">
<id name="lApplicationID" column="APPLICATION_ID">
<generator class="native"/>
</id>

<property name="strApplicationName"/>
<property name="strComment"/>

<set name="hsMapping" inverse="true">
<key column="MAPPING_ID"/>
<one-to-many class="database.items.Mapping"/>
</set>

</class>
</hibernate-mapping>

Code between sessionFactory.openSession() and session.close():


public void createMapping(PortSetup aPortSetup, Session aSession ){
Mapping aMapping = new Mapping();
Application aApp = new Application();
aMapping.setStrMappingName("Mapping of " + aPortSetup.getstrPortSetupName());
aApp.setStrApplicationName("an App");

aPortSetup.addMappingToPortSetup(aMapping);
aSession.save(aPortSetup);

aScenario.addMappingToScenario(aMapping);

// aMapping.setTheApplication(aApp);
// aSession.save(aApp);

aSession.save(aMapping);
java.lang.System.runFinalization();
}

Full stack trace of any exception that occurs:


Exception in thread "main" org.hibernate.exception.ConstraintViolationException: could not insert: [database.items.Mapping]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:64)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2186)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2666)
at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:71)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:321)
at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:204)
at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:130)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:210)
at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:56)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:195)
at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:50)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:93)
at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:562)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:550)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:546)
at sun.reflect.GeneratedMethodAccessor1.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.hibernate.context.ThreadLocalSessionContext$TransactionProtectionWrapper.invoke(ThreadLocalSessionContext.java:342)
at $Proxy0.save(Unknown Source)
at database.HibernateTester.createMapping(HibernateTester.java:161)
at database.HibernateTester.createPortSetup(HibernateTester.java:143)
at database.HibernateTester.createChildrenDSOSegmentLowLevelPort(HibernateTester.java:131)
at database.HibernateTester.createChildrenSegmentLevelPort(HibernateTester.java:121)
at database.HibernateTester.createChildrenDSOPort(HibernateTester.java:110)
at database.HibernateTester.createPort(HibernateTester.java:99)
at database.HibernateTester.createCim(HibernateTester.java:89)
at database.HibernateTester.createAndStore(HibernateTester.java:72)
at database.HibernateTester.main(HibernateTester.java:16)
Caused by: java.sql.SQLException: Duplicate key or integrity constraint violation message from server: "Cannot add or update a child row: a foreign key constraint fails (`rtim`.`mapping`, CONSTRAINT `FK5CB7A4AE9970147B` FOREIGN KEY (`MAPPING_ID`) REFERENCES `application` (`APPLICATION_ID`))"
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1997)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1167)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1278)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2247)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1772)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1619)
at org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:94)
at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:57)
... 29 more

Name and version of the database you are using:MYSQL 5.1

The generated SQL (show_sql=true):Hibernate: insert into MAPPING (strMappingName, strComment, nLinkLocation, SCENARIO_ID, APPLICATION_ID, PORTSETUP_ID) values (?, ?, ?, ?, ?, ?)


Debug level Hibernate log excerpt:

I think the <key> mapping for the <set> in Application is incorrect.



It should be

Thank you mate!