I'm having a strange issue with cascading merges of an object graph. The problem is that one of the collections within the object graph is a SortedSet that I've supplied a Comparator for. When I issue a session.merge() on the root object in the object graph the saves begin to cascade nicely until for some strange reason the Comparator receives an object for comparison that contains a null property. The property is needed for the comparison operation so the compar fails with an NPE. I'm not entirely sure why this is happening. Details below:
Hibernate version:
3.1.3
Mapping documents:
The mapping documents are:
<hibernate-mapping>
<class name="com.takame.gelaca.model.base.Event" table="TBL_EVENTS">
<cache usage="nonstrict-read-write"/>
<id name="eventID" type="string" column="EVENT_ID" />
<property name="name" column="NAME" type="string" />
<property name="eventTypeString" column="EVENT_TYPE" type="string" />
<many-to-one name="parentEvent" class="com.takame.gelaca.model.base.Event" column="PARENT_EVENT_ID" not-null="false" cascade="save-update, merge"/>
<map name="events" inverse="true" cascade="save-update, merge">
<cache usage="nonstrict-read-write"/>
<key column="PARENT_EVENT_ID"/>
<map-key column="EVENT_ID" type="string"/>
<one-to-many class="com.takame.gelaca.model.base.Event"/>
</map>
<map name="markets" inverse="true" cascade="save-update, merge">
<cache usage="nonstrict-read-write"/>
<key column="PARENT_EVENT_ID"/>
<map-key column="MARKET_ID" type="string"/>
<one-to-many class="com.takame.gelaca.model.base.Market"/>
</map>
</class>
</hibernate-mapping>
<hibernate-mapping>
<class name="com.takame.gelaca.model.base.Market" table="TBL_MARKETS">
<cache usage="nonstrict-read-write"/>
<id name="marketID" type="string" column="MARKET_ID"></id>
<property name="name" column="NAME" type="string" />
<property name="marketTypeString" column="MARKET_TYPE" type="string" />
<property name="eventTypeString" column="EVENT_TYPE" type="string" />
<many-to-one name="parentEvent" class="com.takame.gelaca.model.base.Event" column="PARENT_EVENT_ID" not-null="false" cascade="save-update, merge"/>
<map name="runners" inverse="true" cascade="save-update, merge">
<cache usage="nonstrict-read-write"/>
<key column="MARKET_ID"/>
<map-key column="RUNNER_ID" type="string"/>
<one-to-many class="com.takame.gelaca.model.base.Runner"/>
</map>
<set name="marketSnapshots" sort="com.takame.gelaca.model.util.MarketSnapshotComparator" inverse="true" cascade="save-update, merge">
<cache usage="nonstrict-read-write"/>
<key column="MARKET_ID"/>
<one-to-many class="com.takame.gelaca.model.base.MarketSnapshot"/>
</set>
</class>
</hibernate-mapping>
<hibernate-mapping>
<class name="com.takame.gelaca.model.base.MarketSnapshot"
table="TBL_MARKET_SNAPSHOTS">
<cache usage="nonstrict-read-write"/>
<id name="marketSnapshotID" type="string"
column="SNAPSHOT_ID">
</id>
<property name="sequence" column="SEQUENCE"
type="long" />
<property name="snapshotDate" column="SNAPSHOT_DATE"
type="timestamp" />
<many-to-one name="market" column="MARKET_ID" not-null="true" cascade="save-update, merge"/>
<property name="closeDate" column="CLOSE_DATE" type="timestamp" />
<property name="totalMatchedSize" column="TOTAL_MATCHED_SIZE"
type="float" />
<set name="runnerSnapshots" sort="com.takame.gelaca.model.util.RunnerSnapshotComparator" inverse="true" cascade="save-update, merge">
<cache usage="nonstrict-read-write"/>
<key column="RUNNER_ID"/>
<one-to-many class="com.takame.gelaca.model.base.RunnerSnapshot"/>
</set>
</class>
</hibernate-mapping>
<hibernate-mapping>
<class name="com.takame.gelaca.model.base.Runner" table="TBL_RUNNERS">
<cache usage="nonstrict-read-write"/>
<id name="runnerID" type="string" column="RUNNER_ID"></id>
<property name="asianLineID" column="ASIAN_LINE_ID" type="string" />
<property name="handicap" column="HANDICAP" type="double" />
<many-to-one name="selection" column="SELECTION_ID" not-null="true" cascade="save-update, merge"/>
<many-to-one name="market" column="MARKET_ID" not-null="true" cascade="save-update, merge"/>
<set name="runnerSnapshots" sort="com.takame.gelaca.model.util.RunnerSnapshotComparator" inverse="true" cascade="save-update, merge">
<cache usage="nonstrict-read-write"/>
<key column="RUNNER_ID"/>
<one-to-many class="com.takame.gelaca.model.base.RunnerSnapshot"/>
</set>
</class>
</hibernate-mapping>
<hibernate-mapping>
<class name="com.takame.gelaca.model.base.RunnerSnapshot" table="TBL_RUNNER_SNAPSHOTS">
<cache usage="nonstrict-read-write"/>
<id name="runnerSnapshotID" type="string" column="RUNNER_SNAPSHOT_ID">
</id>
<many-to-one name="runner" column="RUNNER_ID" not-null="true" cascade="save-update, merge"/>
<many-to-one name="marketSnapshot" column="MARKET_SNAPSHOT_ID" not-null="true" cascade="save-update, merge"/>
<component name="availableBackBetAggregate1" class="com.takame.gelaca.model.base.BetAggregate">
<property name="price" column="BACK_PRICE_1" type="float" />
<property name="totalSize" column="BACK_SIZE_1" type="float" />
</component>
<component name="availableBackBetAggregate2" class="com.takame.gelaca.model.base.BetAggregate">
<property name="price" column="BACK_PRICE_2" type="float" />
<property name="totalSize" column="BACK_SIZE_2" type="float" />
</component>
<component name="availableBackBetAggregate3" class="com.takame.gelaca.model.base.BetAggregate">
<property name="price" column="BACK_PRICE_3" type="float" />
<property name="totalSize" column="BACK_SIZE_3" type="float" />
</component>
<component name="availableLayBetAggregate1" class="com.takame.gelaca.model.base.BetAggregate">
<property name="price" column="LAY_PRICE_1" type="float" />
<property name="totalSize" column="LAY_SIZE_1" type="float" />
</component>
<component name="availableLayBetAggregate2" class="com.takame.gelaca.model.base.BetAggregate">
<property name="price" column="LAY_PRICE_2" type="float" />
<property name="totalSize" column="LAY_SIZE_2" type="float" />
</component>
<component name="availableLayBetAggregate3" class="com.takame.gelaca.model.base.BetAggregate">
<property name="price" column="LAY_PRICE_3" type="float" />
<property name="totalSize" column="LAY_SIZE_3" type="float" />
</component>
</class>
</hibernate-mapping>
<hibernate-mapping>
<class name="com.takame.gelaca.model.base.Selection"
table="TBL_SELECTIONS">
<cache usage="nonstrict-read-write"/>
<id name="selectionID" type="string" column="SELECTION_ID"></id>
<property name="name" column="NAME" type="string" />
</class>
</hibernate-mapping>
Code between sessionFactory.openSession() and session.close():
transaction = session.beginTransaction();
if(events != null){
for (Event newEvent : events.values()) {
Event persistableEvent = (Event) Application.getInstance().getHibernateSession().merge(newEvent);
Application.getInstance().getHibernateSession().saveOrUpdate(persistableEvent);
}
}
transaction.commit();
Comparator is...
public class RunnerSnapshotComparator implements Comparator<RunnerSnapshot>{
public int compare(RunnerSnapshot rs1, RunnerSnapshot rs2) {
if(rs1.getRunner().getRunnerID().compareTo(rs2.getRunner().getRunnerID()) < 0){ <----- NPE happens here
return -1;
}
else if(rs1.getRunner().getRunnerID().compareTo(rs2.getRunner().getRunnerID()) > 0){
return 1;
}
else{
if(rs1.getMarketSnapshot().getSequence() < rs2.getMarketSnapshot().getSequence()){
return -1;
}
if(rs1.getMarketSnapshot().getSequence() > rs2.getMarketSnapshot().getSequence()){
return 1;
}
else{
return 0;
}
}
}
}
Full stack trace of any exception that occurs:
java.lang.Exception: java.lang.NullPointerException
at com.takame.gelaca.engines.ModelPersister.persistModelToDatabase(ModelPersister.java:34)
at com.takame.gelaca.managers.MarketHierarchyLoader.reloadAndPersistMarketHierarchy(MarketHierarchyLoader.java:270)
at com.takame.gelaca.swing.ApplicationFrame$6$1.call(ApplicationFrame.java:450)
at com.takame.gelaca.swing.ApplicationFrame$7.run(ApplicationFrame.java:472)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.lang.NullPointerException
at com.takame.gelaca.model.util.RunnerSnapshotComparator.compare(RunnerSnapshotComparator.java:31)
at com.takame.gelaca.model.util.RunnerSnapshotComparator.compare(RunnerSnapshotComparator.java:1)
at java.util.TreeMap.compare(TreeMap.java:1093)
at java.util.TreeMap.put(TreeMap.java:465)
at java.util.TreeSet.add(TreeSet.java:210)
at org.hibernate.type.CollectionType.replaceElements(CollectionType.java:410)
at org.hibernate.type.CollectionType.replace(CollectionType.java:443)
at org.hibernate.type.AbstractType.replace(AbstractType.java:153)
at org.hibernate.type.TypeFactory.replace(TypeFactory.java:447)
at org.hibernate.event.def.DefaultMergeEventListener.copyValues(DefaultMergeEventListener.java:302)
at org.hibernate.event.def.DefaultMergeEventListener.entityIsTransient(DefaultMergeEventListener.java:175)
at org.hibernate.event.def.DefaultMergeEventListener.entityIsDetached(DefaultMergeEventListener.java:220)
at org.hibernate.event.def.DefaultMergeEventListener.onMerge(DefaultMergeEventListener.java:100)
at org.hibernate.impl.SessionImpl.fireMerge(SessionImpl.java:682)
at org.hibernate.impl.SessionImpl.merge(SessionImpl.java:664)
at org.hibernate.engine.CascadingAction$6.cascade(CascadingAction.java:156)
at org.hibernate.engine.Cascade.cascadeToOne(Cascade.java:213)
at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:157)
at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:108)
at org.hibernate.engine.Cascade.cascade(Cascade.java:248)
at org.hibernate.event.def.AbstractSaveEventListener.cascadeBeforeSave(AbstractSaveEventListener.java:385)
at org.hibernate.event.def.DefaultMergeEventListener.entityIsTransient(DefaultMergeEventListener.java:158)
at org.hibernate.event.def.DefaultMergeEventListener.entityIsDetached(DefaultMergeEventListener.java:220)
at org.hibernate.event.def.DefaultMergeEventListener.onMerge(DefaultMergeEventListener.java:100)
at org.hibernate.impl.SessionImpl.fireMerge(SessionImpl.java:682)
at org.hibernate.impl.SessionImpl.merge(SessionImpl.java:664)
at org.hibernate.engine.CascadingAction$6.cascade(CascadingAction.java:156)
at org.hibernate.engine.Cascade.cascadeToOne(Cascade.java:213)
at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:157)
at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:108)
at org.hibernate.engine.Cascade.cascadeCollectionElements(Cascade.java:290)
at org.hibernate.engine.Cascade.cascadeCollection(Cascade.java:185)
at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:160)
at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:108)
at org.hibernate.engine.Cascade.cascade(Cascade.java:248)
at org.hibernate.event.def.AbstractSaveEventListener.cascadeAfterSave(AbstractSaveEventListener.java:410)
at org.hibernate.event.def.DefaultMergeEventListener.entityIsTransient(DefaultMergeEventListener.java:174)
at org.hibernate.event.def.DefaultMergeEventListener.entityIsDetached(DefaultMergeEventListener.java:220)
at org.hibernate.event.def.DefaultMergeEventListener.onMerge(DefaultMergeEventListener.java:100)
at org.hibernate.impl.SessionImpl.fireMerge(SessionImpl.java:682)
at org.hibernate.impl.SessionImpl.merge(SessionImpl.java:664)
at org.hibernate.engine.CascadingAction$6.cascade(CascadingAction.java:156)
at org.hibernate.engine.Cascade.cascadeToOne(Cascade.java:213)
at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:157)
at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:108)
at org.hibernate.engine.Cascade.cascadeCollectionElements(Cascade.java:290)
at org.hibernate.engine.Cascade.cascadeCollection(Cascade.java:185)
at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:160)
at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:108)
at org.hibernate.engine.Cascade.cascade(Cascade.java:248)
at org.hibernate.event.def.AbstractSaveEventListener.cascadeAfterSave(AbstractSaveEventListener.java:410)
at org.hibernate.event.def.DefaultMergeEventListener.entityIsTransient(DefaultMergeEventListener.java:174)
at org.hibernate.event.def.DefaultMergeEventListener.entityIsDetached(DefaultMergeEventListener.java:220)
at org.hibernate.event.def.DefaultMergeEventListener.onMerge(DefaultMergeEventListener.java:100)
at org.hibernate.impl.SessionImpl.fireMerge(SessionImpl.java:682)
at org.hibernate.impl.SessionImpl.merge(SessionImpl.java:664)
at org.hibernate.engine.CascadingAction$6.cascade(CascadingAction.java:156)
at org.hibernate.engine.Cascade.cascadeToOne(Cascade.java:213)
at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:157)
at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:108)
at org.hibernate.engine.Cascade.cascadeCollectionElements(Cascade.java:290)
at org.hibernate.engine.Cascade.cascadeCollection(Cascade.java:185)
at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:160)
at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:108)
at org.hibernate.engine.Cascade.cascade(Cascade.java:248)
at org.hibernate.event.def.AbstractSaveEventListener.cascadeAfterSave(AbstractSaveEventListener.java:410)
at org.hibernate.event.def.DefaultMergeEventListener.entityIsTransient(DefaultMergeEventListener.java:174)
at org.hibernate.event.def.DefaultMergeEventListener.entityIsDetached(DefaultMergeEventListener.java:220)
at org.hibernate.event.def.DefaultMergeEventListener.onMerge(DefaultMergeEventListener.java:100)
at org.hibernate.impl.SessionImpl.fireMerge(SessionImpl.java:682)
at org.hibernate.impl.SessionImpl.merge(SessionImpl.java:664)
at org.hibernate.engine.CascadingAction$6.cascade(CascadingAction.java:156)
at org.hibernate.engine.Cascade.cascadeToOne(Cascade.java:213)
at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:157)
at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:108)
at org.hibernate.engine.Cascade.cascadeCollectionElements(Cascade.java:290)
at org.hibernate.engine.Cascade.cascadeCollection(Cascade.java:185)
at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:160)
at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:108)
at org.hibernate.engine.Cascade.cascade(Cascade.java:248)
at org.hibernate.event.def.AbstractSaveEventListener.cascadeAfterSave(AbstractSaveEventListener.java:410)
at org.hibernate.event.def.DefaultMergeEventListener.entityIsTransient(DefaultMergeEventListener.java:174)
at org.hibernate.event.def.DefaultMergeEventListener.entityIsDetached(DefaultMergeEventListener.java:220)
at org.hibernate.event.def.DefaultMergeEventListener.onMerge(DefaultMergeEventListener.java:100)
at org.hibernate.impl.SessionImpl.fireMerge(SessionImpl.java:682)
at org.hibernate.impl.SessionImpl.merge(SessionImpl.java:664)
at org.hibernate.engine.CascadingAction$6.cascade(CascadingAction.java:156)
at org.hibernate.engine.Cascade.cascadeToOne(Cascade.java:213)
at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:157)
at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:108)
at org.hibernate.engine.Cascade.cascadeCollectionElements(Cascade.java:290)
at org.hibernate.engine.Cascade.cascadeCollection(Cascade.java:185)
at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:160)
at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:108)
at org.hibernate.engine.Cascade.cascade(Cascade.java:248)
at org.hibernate.event.def.AbstractSaveEventListener.cascadeAfterSave(AbstractSaveEventListener.java:410)
at org.hibernate.event.def.DefaultMergeEventListener.entityIsTransient(DefaultMergeEventListener.java:174)
at org.hibernate.event.def.DefaultMergeEventListener.entityIsDetached(DefaultMergeEventListener.java:220)
at org.hibernate.event.def.DefaultMergeEventListener.onMerge(DefaultMergeEventListener.java:100)
at org.hibernate.impl.SessionImpl.fireMerge(SessionImpl.java:682)
at org.hibernate.impl.SessionImpl.merge(SessionImpl.java:664)
at org.hibernate.engine.CascadingAction$6.cascade(CascadingAction.java:156)
at org.hibernate.engine.Cascade.cascadeToOne(Cascade.java:213)
at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:157)
at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:108)
at org.hibernate.engine.Cascade.cascadeCollectionElements(Cascade.java:290)
at org.hibernate.engine.Cascade.cascadeCollection(Cascade.java:185)
at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:160)
at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:108)
at org.hibernate.engine.Cascade.cascade(Cascade.java:248)
at org.hibernate.event.def.AbstractSaveEventListener.cascadeAfterSave(AbstractSaveEventListener.java:410)
at org.hibernate.event.def.DefaultMergeEventListener.entityIsTransient(DefaultMergeEventListener.java:174)
at org.hibernate.event.def.DefaultMergeEventListener.entityIsDetached(DefaultMergeEventListener.java:220)
at org.hibernate.event.def.DefaultMergeEventListener.onMerge(DefaultMergeEventListener.java:100)
at org.hibernate.impl.SessionImpl.fireMerge(SessionImpl.java:682)
at org.hibernate.impl.SessionImpl.merge(SessionImpl.java:664)
at org.hibernate.engine.CascadingAction$6.cascade(CascadingAction.java:156)
at org.hibernate.engine.Cascade.cascadeToOne(Cascade.java:213)
at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:157)
at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:108)
at org.hibernate.engine.Cascade.cascadeCollectionElements(Cascade.java:290)
at org.hibernate.engine.Cascade.cascadeCollection(Cascade.java:185)
at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:160)
at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:108)
at org.hibernate.engine.Cascade.cascade(Cascade.java:248)
at org.hibernate.event.def.AbstractSaveEventListener.cascadeAfterSave(AbstractSaveEventListener.java:410)
at org.hibernate.event.def.DefaultMergeEventListener.entityIsTransient(DefaultMergeEventListener.java:174)
at org.hibernate.event.def.DefaultMergeEventListener.entityIsDetached(DefaultMergeEventListener.java:220)
at org.hibernate.event.def.DefaultMergeEventListener.onMerge(DefaultMergeEventListener.java:100)
at org.hibernate.impl.SessionImpl.fireMerge(SessionImpl.java:682)
at org.hibernate.impl.SessionImpl.merge(SessionImpl.java:664)
at org.hibernate.engine.CascadingAction$6.cascade(CascadingAction.java:156)
at org.hibernate.engine.Cascade.cascadeToOne(Cascade.java:213)
at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:157)
at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:108)
at org.hibernate.engine.Cascade.cascade(Cascade.java:248)
at org.hibernate.event.def.AbstractSaveEventListener.cascadeBeforeSave(AbstractSaveEventListener.java:385)
at org.hibernate.event.def.DefaultMergeEventListener.entityIsTransient(DefaultMergeEventListener.java:158)
at org.hibernate.event.def.DefaultMergeEventListener.entityIsDetached(DefaultMergeEventListener.java:220)
at org.hibernate.event.def.DefaultMergeEventListener.onMerge(DefaultMergeEventListener.java:100)
at org.hibernate.impl.SessionImpl.fireMerge(SessionImpl.java:682)
at org.hibernate.impl.SessionImpl.merge(SessionImpl.java:664)
at org.hibernate.engine.CascadingAction$6.cascade(CascadingAction.java:156)
at org.hibernate.engine.Cascade.cascadeToOne(Cascade.java:213)
at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:157)
at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:108)
at org.hibernate.engine.Cascade.cascade(Cascade.java:248)
at org.hibernate.event.def.AbstractSaveEventListener.cascadeBeforeSave(AbstractSaveEventListener.java:385)
at org.hibernate.event.def.DefaultMergeEventListener.entityIsTransient(DefaultMergeEventListener.java:158)
at org.hibernate.event.def.DefaultMergeEventListener.entityIsDetached(DefaultMergeEventListener.java:220)
at org.hibernate.event.def.DefaultMergeEventListener.onMerge(DefaultMergeEventListener.java:100)
at org.hibernate.impl.SessionImpl.fireMerge(SessionImpl.java:682)
at org.hibernate.impl.SessionImpl.merge(SessionImpl.java:664)
at org.hibernate.engine.CascadingAction$6.cascade(CascadingAction.java:156)
at org.hibernate.engine.Cascade.cascadeToOne(Cascade.java:213)
at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:157)
at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:108)
at org.hibernate.engine.Cascade.cascade(Cascade.java:248)
at org.hibernate.event.def.AbstractSaveEventListener.cascadeBeforeSave(AbstractSaveEventListener.java:385)
at org.hibernate.event.def.DefaultMergeEventListener.entityIsTransient(DefaultMergeEventListener.java:158)
at org.hibernate.event.def.DefaultMergeEventListener.entityIsDetached(DefaultMergeEventListener.java:220)
at org.hibernate.event.def.DefaultMergeEventListener.onMerge(DefaultMergeEventListener.java:100)
at org.hibernate.impl.SessionImpl.fireMerge(SessionImpl.java:682)
at org.hibernate.impl.SessionImpl.merge(SessionImpl.java:664)
at org.hibernate.engine.CascadingAction$6.cascade(CascadingAction.java:156)
at org.hibernate.engine.Cascade.cascadeToOne(Cascade.java:213)
at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:157)
at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:108)
at org.hibernate.engine.Cascade.cascade(Cascade.java:248)
at org.hibernate.event.def.AbstractSaveEventListener.cascadeBeforeSave(AbstractSaveEventListener.java:385)
at org.hibernate.event.def.DefaultMergeEventListener.entityIsTransient(DefaultMergeEventListener.java:158)
at org.hibernate.event.def.DefaultMergeEventListener.entityIsDetached(DefaultMergeEventListener.java:220)
at org.hibernate.event.def.DefaultMergeEventListener.onMerge(DefaultMergeEventListener.java:100)
at org.hibernate.event.def.DefaultMergeEventListener.onMerge(DefaultMergeEventListener.java:52)
at org.hibernate.impl.SessionImpl.fireMerge(SessionImpl.java:672)
at org.hibernate.impl.SessionImpl.merge(SessionImpl.java:656)
at org.hibernate.impl.SessionImpl.merge(SessionImpl.java:660)
at com.takame.gelaca.engines.ModelMerger.mergeEvents(ModelMerger.java:387)
at com.takame.gelaca.engines.ModelMerger.merge(ModelMerger.java:326)
at com.takame.gelaca.engines.ModelPersister.persistModelToDatabase(ModelPersister.java:22)
... 6 more
Name and version of the database you are using:
MySQL 5.10.21
The generated SQL (show_sql=true):
17:34:05,110 DEBUG SQL:346 - select event0_.EVENT_ID as EVENT1_0_2_, event0_.NAME as NAME0_2_, event0_.EVENT_TYPE as EVENT3_0_2_, event0_.PARENT_EVENT_ID as PARENT4_0_2_, event1_.EVENT_ID as EVENT1_0_0_, event1_.NAME as NAME0_0_, event1_.EVENT_TYPE as EVENT3_0_0_, event1_.PARENT_EVENT_ID as PARENT4_0_0_, markets2_.PARENT_EVENT_ID as PARENT5_4_, markets2_.MARKET_ID as MARKET1_4_, markets2_.MARKET_ID as MARKET1_1_1_, markets2_.NAME as NAME1_1_, markets2_.MARKET_TYPE as MARKET3_1_1_, markets2_.EVENT_TYPE as EVENT4_1_1_, markets2_.PARENT_EVENT_ID as PARENT5_1_1_ from TBL_EVENTS event0_ left outer join TBL_EVENTS event1_ on event0_.PARENT_EVENT_ID=event1_.EVENT_ID left outer join TBL_MARKETS markets2_ on event1_.EVENT_ID=markets2_.PARENT_EVENT_ID where event0_.EVENT_ID=?
17:34:05,125 DEBUG SQL:346 - select event0_.EVENT_ID as EVENT1_0_2_, event0_.NAME as NAME0_2_, event0_.EVENT_TYPE as EVENT3_0_2_, event0_.PARENT_EVENT_ID as PARENT4_0_2_, event1_.EVENT_ID as EVENT1_0_0_, event1_.NAME as NAME0_0_, event1_.EVENT_TYPE as EVENT3_0_0_, event1_.PARENT_EVENT_ID as PARENT4_0_0_, markets2_.PARENT_EVENT_ID as PARENT5_4_, markets2_.MARKET_ID as MARKET1_4_, markets2_.MARKET_ID as MARKET1_1_1_, markets2_.NAME as NAME1_1_, markets2_.MARKET_TYPE as MARKET3_1_1_, markets2_.EVENT_TYPE as EVENT4_1_1_, markets2_.PARENT_EVENT_ID as PARENT5_1_1_ from TBL_EVENTS event0_ left outer join TBL_EVENTS event1_ on event0_.PARENT_EVENT_ID=event1_.EVENT_ID left outer join TBL_MARKETS markets2_ on event1_.EVENT_ID=markets2_.PARENT_EVENT_ID where event0_.EVENT_ID=?
17:34:05,141 DEBUG SQL:346 - select event0_.EVENT_ID as EVENT1_0_2_, event0_.NAME as NAME0_2_, event0_.EVENT_TYPE as EVENT3_0_2_, event0_.PARENT_EVENT_ID as PARENT4_0_2_, event1_.EVENT_ID as EVENT1_0_0_, event1_.NAME as NAME0_0_, event1_.EVENT_TYPE as EVENT3_0_0_, event1_.PARENT_EVENT_ID as PARENT4_0_0_, markets2_.PARENT_EVENT_ID as PARENT5_4_, markets2_.MARKET_ID as MARKET1_4_, markets2_.MARKET_ID as MARKET1_1_1_, markets2_.NAME as NAME1_1_, markets2_.MARKET_TYPE as MARKET3_1_1_, markets2_.EVENT_TYPE as EVENT4_1_1_, markets2_.PARENT_EVENT_ID as PARENT5_1_1_ from TBL_EVENTS event0_ left outer join TBL_EVENTS event1_ on event0_.PARENT_EVENT_ID=event1_.EVENT_ID left outer join TBL_MARKETS markets2_ on event1_.EVENT_ID=markets2_.PARENT_EVENT_ID where event0_.EVENT_ID=?
17:34:05,156 DEBUG SQL:346 - select event0_.EVENT_ID as EVENT1_0_2_, event0_.NAME as NAME0_2_, event0_.EVENT_TYPE as EVENT3_0_2_, event0_.PARENT_EVENT_ID as PARENT4_0_2_, event1_.EVENT_ID as EVENT1_0_0_, event1_.NAME as NAME0_0_, event1_.EVENT_TYPE as EVENT3_0_0_, event1_.PARENT_EVENT_ID as PARENT4_0_0_, markets2_.PARENT_EVENT_ID as PARENT5_4_, markets2_.MARKET_ID as MARKET1_4_, markets2_.MARKET_ID as MARKET1_1_1_, markets2_.NAME as NAME1_1_, markets2_.MARKET_TYPE as MARKET3_1_1_, markets2_.EVENT_TYPE as EVENT4_1_1_, markets2_.PARENT_EVENT_ID as PARENT5_1_1_ from TBL_EVENTS event0_ left outer join TBL_EVENTS event1_ on event0_.PARENT_EVENT_ID=event1_.EVENT_ID left outer join TBL_MARKETS markets2_ on event1_.EVENT_ID=markets2_.PARENT_EVENT_ID where event0_.EVENT_ID=?
17:34:05,156 DEBUG SQL:346 - select event0_.EVENT_ID as EVENT1_0_2_, event0_.NAME as NAME0_2_, event0_.EVENT_TYPE as EVENT3_0_2_, event0_.PARENT_EVENT_ID as PARENT4_0_2_, event1_.EVENT_ID as EVENT1_0_0_, event1_.NAME as NAME0_0_, event1_.EVENT_TYPE as EVENT3_0_0_, event1_.PARENT_EVENT_ID as PARENT4_0_0_, markets2_.PARENT_EVENT_ID as PARENT5_4_, markets2_.MARKET_ID as MARKET1_4_, markets2_.MARKET_ID as MARKET1_1_1_, markets2_.NAME as NAME1_1_, markets2_.MARKET_TYPE as MARKET3_1_1_, markets2_.EVENT_TYPE as EVENT4_1_1_, markets2_.PARENT_EVENT_ID as PARENT5_1_1_ from TBL_EVENTS event0_ left outer join TBL_EVENTS event1_ on event0_.PARENT_EVENT_ID=event1_.EVENT_ID left outer join TBL_MARKETS markets2_ on event1_.EVENT_ID=markets2_.PARENT_EVENT_ID where event0_.EVENT_ID=?
17:34:05,172 DEBUG SQL:346 - select event0_.EVENT_ID as EVENT1_0_2_, event0_.NAME as NAME0_2_, event0_.EVENT_TYPE as EVENT3_0_2_, event0_.PARENT_EVENT_ID as PARENT4_0_2_, event1_.EVENT_ID as EVENT1_0_0_, event1_.NAME as NAME0_0_, event1_.EVENT_TYPE as EVENT3_0_0_, event1_.PARENT_EVENT_ID as PARENT4_0_0_, markets2_.PARENT_EVENT_ID as PARENT5_4_, markets2_.MARKET_ID as MARKET1_4_, markets2_.MARKET_ID as MARKET1_1_1_, markets2_.NAME as NAME1_1_, markets2_.MARKET_TYPE as MARKET3_1_1_, markets2_.EVENT_TYPE as EVENT4_1_1_, markets2_.PARENT_EVENT_ID as PARENT5_1_1_ from TBL_EVENTS event0_ left outer join TBL_EVENTS event1_ on event0_.PARENT_EVENT_ID=event1_.EVENT_ID left outer join TBL_MARKETS markets2_ on event1_.EVENT_ID=markets2_.PARENT_EVENT_ID where event0_.EVENT_ID=?
17:34:05,188 DEBUG SQL:346 - select event0_.EVENT_ID as EVENT1_0_2_, event0_.NAME as NAME0_2_, event0_.EVENT_TYPE as EVENT3_0_2_, event0_.PARENT_EVENT_ID as PARENT4_0_2_, event1_.EVENT_ID as EVENT1_0_0_, event1_.NAME as NAME0_0_, event1_.EVENT_TYPE as EVENT3_0_0_, event1_.PARENT_EVENT_ID as PARENT4_0_0_, markets2_.PARENT_EVENT_ID as PARENT5_4_, markets2_.MARKET_ID as MARKET1_4_, markets2_.MARKET_ID as MARKET1_1_1_, markets2_.NAME as NAME1_1_, markets2_.MARKET_TYPE as MARKET3_1_1_, markets2_.EVENT_TYPE as EVENT4_1_1_, markets2_.PARENT_EVENT_ID as PARENT5_1_1_ from TBL_EVENTS event0_ left outer join TBL_EVENTS event1_ on event0_.PARENT_EVENT_ID=event1_.EVENT_ID left outer join TBL_MARKETS markets2_ on event1_.EVENT_ID=markets2_.PARENT_EVENT_ID where event0_.EVENT_ID=?
17:34:05,203 DEBUG SQL:346 - select event0_.EVENT_ID as EVENT1_0_2_, event0_.NAME as NAME0_2_, event0_.EVENT_TYPE as EVENT3_0_2_, event0_.PARENT_EVENT_ID as PARENT4_0_2_, event1_.EVENT_ID as EVENT1_0_0_, event1_.NAME as NAME0_0_, event1_.EVENT_TYPE as EVENT3_0_0_, event1_.PARENT_EVENT_ID as PARENT4_0_0_, markets2_.PARENT_EVENT_ID as PARENT5_4_, markets2_.MARKET_ID as MARKET1_4_, markets2_.MARKET_ID as MARKET1_1_1_, markets2_.NAME as NAME1_1_, markets2_.MARKET_TYPE as MARKET3_1_1_, markets2_.EVENT_TYPE as EVENT4_1_1_, markets2_.PARENT_EVENT_ID as PARENT5_1_1_ from TBL_EVENTS event0_ left outer join TBL_EVENTS event1_ on event0_.PARENT_EVENT_ID=event1_.EVENT_ID left outer join TBL_MARKETS markets2_ on event1_.EVENT_ID=markets2_.PARENT_EVENT_ID where event0_.EVENT_ID=?
17:34:05,203 DEBUG SQL:346 - select event0_.EVENT_ID as EVENT1_0_2_, event0_.NAME as NAME0_2_, event0_.EVENT_TYPE as EVENT3_0_2_, event0_.PARENT_EVENT_ID as PARENT4_0_2_, event1_.EVENT_ID as EVENT1_0_0_, event1_.NAME as NAME0_0_, event1_.EVENT_TYPE as EVENT3_0_0_, event1_.PARENT_EVENT_ID as PARENT4_0_0_, markets2_.PARENT_EVENT_ID as PARENT5_4_, markets2_.MARKET_ID as MARKET1_4_, markets2_.MARKET_ID as MARKET1_1_1_, markets2_.NAME as NAME1_1_, markets2_.MARKET_TYPE as MARKET3_1_1_, markets2_.EVENT_TYPE as EVENT4_1_1_, markets2_.PARENT_EVENT_ID as PARENT5_1_1_ from TBL_EVENTS event0_ left outer join TBL_EVENTS event1_ on event0_.PARENT_EVENT_ID=event1_.EVENT_ID left outer join TBL_MARKETS markets2_ on event1_.EVENT_ID=markets2_.PARENT_EVENT_ID where event0_.EVENT_ID=?
17:34:05,219 DEBUG SQL:346 - select market0_.MARKET_ID as MARKET1_1_5_, market0_.NAME as NAME1_5_, market0_.MARKET_TYPE as MARKET3_1_5_, market0_.EVENT_TYPE as EVENT4_1_5_, market0_.PARENT_EVENT_ID as PARENT5_1_5_, event1_.EVENT_ID as EVENT1_0_0_, event1_.NAME as NAME0_0_, event1_.EVENT_TYPE as EVENT3_0_0_, event1_.PARENT_EVENT_ID as PARENT4_0_0_, event2_.EVENT_ID as EVENT1_0_1_, event2_.NAME as NAME0_1_, event2_.EVENT_TYPE as EVENT3_0_1_, event2_.PARENT_EVENT_ID as PARENT4_0_1_, runners3_.MARKET_ID as MARKET5_7_, runners3_.RUNNER_ID as RUNNER1_7_, runners3_.RUNNER_ID as RUNNER1_2_2_, runners3_.ASIAN_LINE_ID as ASIAN2_2_2_, runners3_.HANDICAP as HANDICAP2_2_, runners3_.SELECTION_ID as SELECTION4_2_2_, runners3_.MARKET_ID as MARKET5_2_2_, selection4_.SELECTION_ID as SELECTION1_3_3_, selection4_.NAME as NAME3_3_, runnersnap5_.RUNNER_ID as RUNNER2_8_, runnersnap5_.RUNNER_SNAPSHOT_ID as RUNNER1_8_, runnersnap5_.RUNNER_SNAPSHOT_ID as RUNNER1_5_4_, runnersnap5_.RUNNER_ID as RUNNER2_5_4_, runnersnap5_.MARKET_SNAPSHOT_ID as MARKET3_5_4_, runnersnap5_.BACK_PRICE_1 as BACK4_5_4_, runnersnap5_.BACK_SIZE_1 as BACK5_5_4_, runnersnap5_.BACK_PRICE_2 as BACK6_5_4_, runnersnap5_.BACK_SIZE_2 as BACK7_5_4_, runnersnap5_.BACK_PRICE_3 as BACK8_5_4_, runnersnap5_.BACK_SIZE_3 as BACK9_5_4_, runnersnap5_.LAY_PRICE_1 as LAY10_5_4_, runnersnap5_.LAY_SIZE_1 as LAY11_5_4_, runnersnap5_.LAY_PRICE_2 as LAY12_5_4_, runnersnap5_.LAY_SIZE_2 as LAY13_5_4_, runnersnap5_.LAY_PRICE_3 as LAY14_5_4_, runnersnap5_.LAY_SIZE_3 as LAY15_5_4_ from TBL_MARKETS market0_ left outer join TBL_EVENTS event1_ on market0_.PARENT_EVENT_ID=event1_.EVENT_ID left outer join TBL_EVENTS event2_ on event1_.PARENT_EVENT_ID=event2_.EVENT_ID left outer join TBL_RUNNERS runners3_ on market0_.MARKET_ID=runners3_.MARKET_ID left outer join TBL_SELECTIONS selection4_ on runners3_.SELECTION_ID=selection4_.SELECTION_ID left outer join TBL_RUNNER_SNAPSHOTS runnersnap5_ on runners3_.RUNNER_ID=runnersnap5_.RUNNER_ID where market0_.MARKET_ID=?
17:34:05,250 DEBUG SQL:346 - select runner0_.RUNNER_ID as RUNNER1_2_5_, runner0_.ASIAN_LINE_ID as ASIAN2_2_5_, runner0_.HANDICAP as HANDICAP2_5_, runner0_.SELECTION_ID as SELECTION4_2_5_, runner0_.MARKET_ID as MARKET5_2_5_, selection1_.SELECTION_ID as SELECTION1_3_0_, selection1_.NAME as NAME3_0_, market2_.MARKET_ID as MARKET1_1_1_, market2_.NAME as NAME1_1_, market2_.MARKET_TYPE as MARKET3_1_1_, market2_.EVENT_TYPE as EVENT4_1_1_, market2_.PARENT_EVENT_ID as PARENT5_1_1_, event3_.EVENT_ID as EVENT1_0_2_, event3_.NAME as NAME0_2_, event3_.EVENT_TYPE as EVENT3_0_2_, event3_.PARENT_EVENT_ID as PARENT4_0_2_, marketsnap4_.MARKET_ID as MARKET4_7_, marketsnap4_.SNAPSHOT_ID as SNAPSHOT1_7_, marketsnap4_.SNAPSHOT_ID as SNAPSHOT1_4_3_, marketsnap4_.SEQUENCE as SEQUENCE4_3_, marketsnap4_.SNAPSHOT_DATE as SNAPSHOT3_4_3_, marketsnap4_.MARKET_ID as MARKET4_4_3_, marketsnap4_.CLOSE_DATE as CLOSE5_4_3_, marketsnap4_.TOTAL_MATCHED_SIZE as TOTAL6_4_3_, runnersnap5_.RUNNER_ID as RUNNER2_8_, runnersnap5_.RUNNER_SNAPSHOT_ID as RUNNER1_8_, runnersnap5_.RUNNER_SNAPSHOT_ID as RUNNER1_5_4_, runnersnap5_.RUNNER_ID as RUNNER2_5_4_, runnersnap5_.MARKET_SNAPSHOT_ID as MARKET3_5_4_, runnersnap5_.BACK_PRICE_1 as BACK4_5_4_, runnersnap5_.BACK_SIZE_1 as BACK5_5_4_, runnersnap5_.BACK_PRICE_2 as BACK6_5_4_, runnersnap5_.BACK_SIZE_2 as BACK7_5_4_, runnersnap5_.BACK_PRICE_3 as BACK8_5_4_, runnersnap5_.BACK_SIZE_3 as BACK9_5_4_, runnersnap5_.LAY_PRICE_1 as LAY10_5_4_, runnersnap5_.LAY_SIZE_1 as LAY11_5_4_, runnersnap5_.LAY_PRICE_2 as LAY12_5_4_, runnersnap5_.LAY_SIZE_2 as LAY13_5_4_, runnersnap5_.LAY_PRICE_3 as LAY14_5_4_, runnersnap5_.LAY_SIZE_3 as LAY15_5_4_ from TBL_RUNNERS runner0_ inner join TBL_SELECTIONS selection1_ on runner0_.SELECTION_ID=selection1_.SELECTION_ID inner join TBL_MARKETS market2_ on runner0_.MARKET_ID=market2_.MARKET_ID left outer join TBL_EVENTS event3_ on market2_.PARENT_EVENT_ID=event3_.EVENT_ID left outer join TBL_MARKET_SNAPSHOTS marketsnap4_ on market2_.MARKET_ID=marketsnap4_.MARKET_ID left outer join TBL_RUNNER_SNAPSHOTS runnersnap5_ on runner0_.RUNNER_ID=runnersnap5_.RUNNER_ID where runner0_.RUNNER_ID=?
17:34:05,360 DEBUG SQL:346 - select selection0_.SELECTION_ID as SELECTION1_3_0_, selection0_.NAME as NAME3_0_ from TBL_SELECTIONS selection0_ where selection0_.SELECTION_ID=?
17:34:05,375 DEBUG SQL:346 - select runnersnap0_.RUNNER_SNAPSHOT_ID as RUNNER1_5_5_, runnersnap0_.RUNNER_ID as RUNNER2_5_5_, runnersnap0_.MARKET_SNAPSHOT_ID as MARKET3_5_5_, runnersnap0_.BACK_PRICE_1 as BACK4_5_5_, runnersnap0_.BACK_SIZE_1 as BACK5_5_5_, runnersnap0_.BACK_PRICE_2 as BACK6_5_5_, runnersnap0_.BACK_SIZE_2 as BACK7_5_5_, runnersnap0_.BACK_PRICE_3 as BACK8_5_5_, runnersnap0_.BACK_SIZE_3 as BACK9_5_5_, runnersnap0_.LAY_PRICE_1 as LAY10_5_5_, runnersnap0_.LAY_SIZE_1 as LAY11_5_5_, runnersnap0_.LAY_PRICE_2 as LAY12_5_5_, runnersnap0_.LAY_SIZE_2 as LAY13_5_5_, runnersnap0_.LAY_PRICE_3 as LAY14_5_5_, runnersnap0_.LAY_SIZE_3 as LAY15_5_5_, runner1_.RUNNER_ID as RUNNER1_2_0_, runner1_.ASIAN_LINE_ID as ASIAN2_2_0_, runner1_.HANDICAP as HANDICAP2_0_, runner1_.SELECTION_ID as SELECTION4_2_0_, runner1_.MARKET_ID as MARKET5_2_0_, selection2_.SELECTION_ID as SELECTION1_3_1_, selection2_.NAME as NAME3_1_, market3_.MARKET_ID as MARKET1_1_2_, market3_.NAME as NAME1_2_, market3_.MARKET_TYPE as MARKET3_1_2_, market3_.EVENT_TYPE as EVENT4_1_2_, market3_.PARENT_EVENT_ID as PARENT5_1_2_, marketsnap4_.SNAPSHOT_ID as SNAPSHOT1_4_3_, marketsnap4_.SEQUENCE as SEQUENCE4_3_, marketsnap4_.SNAPSHOT_DATE as SNAPSHOT3_4_3_, marketsnap4_.MARKET_ID as MARKET4_4_3_, marketsnap4_.CLOSE_DATE as CLOSE5_4_3_, marketsnap4_.TOTAL_MATCHED_SIZE as TOTAL6_4_3_, market5_.MARKET_ID as MARKET1_1_4_, market5_.NAME as NAME1_4_, market5_.MARKET_TYPE as MARKET3_1_4_, market5_.EVENT_TYPE as EVENT4_1_4_, market5_.PARENT_EVENT_ID as PARENT5_1_4_ from TBL_RUNNER_SNAPSHOTS runnersnap0_ inner join TBL_RUNNERS runner1_ on runnersnap0_.RUNNER_ID=runner1_.RUNNER_ID left outer join TBL_SELECTIONS selection2_ on runner1_.SELECTION_ID=selection2_.SELECTION_ID left outer join TBL_MARKETS market3_ on runner1_.MARKET_ID=market3_.MARKET_ID inner join TBL_MARKET_SNAPSHOTS marketsnap4_ on runnersnap0_.MARKET_SNAPSHOT_ID=marketsnap4_.SNAPSHOT_ID left outer join TBL_MARKETS market5_ on marketsnap4_.MARKET_ID=market5_.MARKET_ID where runnersnap0_.RUNNER_SNAPSHOT_ID=?
17:34:05,406 DEBUG SQL:346 - select marketsnap0_.SNAPSHOT_ID as SNAPSHOT1_4_4_, marketsnap0_.SEQUENCE as SEQUENCE4_4_, marketsnap0_.SNAPSHOT_DATE as SNAPSHOT3_4_4_, marketsnap0_.MARKET_ID as MARKET4_4_4_, marketsnap0_.CLOSE_DATE as CLOSE5_4_4_, marketsnap0_.TOTAL_MATCHED_SIZE as TOTAL6_4_4_, market1_.MARKET_ID as MARKET1_1_0_, market1_.NAME as NAME1_0_, market1_.MARKET_TYPE as MARKET3_1_0_, market1_.EVENT_TYPE as EVENT4_1_0_, market1_.PARENT_EVENT_ID as PARENT5_1_0_, event2_.EVENT_ID as EVENT1_0_1_, event2_.NAME as NAME0_1_, event2_.EVENT_TYPE as EVENT3_0_1_, event2_.PARENT_EVENT_ID as PARENT4_0_1_, runners3_.MARKET_ID as MARKET5_6_, runners3_.RUNNER_ID as RUNNER1_6_, runners3_.RUNNER_ID as RUNNER1_2_2_, runners3_.ASIAN_LINE_ID as ASIAN2_2_2_, runners3_.HANDICAP as HANDICAP2_2_, runners3_.SELECTION_ID as SELECTION4_2_2_, runners3_.MARKET_ID as MARKET5_2_2_, runnersnap4_.RUNNER_ID as RUNNER2_7_, runnersnap4_.RUNNER_SNAPSHOT_ID as RUNNER1_7_, runnersnap4_.RUNNER_SNAPSHOT_ID as RUNNER1_5_3_, runnersnap4_.RUNNER_ID as RUNNER2_5_3_, runnersnap4_.MARKET_SNAPSHOT_ID as MARKET3_5_3_, runnersnap4_.BACK_PRICE_1 as BACK4_5_3_, runnersnap4_.BACK_SIZE_1 as BACK5_5_3_, runnersnap4_.BACK_PRICE_2 as BACK6_5_3_, runnersnap4_.BACK_SIZE_2 as BACK7_5_3_, runnersnap4_.BACK_PRICE_3 as BACK8_5_3_, runnersnap4_.BACK_SIZE_3 as BACK9_5_3_, runnersnap4_.LAY_PRICE_1 as LAY10_5_3_, runnersnap4_.LAY_SIZE_1 as LAY11_5_3_, runnersnap4_.LAY_PRICE_2 as LAY12_5_3_, runnersnap4_.LAY_SIZE_2 as LAY13_5_3_, runnersnap4_.LAY_PRICE_3 as LAY14_5_3_, runnersnap4_.LAY_SIZE_3 as LAY15_5_3_ from TBL_MARKET_SNAPSHOTS marketsnap0_ inner join TBL_MARKETS market1_ on marketsnap0_.MARKET_ID=market1_.MARKET_ID left outer join TBL_EVENTS event2_ on market1_.PARENT_EVENT_ID=event2_.EVENT_ID left outer join TBL_RUNNERS runners3_ on market1_.MARKET_ID=runners3_.MARKET_ID left outer join TBL_RUNNER_SNAPSHOTS runnersnap4_ on marketsnap0_.SNAPSHOT_ID=runnersnap4_.RUNNER_ID where marketsnap0_.SNAPSHOT_ID=?
17:34:05,453 DEBUG SQL:346 - select runnersnap0_.RUNNER_SNAPSHOT_ID as RUNNER1_5_5_, runnersnap0_.RUNNER_ID as RUNNER2_5_5_, runnersnap0_.MARKET_SNAPSHOT_ID as MARKET3_5_5_, runnersnap0_.BACK_PRICE_1 as BACK4_5_5_, runnersnap0_.BACK_SIZE_1 as BACK5_5_5_, runnersnap0_.BACK_PRICE_2 as BACK6_5_5_, runnersnap0_.BACK_SIZE_2 as BACK7_5_5_, runnersnap0_.BACK_PRICE_3 as BACK8_5_5_, runnersnap0_.BACK_SIZE_3 as BACK9_5_5_, runnersnap0_.LAY_PRICE_1 as LAY10_5_5_, runnersnap0_.LAY_SIZE_1 as LAY11_5_5_, runnersnap0_.LAY_PRICE_2 as LAY12_5_5_, runnersnap0_.LAY_SIZE_2 as LAY13_5_5_, runnersnap0_.LAY_PRICE_3 as LAY14_5_5_, runnersnap0_.LAY_SIZE_3 as LAY15_5_5_, runner1_.RUNNER_ID as RUNNER1_2_0_, runner1_.ASIAN_LINE_ID as ASIAN2_2_0_, runner1_.HANDICAP as HANDICAP2_0_, runner1_.SELECTION_ID as SELECTION4_2_0_, runner1_.MARKET_ID as MARKET5_2_0_, selection2_.SELECTION_ID as SELECTION1_3_1_, selection2_.NAME as NAME3_1_, market3_.MARKET_ID as MARKET1_1_2_, market3_.NAME as NAME1_2_, market3_.MARKET_TYPE as MARKET3_1_2_, market3_.EVENT_TYPE as EVENT4_1_2_, market3_.PARENT_EVENT_ID as PARENT5_1_2_, marketsnap4_.SNAPSHOT_ID as SNAPSHOT1_4_3_, marketsnap4_.SEQUENCE as SEQUENCE4_3_, marketsnap4_.SNAPSHOT_DATE as SNAPSHOT3_4_3_, marketsnap4_.MARKET_ID as MARKET4_4_3_, marketsnap4_.CLOSE_DATE as CLOSE5_4_3_, marketsnap4_.TOTAL_MATCHED_SIZE as TOTAL6_4_3_, market5_.MARKET_ID as MARKET1_1_4_, market5_.NAME as NAME1_4_, market5_.MARKET_TYPE as MARKET3_1_4_, market5_.EVENT_TYPE as EVENT4_1_4_, market5_.PARENT_EVENT_ID as PARENT5_1_4_ from TBL_RUNNER_SNAPSHOTS runnersnap0_ inner join TBL_RUNNERS runner1_ on runnersnap0_.RUNNER_ID=runner1_.RUNNER_ID left outer join TBL_SELECTIONS selection2_ on runner1_.SELECTION_ID=selection2_.SELECTION_ID left outer join TBL_MARKETS market3_ on runner1_.MARKET_ID=market3_.MARKET_ID inner join TBL_MARKET_SNAPSHOTS marketsnap4_ on runnersnap0_.MARKET_SNAPSHOT_ID=marketsnap4_.SNAPSHOT_ID left outer join TBL_MARKETS market5_ on marketsnap4_.MARKET_ID=market5_.MARKET_ID where runnersnap0_.RUNNER_SNAPSHOT_ID=?
17:34:05,485 DEBUG SQL:346 - select runner0_.RUNNER_ID as RUNNER1_2_5_, runner0_.ASIAN_LINE_ID as ASIAN2_2_5_, runner0_.HANDICAP as HANDICAP2_5_, runner0_.SELECTION_ID as SELECTION4_2_5_, runner0_.MARKET_ID as MARKET5_2_5_, selection1_.SELECTION_ID as SELECTION1_3_0_, selection1_.NAME as NAME3_0_, market2_.MARKET_ID as MARKET1_1_1_, market2_.NAME as NAME1_1_, market2_.MARKET_TYPE as MARKET3_1_1_, market2_.EVENT_TYPE as EVENT4_1_1_, market2_.PARENT_EVENT_ID as PARENT5_1_1_, event3_.EVENT_ID as EVENT1_0_2_, event3_.NAME as NAME0_2_, event3_.EVENT_TYPE as EVENT3_0_2_, event3_.PARENT_EVENT_ID as PARENT4_0_2_, marketsnap4_.MARKET_ID as MARKET4_7_, marketsnap4_.SNAPSHOT_ID as SNAPSHOT1_7_, marketsnap4_.SNAPSHOT_ID as SNAPSHOT1_4_3_, marketsnap4_.SEQUENCE as SEQUENCE4_3_, marketsnap4_.SNAPSHOT_DATE as SNAPSHOT3_4_3_, marketsnap4_.MARKET_ID as MARKET4_4_3_, marketsnap4_.CLOSE_DATE as CLOSE5_4_3_, marketsnap4_.TOTAL_MATCHED_SIZE as TOTAL6_4_3_, runnersnap5_.RUNNER_ID as RUNNER2_8_, runnersnap5_.RUNNER_SNAPSHOT_ID as RUNNER1_8_, runnersnap5_.RUNNER_SNAPSHOT_ID as RUNNER1_5_4_, runnersnap5_.RUNNER_ID as RUNNER2_5_4_, runnersnap5_.MARKET_SNAPSHOT_ID as MARKET3_5_4_, runnersnap5_.BACK_PRICE_1 as BACK4_5_4_, runnersnap5_.BACK_SIZE_1 as BACK5_5_4_, runnersnap5_.BACK_PRICE_2 as BACK6_5_4_, runnersnap5_.BACK_SIZE_2 as BACK7_5_4_, runnersnap5_.BACK_PRICE_3 as BACK8_5_4_, runnersnap5_.BACK_SIZE_3 as BACK9_5_4_, runnersnap5_.LAY_PRICE_1 as LAY10_5_4_, runnersnap5_.LAY_SIZE_1 as LAY11_5_4_, runnersnap5_.LAY_PRICE_2 as LAY12_5_4_, runnersnap5_.LAY_SIZE_2 as LAY13_5_4_, runnersnap5_.LAY_PRICE_3 as LAY14_5_4_, runnersnap5_.LAY_SIZE_3 as LAY15_5_4_ from TBL_RUNNERS runner0_ inner join TBL_SELECTIONS selection1_ on runner0_.SELECTION_ID=selection1_.SELECTION_ID inner join TBL_MARKETS market2_ on runner0_.MARKET_ID=market2_.MARKET_ID left outer join TBL_EVENTS event3_ on market2_.PARENT_EVENT_ID=event3_.EVENT_ID left outer join TBL_MARKET_SNAPSHOTS marketsnap4_ on market2_.MARKET_ID=marketsnap4_.MARKET_ID left outer join TBL_RUNNER_SNAPSHOTS runnersnap5_ on runner0_.RUNNER_ID=runnersnap5_.RUNNER_ID where runner0_.RUNNER_ID=?
17:34:05,500 DEBUG SQL:346 - select selection0_.SELECTION_ID as SELECTION1_3_0_, selection0_.NAME as NAME3_0_ from TBL_SELECTIONS selection0_ where selection0_.SELECTION_ID=?
Debug level Hibernate log excerpt:
17:45:35,254 DEBUG JDBCTransaction:54 - begin
17:45:35,254 DEBUG ConnectionManager:415 - opening JDBC connection
17:45:35,254 DEBUG JDBCTransaction:59 - current autocommit status: false
17:45:35,270 DEBUG JDBCContext:194 - after transaction begin
17:45:35,270 DEBUG IdentifierValue:77 - id unsaved-value strategy UNDEFINED
17:45:35,270 DEBUG NonstrictReadWriteCache:39 - Cache lookup: com.takame.gelaca.model.base.Event#5693625
17:45:35,285 DEBUG EhCache:104 - key: com.takame.gelaca.model.base.Event#5693625
17:45:35,285 DEBUG EhCache:113 - Element for com.takame.gelaca.model.base.Event#5693625 is null
17:45:35,285 DEBUG NonstrictReadWriteCache:46 - Cache miss
17:45:35,285 DEBUG AbstractSaveEventListener:471 - detached instance of: com.takame.gelaca.model.base.Event
17:45:35,285 DEBUG DefaultMergeEventListener:183 - merging detached instance
17:45:35,301 DEBUG DefaultLoadEventListener:153 - loading entity: [com.takame.gelaca.model.base.Event#5693625]
17:45:35,301 DEBUG DefaultLoadEventListener:304 - attempting to resolve: [com.takame.gelaca.model.base.Event#5693625]
17:45:35,301 DEBUG NonstrictReadWriteCache:39 - Cache lookup: com.takame.gelaca.model.base.Event#5693625
17:45:35,301 DEBUG EhCache:104 - key: com.takame.gelaca.model.base.Event#5693625
17:45:35,301 DEBUG EhCache:113 - Element for com.takame.gelaca.model.base.Event#5693625 is null
17:45:35,301 DEBUG NonstrictReadWriteCache:46 - Cache miss
17:45:35,317 DEBUG DefaultLoadEventListener:340 - object not resolved in any cache: [com.takame.gelaca.model.base.Event#5693625]
17:45:35,317 DEBUG AbstractEntityPersister:2723 - Fetching entity: [com.takame.gelaca.model.base.Event#5693625]
17:45:35,317 DEBUG Loader:1777 - loading entity: [com.takame.gelaca.model.base.Event#5693625]
17:45:35,317 DEBUG AbstractBatcher:311 - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
17:45:35,317 DEBUG SQL:346 - select event0_.EVENT_ID as EVENT1_0_2_, event0_.NAME as NAME0_2_, event0_.EVENT_TYPE as EVENT3_0_2_, event0_.PARENT_EVENT_ID as PARENT4_0_2_, event1_.EVENT_ID as EVENT1_0_0_, event1_.NAME as NAME0_0_, event1_.EVENT_TYPE as EVENT3_0_0_, event1_.PARENT_EVENT_ID as PARENT4_0_0_, markets2_.PARENT_EVENT_ID as PARENT5_4_, markets2_.MARKET_ID as MARKET1_4_, markets2_.MARKET_ID as MARKET1_1_1_, markets2_.NAME as NAME1_1_, markets2_.MARKET_TYPE as MARKET3_1_1_, markets2_.EVENT_TYPE as EVENT4_1_1_, markets2_.PARENT_EVENT_ID as PARENT5_1_1_ from TBL_EVENTS event0_ left outer join TBL_EVENTS event1_ on event0_.PARENT_EVENT_ID=event1_.EVENT_ID left outer join TBL_MARKETS markets2_ on event1_.EVENT_ID=markets2_.PARENT_EVENT_ID where event0_.EVENT_ID=?
17:45:35,317 DEBUG AbstractBatcher:424 - preparing statement
17:45:35,332 DEBUG StringType:80 - binding '5693625' to parameter: 1
17:45:35,348 DEBUG AbstractBatcher:327 - about to open ResultSet (open ResultSets: 0, globally: 0)
17:45:35,348 DEBUG Loader:682 - processing result set
17:45:35,348 DEBUG Loader:709 - done processing result set (0 rows)
17:45:35,348 DEBUG AbstractBatcher:334 - about to close ResultSet (open ResultSets: 1, globally: 1)
17:45:35,348 DEBUG AbstractBatcher:319 - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
17:45:35,348 DEBUG AbstractBatcher:470 - closing statement
17:45:35,364 DEBUG Loader:839 - total objects hydrated: 0
17:45:35,364 DEBUG CollectionLoadContext:262 - 0 collections were found in result set for role: com.takame.gelaca.model.base.Event.markets
17:45:35,364 DEBUG CollectionLoadContext:272 - 0 collections initialized for role: com.takame.gelaca.model.base.Event.markets
17:45:35,364 DEBUG StatefulPersistenceContext:748 - initializing non-lazy collections
17:45:35,364 DEBUG Loader:1808 - done entity load
17:45:35,364 DEBUG DefaultMergeEventListener:140 - merging transient instance
17:45:35,379 DEBUG Cascade:237 - processing cascade ACTION_MERGE for: com.takame.gelaca.model.base.Event
17:45:35,379 DEBUG CascadingAction:155 - cascading to merge: com.takame.gelaca.model.base.Event
17:45:35,379 DEBUG IdentifierValue:77 - id unsaved-value strategy UNDEFINED
17:45:35,379 DEBUG NonstrictReadWriteCache:39 - Cache lookup: com.takame.gelaca.model.base.Event#5693624
17:45:35,379 DEBUG EhCache:104 - key: com.takame.gelaca.model.base.Event#5693624
17:45:35,395 DEBUG EhCache:113 - Element for com.takame.gelaca.model.base.Event#5693624 is null
17:45:35,395 DEBUG NonstrictReadWriteCache:46 - Cache miss
17:45:35,395 DEBUG AbstractSaveEventListener:471 - detached instance of: com.takame.gelaca.model.base.Event
17:45:35,395 DEBUG DefaultMergeEventListener:183 - merging detached instance
17:45:35,395 DEBUG DefaultLoadEventListener:153 - loading entity: [com.takame.gelaca.model.base.Event#5693624]
17:45:35,395 DEBUG DefaultLoadEventListener:304 - attempting to resolve: [com.takame.gelaca.model.base.Event#5693624]
17:45:35,395 DEBUG NonstrictReadWriteCache:39 - Cache lookup: com.takame.gelaca.model.base.Event#5693624
17:45:35,395 DEBUG EhCache:104 - key: com.takame.gelaca.model.base.Event#5693624
17:45:35,395 DEBUG EhCache:113 - Element for com.takame.gelaca.model.base.Event#5693624 is null
17:45:35,410 DEBUG NonstrictReadWriteCache:46 - Cache miss
17:45:35,410 DEBUG DefaultLoadEventListener:340 - object not resolved in any cache: [com.takame.gelaca.model.base.Event#5693624]
17:45:35,410 DEBUG AbstractEntityPersister:2723 - Fetching entity: [com.takame.gelaca.model.base.Event#5693624]
17:45:35,410 DEBUG Loader:1777 - loading entity: [com.takame.gelaca.model.base.Event#5693624]
17:45:35,410 DEBUG AbstractBatcher:311 - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
17:45:35,410 DEBUG SQL:346 - select event0_.EVENT_ID as EVENT1_0_2_, event0_.NAME as NAME0_2_, event0_.EVENT_TYPE as EVENT3_0_2_, event0_.PARENT_EVENT_ID as PARENT4_0_2_, event1_.EVENT_ID as EVENT1_0_0_, event1_.NAME as NAME0_0_, event1_.EVENT_TYPE as EVENT3_0_0_, event1_.PARENT_EVENT_ID as PARENT4_0_0_, markets2_.PARENT_EVENT_ID as PARENT5_4_, markets2_.MARKET_ID as MARKET1_4_, markets2_.MARKET_ID as MARKET1_1_1_, markets2_.NAME as NAME1_1_, markets2_.MARKET_TYPE as MARKET3_1_1_, markets2_.EVENT_TYPE as EVENT4_1_1_, markets2_.PARENT_EVENT_ID as PARENT5_1_1_ from TBL_EVENTS event0_ left outer join TBL_EVENTS event1_ on event0_.PARENT_EVENT_ID=event1_.EVENT_ID left outer join TBL_MARKETS markets2_ on event1_.EVENT_ID=markets2_.PARENT_EVENT_ID where event0_.EVENT_ID=?
17:45:35,426 DEBUG AbstractBatcher:424 - preparing statement
17:45:35,426 DEBUG StringType:80 - binding '5693624' to parameter: 1
17:45:35,442 DEBUG AbstractBatcher:327 - about to open ResultSet (open ResultSets: 0, globally: 0)
17:45:35,442 DEBUG Loader:682 - processing result set
17:45:35,442 DEBUG Loader:709 - done processing result set (0 rows)
17:45:35,442 DEBUG AbstractBatcher:334 - about to close ResultSet (open ResultSets: 1, globally: 1)
17:45:35,442 DEBUG AbstractBatcher:319 - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
17:45:35,457 DEBUG AbstractBatcher:470 - closing statement
17:45:35,457 DEBUG Loader:839 - total objects hydrated: 0
17:45:35,457 DEBUG CollectionLoadContext:262 - 0 collections were found in result set for role: com.takame.gelaca.model.base.Event.markets
17:45:35,457 DEBUG CollectionLoadContext:272 - 0 collections initialized for role: com.takame.gelaca.model.base.Event.markets
17:45:35,457 DEBUG StatefulPersistenceContext:748 - initializing non-lazy collections
17:45:35,457 DEBUG Loader:1808 - done entity load
17:45:35,457 DEBUG DefaultMergeEventListener:140 - merging transient instance
17:45:35,457 DEBUG Cascade:237 - processing cascade ACTION_MERGE for: com.takame.gelaca.model.base.Event
17:45:35,457 DEBUG CascadingAction:155 - cascading to merge: com.takame.gelaca.model.base.Event
17:45:35,457 DEBUG IdentifierValue:77 - id unsaved-value strategy UNDEFINED
17:45:35,457 DEBUG NonstrictReadWriteCache:39 - Cache lookup: com.takame.gelaca.model.base.Event#5693583
17:45:35,473 DEBUG EhCache:104 - key: com.takame.gelaca.model.base.Event#5693583
17:45:35,473 DEBUG EhCache:113 - Element for com.takame.gelaca.model.base.Event#5693583 is null
17:45:35,473 DEBUG NonstrictReadWriteCache:46 - Cache miss
17:45:35,473 DEBUG AbstractSaveEventListener:471 - detached instance of: com.takame.gelaca.model.base.Event
17:45:35,473 DEBUG DefaultMergeEventListener:183 - merging detached instance
17:45:35,473 DEBUG DefaultLoadEventListener:153 - loading entity: [com.takame.gelaca.model.base.Event#5693583]
17:45:35,473 DEBUG DefaultLoadEventListener:304 - attempting to resolve: [com.takame.gelaca.model.base.Event#5693583]
17:45:35,473 DEBUG NonstrictReadWriteCache:39 - Cache lookup: com.takame.gelaca.model.base.Event#5693583
17:45:35,473 DEBUG EhCache:104 - key: com.takame.gelaca.model.base.Event#5693583
17:45:35,473 DEBUG EhCache:113 - Element for com.takame.gelaca.model.base.Event#5693583 is null
17:45:35,489 DEBUG NonstrictReadWriteCache:46 - Cache miss
17:45:35,489 DEBUG DefaultLoadEventListener:340 - object not resolved in any cache: [com.takame.gelaca.model.base.Event#5693583]
17:45:35,489 DEBUG AbstractEntityPersister:2723 - Fetching entity: [com.takame.gelaca.model.base.Event#5693583]
17:45:35,489 DEBUG Loader:1777 - loading entity: [com.takame.gelaca.model.base.Event#5693583]
17:45:35,489 DEBUG AbstractBatcher:311 - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
17:45:35,489 DEBUG SQL:346 - select event0_.EVENT_ID as EVENT1_0_2_, event0_.NAME as NAME0_2_, event0_.EVENT_TYPE as EVENT3_0_2_, event0_.PARENT_EVENT_ID as PARENT4_0_2_, event1_.EVENT_ID as EVENT1_0_0_, event1_.NAME as NAME0_0_, event1_.EVENT_TYPE as EVENT3_0_0_, event1_.PARENT_EVENT_ID as PARENT4_0_0_, markets2_.PARENT_EVENT_ID as PARENT5_4_, markets2_.MARKET_ID as MARKET1_4_, markets2_.MARKET_ID as MARKET1_1_1_, markets2_.NAME as NAME1_1_, markets2_.MARKET_TYPE as MARKET3_1_1_, markets2_.EVENT_TYPE as EVENT4_1_1_, markets2_.PARENT_EVENT_ID as PARENT5_1_1_ from TBL_EVENTS event0_ left outer join TBL_EVENTS event1_ on event0_.PARENT_EVENT_ID=event1_.EVENT_ID left outer join TBL_MARKETS markets2_ on event1_.EVENT_ID=markets2_.PARENT_EVENT_ID where event0_.EVENT_ID=?
17:45:35,504 DEBUG AbstractBatcher:424 - preparing statement
17:45:35,504 DEBUG StringType:80 - binding '5693583' to parameter: 1
17:45:35,520 DEBUG AbstractBatcher:327 - about to open ResultSet (open ResultSets: 0, globally: 0)
17:45:35,520 DEBUG Loader:682 - processing result set
17:45:35,520 DEBUG Loader:709 - done processing result set (0 rows)
17:45:35,520 DEBUG AbstractBatcher:334 - about to close ResultSet (open ResultSets: 1, globally: 1)
17:45:35,520 DEBUG AbstractBatcher:319 - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
17:45:35,535 DEBUG AbstractBatcher:470 - closing statement
17:45:35,535 DEBUG Loader:839 - total objects hydrated: 0
17:45:35,535 DEBUG CollectionLoadContext:262 - 0 collections were found in result set for role: com.takame.gelaca.model.base.Event.markets
17:45:35,535 DEBUG CollectionLoadContext:272 - 0 collections initialized for role: com.takame.gelaca.model.base.Event.markets
17:45:35,535 DEBUG StatefulPersistenceContext:748 - initializing non-lazy collections
17:45:35,535 DEBUG Loader:1808 - done entity load
17:45:35,535 DEBUG DefaultMergeEventListener:140 - merging transient instance
17:45:35,551 DEBUG Cascade:237 - processing cascade ACTION_MERGE for: com.takame.gelaca.model.base.Event
17:45:35,551 DEBUG CascadingAction:155 - cascading to merge: com.takame.gelaca.model.base.Event
17:45:35,551 DEBUG IdentifierValue:77 - id unsaved-value strategy UNDEFINED
17:45:35,551 DEBUG NonstrictReadWriteCache:39 - Cache lookup: com.takame.gelaca.model.base.Event#1042900
17:45:35,551 DEBUG EhCache:104 - key: com.takame.gelaca.model.base.Event#1042900
17:45:35,567 DEBUG EhCache:113 - Element for com.takame.gelaca.model.base.Event#1042900 is null
17:45:35,567 DEBUG NonstrictReadWriteCache:46 - Cache miss
17:45:35,567 DEBUG AbstractSaveEventListener:471 - detached instance of: com.takame.gelaca.model.base.Event
17:45:35,567 DEBUG DefaultMergeEventListener:183 - merging detached instance
17:45:35,567 DEBUG DefaultLoadEventListener:153 - loading entity: [com.takame.gelaca.model.base.Event#1042900]
17:45:35,567 DEBUG DefaultLoadEventListener:304 - attempting to resolve: [com.takame.gelaca.model.base.Event#1042900]
17:45:35,567 DEBUG NonstrictReadWriteCache:39 - Cache lookup: com.takame.gelaca.model.base.Event#1042900
17:45:35,567 DEBUG EhCache:104 - key: com.takame.gelaca.model.base.Event#1042900
17:45:35,582 DEBUG EhCache:113 - Element for com.takame.gelaca.model.base.Event#1042900 is null
17:45:35,582 DEBUG NonstrictReadWriteCache:46 - Cache miss
17:45:35,582 DEBUG DefaultLoadEventListener:340 - object not resolved in any cache: [com.takame.gelaca.model.base.Event#1042900]
17:45:35,582 DEBUG AbstractEntityPersister:2723 - Fetching entity: [com.takame.gelaca.model.base.Event#1042900]
17:45:35,582 DEBUG Loader:1777 - loading entity: [com.takame.gelaca.model.base.Event#1042900]
17:45:35,582 DEBUG AbstractBatcher:311 - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
17:45:35,598 DEBUG SQL:346 - select event0_.EVENT_ID as EVENT1_0_2_, event0_.NAME as NAME0_2_, event0_.EVENT_TYPE as EVENT3_0_2_, event0_.PARENT_EVENT_ID as PARENT4_0_2_, event1_.EVENT_ID as EVENT1_0_0_, event1_.NAME as NAME0_0_, event1_.EVENT_TYPE as EVENT3_0_0_, event1_.PARENT_EVENT_ID as PARENT4_0_0_, markets2_.PARENT_EVENT_ID as PARENT5_4_, markets2_.MARKET_ID as MARKET1_4_, markets2_.MARKET_ID as MARKET1_1_1_, markets2_.NAME as NAME1_1_, markets2_.MARKET_TYPE as MARKET3_1_1_, markets2_.EVENT_TYPE as EVENT4_1_1_, markets2_.PARENT_EVENT_ID as PARENT5_1_1_ from TBL_EVENTS event0_ left outer join TBL_EVENTS event1_ on event0_.PARENT_EVENT_ID=event1_.EVENT_ID left outer join TBL_MARKETS markets2_ on event1_.EVENT_ID=markets2_.PARENT_EVENT_ID where event0_.EVENT_ID=?
17:45:35,598 DEBUG AbstractBatcher:424 - preparing statement
17:45:35,598 DEBUG StringType:80 - binding '1042900' to parameter: 1
17:45:35,598 DEBUG AbstractBatcher:327 - about to open ResultSet (open ResultSets: 0, globally: 0)
17:45:35,598 DEBUG Loader:682 - processing result set
17:45:35,614 DEBUG Loader:709 - done processing result set (0 rows)
17:45:35,614 DEBUG AbstractBatcher:334 - about to close ResultSet (open ResultSets: 1, globally: 1)
17:45:35,614 DEBUG AbstractBatcher:319 - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
17:45:35,614 DEBUG AbstractBatcher:470 - closing statement
17:45:35,629 DEBUG Loader:839 - total objects hydrated: 0
17:45:35,629 DEBUG CollectionLoadContext:262 - 0 collections were found in result set for role: com.takame.gelaca.model.base.Event.markets
17:45:35,629 DEBUG CollectionLoadContext:272 - 0 collections initialized for role: com.takame.gelaca.model.base.Event.markets
17:45:35,660 DEBUG StatefulPersistenceContext:748 - initializing non-lazy collections
17:45:35,660 DEBUG Loader:1808 - done entity load
17:45:35,660 DEBUG DefaultMergeEventListener:140 - merging transient instance
17:45:35,660 DEBUG Cascade:237 - processing cascade ACTION_MERGE for: com.takame.gelaca.model.base.Event
17:45:35,676 DEBUG CascadingAction:155 - cascading to merge: com.takame.gelaca.model.base.Event
17:45:35,676 DEBUG IdentifierValue:77 - id unsaved-value strategy UNDEFINED
17:45:35,676 DEBUG NonstrictReadWriteCache:39 - Cache lookup: com.takame.gelaca.model.base.Event#7522
17:45:35,692 DEBUG EhCache:104 - key: com.takame.gelaca.model.base.Event#7522
17:45:35,707 DEBUG EhCache:113 - Element for com.takame.gelaca.model.base.Event#7522 is null
17:45:35,707 DEBUG NonstrictReadWriteCache:46 - Cache miss
17:45:35,707 DEBUG AbstractSaveEventListener:471 - detached instance of: com.takame.gelaca.model.base.Event
17:45:35,707 DEBUG DefaultMergeEventListener:183 - merging detached instance
17:45:35,707 DEBUG DefaultLoadEventListener:153 - loading entity: [com.takame.gelaca.model.base.Event#7522]
17:45:35,707 DEBUG DefaultLoadEventListener:304 - attempting to resolve: [com.takame.gelaca.model.base.Event#7522]
17:45:35,723 DEBUG NonstrictReadWriteCache:39 - Cache lookup: com.takame.gelaca.model.base.Event#7522
17:45:35,723 DEBUG EhCache:104 - key: com.takame.gelaca.model.base.Event#7522
17:45:35,723 DEBUG EhCache:113 - Element for com.takame.gelaca.model.base.Event#7522 is null
17:45:35,723 DEBUG NonstrictReadWriteCache:46 - Cache miss
17:45:35,723 DEBUG DefaultLoadEventListener:340 - object not resolved in any cache: [com.takame.gelaca.model.base.Event#7522]
17:45:35,739 DEBUG AbstractEntityPersister:2723 - Fetching entity: [com.takame.gelaca.model.base.Event#7522]
17:45:35,739 DEBUG Loader:1777 - loading entity: [com.takame.gelaca.model.base.Event#7522]
17:45:35,739 DEBUG AbstractBatcher:311 - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
17:45:35,739 DEBUG SQL:346 - select event0_.EVENT_ID as EVENT1_0_2_, event0_.NAME as NAME0_2_, event0_.EVENT_TYPE as EVENT3_0_2_, event0_.PARENT_EVENT_ID as PARENT4_0_2_, event1_.EVENT_ID as EVENT1_0_0_, event1_.NAME as NAME0_0_, event1_.EVENT_TYPE as EVENT3_0_0_, event1_.PARENT_EVENT_ID as PARENT4_0_0_, markets2_.PARENT_EVENT_ID as PARENT5_4_, markets2_.MARKET_ID as MARKET1_4_, markets2_.MARKET_ID as MARKET1_1_1_, markets2_.NAME as NAME1_1_, markets2_.MARKET_TYPE as MARKET3_1_1_, markets2_.EVENT_TYPE as EVENT4_1_1_, markets2_.PARENT_EVENT_ID as PARENT5_1_1_ from TBL_EVENTS event0_ left outer join TBL_EVENTS event1_ on event0_.PARENT_EVENT_ID=event1_.EVENT_ID left outer join TBL_MARKETS markets2_ on event1_.EVENT_ID=markets2_.PARENT_EVENT_ID where event0_.EVENT_ID=?
17:45:35,739 DEBUG AbstractBatcher:424 - preparing statement
17:45:35,754 DEBUG StringType:80 - binding '7522' to parameter: 1
17:45:35,754 DEBUG AbstractBatcher:327 - about to open ResultSet (open ResultSets: 0, globally: 0)
17:45:35,754 DEBUG Loader:682 - processing result set
17:45:35,754 DEBUG Loader:709 - done processing result set (0 rows)
17:45:35,754 DEBUG AbstractBatcher:334 - about to close ResultSet (open ResultSets: 1, globally: 1)
17:45:35,770 DEBUG AbstractBatcher:319 - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
17:45:35,770 DEBUG AbstractBatcher:470 - closing statement
17:45:35,770 DEBUG Loader:839 - total objects hydrated: 0
17:45:35,770 DEBUG CollectionLoadContext:262 - 0 collections were found in result set for role: com.takame.gelaca.model.base.Event.markets
17:45:35,770 DEBUG CollectionLoadContext:272 - 0 collections initialized for role: com.takame.gelaca.model.base.Event.markets
17:45:35,770 DEBUG StatefulPersistenceContext:748 - initializing non-lazy collections
17:45:35,785 DEBUG Loader:1808 - done entity load
17:45:35,785 DEBUG DefaultMergeEventListener:140 - merging transient instance
17:45:35,785 DEBUG Cascade:237 - processing cascade ACTION_MERGE for: com.takame.gelaca.model.base.Event
17:45:35,785 DEBUG Cascade:259 - done processing cascade ACTION_MERGE for: com.takame.gelaca.model.base.Event
17:45:35,785 DEBUG AbstractSaveEventListener:106 - generated identifier: 7522, using strategy: org.hibernate.id.Assigned
17:45:35,785 DEBUG AbstractSaveEventListener:139 - saving [com.takame.gelaca.model.base.Event#7522]
17:45:35,832 DEBUG Cascade:237 - processing cascade ACTION_MERGE for: com.takame.gelaca.model.base.Event
17:45:35,832 DEBUG Cascade:285 - cascade ACTION_MERGE for collection: com.takame.gelaca.model.base.Event.events
17:45:35,832 DEBUG CascadingAction:155 - cascading to merge: com.takame.gelaca.model.base.Event
17:45:35,848 DEBUG IdentifierValue:77 - id unsaved-value strategy UNDEFINED
17:45:35,848 DEBUG NonstrictReadWriteCache:39 - Cache lookup: com.takame.gelaca.model.base.Event#2902868
17:45:35,848 DEBUG EhCache:104 - key: com.takame.gelaca.model.base.Event#2902868
17:45:35,848 DEBUG EhCache:113 - Element for com.takame.gelaca.model.base.Event#2902868 is null
17:45:35,864 DEBUG NonstrictReadWriteCache:46 - Cache miss
17:45:35,864 DEBUG AbstractSaveEventListener:471 - detached instance of: com.takame.gelaca.model.base.Event
17:45:35,864 DEBUG DefaultMergeEventListener:183 - merging detached instance
17:45:35,864 DEBUG DefaultLoadEventListener:153 - loading entity: [com.takame.gelaca.model.base.Event#2902868]
17:45:35,864 DEBUG DefaultLoadEventListener:304 - attempting to resolve: [com.takame.gelaca.model.base.Event#2902868]
17:45:35,879 DEBUG NonstrictReadWriteCache:39 - Cache lookup: com.takame.gelaca.model.base.Event#2902868
17:45:35,879 DEBUG EhCache:104 - key: com.takame.gelaca.model.base.Event#2902868
17:45:35,879 DEBUG EhCache:113 - Element for com.takame.gelaca.model.base.Event#2902868 is null
17:45:35,879 DEBUG NonstrictReadWriteCache:46 - Cache miss
17:45:35,879 DEBUG DefaultLoadEventListener:340 - object not resolved in any cache: [com.takame.gelaca.model.base.Event#2902868]
17:45:35,879 DEBUG AbstractEntityPersister:2723 - Fetching entity: [com.takame.gelaca.model.base.Event#2902868]
17:45:35,895 DEBUG Loader:1777 - loading entity: [com.takame.gelaca.model.base.Event#2902868]
17:45:35,895 DEBUG AbstractBatcher:311 - about to open PreparedStatement (open PreparedStatements: 0, g
|