hibernate-issues

[Hibernate-issues] [Hibernate-JIRA] Created: (HHH-616) replicate() with a bidirectional relationship fails (dom4j)

[<no...@at...>]

Message:

  A new issue has been created in JIRA.

---------------------------------------------------------------------
View the issue:
  http://opensource.atlassian.com/projects/hibernate/browse/HHH-616

Here is an overview of the issue:
---------------------------------------------------------------------
        Key: HHH-616
    Summary: replicate() with a bidirectional relationship fails (dom4j)
       Type: Bug

     Status: Unassigned
   Priority: Major

 Original Estimate: Unknown
 Time Spent: Unknown
  Remaining: Unknown

    Project: Hibernate3
 Components: 
             core
   Versions:
             3.0.5

   Assignee: 
   Reporter: David Tashima

    Created: Tue, 14 Jun 2005 5:19 PM
    Updated: Tue, 14 Jun 2005 5:19 PM
Environment: Hibernate 3.0.5; MySQL 4.1.12

Description:
Here is the original forum post:
http://forum.hibernate.org/viewtopic.php?t=943520

Basically, I am trying to transfer stuff from one DB to another via the Dom4j session. I create an XML document from the source DB and then I am using session.replicate() on the receiving end to instantiate the new objects from that XML document.

It works for simple objects, but when I have a bidirectional reference, it is unable to .replicate() the pair of objects, even if I try to commit() them all in the same transaction.

I have created a simple model to reproduce this.

Mapping document:
<hibernate-mapping
    package="data">
    <class name="Foo"
           table="foo"
           >
        <id name="id"
            node="@id"
            type="string"
            unsaved-value="null"
            column="foo_id" >
            <generator class="uuid" />
        </id>
        <property
            name="prop1"
            column="prop1"
            type="string"
            />
        <many-to-one
            name="bar"
            column="bar_id"
            class="Bar"
            not-null="false"
            embed-xml="false"
            />
        <property
            name="index"
            column="foo_index"
            type="int"
            update="true"
            />
     </class>
    <class name="Bar"
           table="bar"
           >
        <id name="id"
            node="@id"
            type="string"
            unsaved-value="null"
            column="bar_id" >
            <generator class="uuid" />
        </id>
        <list
            name="foos"
            node="foos"
            embed-xml="true"
            inverse="true"
            lazy="false">
            <key column="bar_id"/>
            <list-index column="foo_index"/>
            <one-to-many
                class="Foo"
                embed-xml="false"
                node="foo"
                />
        </list>
    </class>
</hibernate-mapping>


Reconstitution code:
        try
        {
            SAXReader reader = new SAXReader();
            Document doc = reader.read(new File("content.xml"));

            Session session = currentSession();
            Session s = session.getSession(EntityMode.DOM4J);
            Transaction txn = s.beginTransaction();
            {
                List elems = doc.getRootElement().elements();
                Iterator it = elems.iterator();
                while(it.hasNext())
                {
                    Element e = (Element)it.next();
                    log.debug(e.getName());
                    if(e.getName().equals("Foo"))
                        s.replicate("data.Foo",e, ReplicationMode.IGNORE);
                    if(e.getName().equals("Bar"))
                        s.replicate("data.Bar",e, ReplicationMode.IGNORE);
                }
            }

            txn.commit();
        }
        catch(DocumentException e)
        {
            log.error(e);
        } 



Here is the stack trace:
150 [main] ERROR org.hibernate.util.JDBCExceptionReporter - Cannot add or update a child row: a foreign key constraint fails
291 [main] ERROR org.hibernate.event.def.AbstractFlushingEventListener - Could not synchronize database state with session
org.hibernate.exception.ConstraintViolationException: could not insert: [data.Foo]
at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:74)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1869)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:2200)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:46)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:223)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:136)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:274)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:730)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:329)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:86)
at Test.reconstitute(Test.java:69)
at Test.main(Test.java:40)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.intellij.rt.execution.application.AppMain.main(AppMain.java:78)
Caused by: java.sql.SQLException: Cannot add or update a child row: a foreign key constraint fails
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2851)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)
at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1366)
at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:952)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1974)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1897)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1758)
at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1853)
... 17 more
Exception in thread "main" org.hibernate.exception.ConstraintViolationException: could not insert: [data.Foo]
at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:74)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1869)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:2200)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:46)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:223)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:136)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:274)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:730)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:329)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:86)
at Test.reconstitute(Test.java:69)
at Test.main(Test.java:40) 



And finally, here is the XML document I am attempting to reconstitute:
<root>
  <Foo id="402881e4045ce90c01045ce90f950002">
    <prop1>abcd</prop1>
    <bar>402881e4045ce90c01045ce90f770001</bar>
    <index>0</index>
  </Foo>
  <Foo id="402881e4045ce90c01045ce90f9f0003">
    <prop1>456</prop1>
    <bar>402881e4045ce90c01045ce90f770001</bar>
    <index>1</index>
  </Foo>
  <Bar id="402881e4045ce90c01045ce90f770001">
    <foos>
      <foo>402881e4045ce90c01045ce90f950002</foo>
      <foo>402881e4045ce90c01045ce90f9f0003</foo>
    </foos>
  </Bar>
</root>




---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.

If you think it was sent incorrectly contact one of the administrators:
   http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa

If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira

[Hibernate-issues] [Hibernate-JIRA] Commented: (HHH-616) replicate() with a bidirectional relationship fails (dom4j)

[<no...@at...>]

The following comment has been added to this issue:

     Author: Gavin King
    Created: Tue, 14 Jun 2005 5:30 PM
       Body:
so (yawn), attach a runnable test case 
---------------------------------------------------------------------
View this comment:
  http://opensource.atlassian.com/projects/hibernate/browse/HHH-616?page=comments#action_18248

---------------------------------------------------------------------
View the issue:
  http://opensource.atlassian.com/projects/hibernate/browse/HHH-616

Here is an overview of the issue:
---------------------------------------------------------------------
        Key: HHH-616
    Summary: replicate() with a bidirectional relationship fails (dom4j)
       Type: Bug

     Status: Unassigned
   Priority: Major

 Original Estimate: Unknown
 Time Spent: Unknown
  Remaining: Unknown

    Project: Hibernate3
 Components: 
             core
   Versions:
             3.0.5

   Assignee: 
   Reporter: David Tashima

    Created: Tue, 14 Jun 2005 5:19 PM
    Updated: Tue, 14 Jun 2005 5:30 PM
Environment: Hibernate 3.0.5; MySQL 4.1.12

Description:
Here is the original forum post:
http://forum.hibernate.org/viewtopic.php?t=943520

Basically, I am trying to transfer stuff from one DB to another via the Dom4j session. I create an XML document from the source DB and then I am using session.replicate() on the receiving end to instantiate the new objects from that XML document.

It works for simple objects, but when I have a bidirectional reference, it is unable to .replicate() the pair of objects, even if I try to commit() them all in the same transaction.

I have created a simple model to reproduce this.

Mapping document:
<hibernate-mapping
    package="data">
    <class name="Foo"
           table="foo"
           >
        <id name="id"
            node="@id"
            type="string"
            unsaved-value="null"
            column="foo_id" >
            <generator class="uuid" />
        </id>
        <property
            name="prop1"
            column="prop1"
            type="string"
            />
        <many-to-one
            name="bar"
            column="bar_id"
            class="Bar"
            not-null="false"
            embed-xml="false"
            />
        <property
            name="index"
            column="foo_index"
            type="int"
            update="true"
            />
     </class>
    <class name="Bar"
           table="bar"
           >
        <id name="id"
            node="@id"
            type="string"
            unsaved-value="null"
            column="bar_id" >
            <generator class="uuid" />
        </id>
        <list
            name="foos"
            node="foos"
            embed-xml="true"
            inverse="true"
            lazy="false">
            <key column="bar_id"/>
            <list-index column="foo_index"/>
            <one-to-many
                class="Foo"
                embed-xml="false"
                node="foo"
                />
        </list>
    </class>
</hibernate-mapping>


Reconstitution code:
        try
        {
            SAXReader reader = new SAXReader();
            Document doc = reader.read(new File("content.xml"));

            Session session = currentSession();
            Session s = session.getSession(EntityMode.DOM4J);
            Transaction txn = s.beginTransaction();
            {
                List elems = doc.getRootElement().elements();
                Iterator it = elems.iterator();
                while(it.hasNext())
                {
                    Element e = (Element)it.next();
                    log.debug(e.getName());
                    if(e.getName().equals("Foo"))
                        s.replicate("data.Foo",e, ReplicationMode.IGNORE);
                    if(e.getName().equals("Bar"))
                        s.replicate("data.Bar",e, ReplicationMode.IGNORE);
                }
            }

            txn.commit();
        }
        catch(DocumentException e)
        {
            log.error(e);
        } 



Here is the stack trace:
150 [main] ERROR org.hibernate.util.JDBCExceptionReporter - Cannot add or update a child row: a foreign key constraint fails
291 [main] ERROR org.hibernate.event.def.AbstractFlushingEventListener - Could not synchronize database state with session
org.hibernate.exception.ConstraintViolationException: could not insert: [data.Foo]
at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:74)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1869)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:2200)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:46)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:223)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:136)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:274)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:730)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:329)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:86)
at Test.reconstitute(Test.java:69)
at Test.main(Test.java:40)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.intellij.rt.execution.application.AppMain.main(AppMain.java:78)
Caused by: java.sql.SQLException: Cannot add or update a child row: a foreign key constraint fails
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2851)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)
at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1366)
at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:952)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1974)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1897)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1758)
at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1853)
... 17 more
Exception in thread "main" org.hibernate.exception.ConstraintViolationException: could not insert: [data.Foo]
at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:74)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1869)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:2200)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:46)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:223)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:136)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:274)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:730)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:329)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:86)
at Test.reconstitute(Test.java:69)
at Test.main(Test.java:40) 



And finally, here is the XML document I am attempting to reconstitute:
<root>
  <Foo id="402881e4045ce90c01045ce90f950002">
    <prop1>abcd</prop1>
    <bar>402881e4045ce90c01045ce90f770001</bar>
    <index>0</index>
  </Foo>
  <Foo id="402881e4045ce90c01045ce90f9f0003">
    <prop1>456</prop1>
    <bar>402881e4045ce90c01045ce90f770001</bar>
    <index>1</index>
  </Foo>
  <Bar id="402881e4045ce90c01045ce90f770001">
    <foos>
      <foo>402881e4045ce90c01045ce90f950002</foo>
      <foo>402881e4045ce90c01045ce90f9f0003</foo>
    </foos>
  </Bar>
</root>




---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.

If you think it was sent incorrectly contact one of the administrators:
   http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa

If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira

[Hibernate-issues] [Hibernate-JIRA] Updated: (HHH-616) replicate() with a bidirectional relationship fails (dom4j)

[<no...@at...>]

The following issue has been updated:

    Updater: David Tashima (mailto:ta...@sp...)
       Date: Tue, 14 Jun 2005 6:22 PM
    Comment:
Complete test case. Included are all jars used, and build.xml file. (There's an IntelliJ project file, but without my global libraries it probably won't work).
    Changes:
             Attachment changed to test.zip
    ---------------------------------------------------------------------
For a full history of the issue, see:

  http://opensource.atlassian.com/projects/hibernate/browse/HHH-616?page=history

---------------------------------------------------------------------
View the issue:
  http://opensource.atlassian.com/projects/hibernate/browse/HHH-616

Here is an overview of the issue:
---------------------------------------------------------------------
        Key: HHH-616
    Summary: replicate() with a bidirectional relationship fails (dom4j)
       Type: Bug

     Status: Unassigned
   Priority: Major

 Original Estimate: Unknown
 Time Spent: Unknown
  Remaining: Unknown

    Project: Hibernate3
 Components: 
             core
   Versions:
             3.0.5

   Assignee: 
   Reporter: David Tashima

    Created: Tue, 14 Jun 2005 5:19 PM
    Updated: Tue, 14 Jun 2005 6:22 PM
Environment: Hibernate 3.0.5; MySQL 4.1.12

Description:
Here is the original forum post:
http://forum.hibernate.org/viewtopic.php?t=943520

Basically, I am trying to transfer stuff from one DB to another via the Dom4j session. I create an XML document from the source DB and then I am using session.replicate() on the receiving end to instantiate the new objects from that XML document.

It works for simple objects, but when I have a bidirectional reference, it is unable to .replicate() the pair of objects, even if I try to commit() them all in the same transaction.

I have created a simple model to reproduce this.

Mapping document:
<hibernate-mapping
    package="data">
    <class name="Foo"
           table="foo"
           >
        <id name="id"
            node="@id"
            type="string"
            unsaved-value="null"
            column="foo_id" >
            <generator class="uuid" />
        </id>
        <property
            name="prop1"
            column="prop1"
            type="string"
            />
        <many-to-one
            name="bar"
            column="bar_id"
            class="Bar"
            not-null="false"
            embed-xml="false"
            />
        <property
            name="index"
            column="foo_index"
            type="int"
            update="true"
            />
     </class>
    <class name="Bar"
           table="bar"
           >
        <id name="id"
            node="@id"
            type="string"
            unsaved-value="null"
            column="bar_id" >
            <generator class="uuid" />
        </id>
        <list
            name="foos"
            node="foos"
            embed-xml="true"
            inverse="true"
            lazy="false">
            <key column="bar_id"/>
            <list-index column="foo_index"/>
            <one-to-many
                class="Foo"
                embed-xml="false"
                node="foo"
                />
        </list>
    </class>
</hibernate-mapping>


Reconstitution code:
        try
        {
            SAXReader reader = new SAXReader();
            Document doc = reader.read(new File("content.xml"));

            Session session = currentSession();
            Session s = session.getSession(EntityMode.DOM4J);
            Transaction txn = s.beginTransaction();
            {
                List elems = doc.getRootElement().elements();
                Iterator it = elems.iterator();
                while(it.hasNext())
                {
                    Element e = (Element)it.next();
                    log.debug(e.getName());
                    if(e.getName().equals("Foo"))
                        s.replicate("data.Foo",e, ReplicationMode.IGNORE);
                    if(e.getName().equals("Bar"))
                        s.replicate("data.Bar",e, ReplicationMode.IGNORE);
                }
            }

            txn.commit();
        }
        catch(DocumentException e)
        {
            log.error(e);
        } 



Here is the stack trace:
150 [main] ERROR org.hibernate.util.JDBCExceptionReporter - Cannot add or update a child row: a foreign key constraint fails
291 [main] ERROR org.hibernate.event.def.AbstractFlushingEventListener - Could not synchronize database state with session
org.hibernate.exception.ConstraintViolationException: could not insert: [data.Foo]
at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:74)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1869)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:2200)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:46)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:223)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:136)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:274)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:730)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:329)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:86)
at Test.reconstitute(Test.java:69)
at Test.main(Test.java:40)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.intellij.rt.execution.application.AppMain.main(AppMain.java:78)
Caused by: java.sql.SQLException: Cannot add or update a child row: a foreign key constraint fails
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2851)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)
at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1366)
at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:952)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1974)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1897)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1758)
at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1853)
... 17 more
Exception in thread "main" org.hibernate.exception.ConstraintViolationException: could not insert: [data.Foo]
at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:74)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1869)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:2200)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:46)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:223)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:136)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:274)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:730)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:329)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:86)
at Test.reconstitute(Test.java:69)
at Test.main(Test.java:40) 



And finally, here is the XML document I am attempting to reconstitute:
<root>
  <Foo id="402881e4045ce90c01045ce90f950002">
    <prop1>abcd</prop1>
    <bar>402881e4045ce90c01045ce90f770001</bar>
    <index>0</index>
  </Foo>
  <Foo id="402881e4045ce90c01045ce90f9f0003">
    <prop1>456</prop1>
    <bar>402881e4045ce90c01045ce90f770001</bar>
    <index>1</index>
  </Foo>
  <Bar id="402881e4045ce90c01045ce90f770001">
    <foos>
      <foo>402881e4045ce90c01045ce90f950002</foo>
      <foo>402881e4045ce90c01045ce90f9f0003</foo>
    </foos>
  </Bar>
</root>




---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.

If you think it was sent incorrectly contact one of the administrators:
   http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa

If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira

[Hibernate-issues] [Hibernate-JIRA] Assigned: (HHH-616) replicate() with a bidirectional relationship fails (dom4j)

[<no...@at...>]

Message:

   The following issue has been re-assigned.

   Assignee: Gavin King (mailto:ga...@hi...)
---------------------------------------------------------------------
View the issue:
  http://opensource.atlassian.com/projects/hibernate/browse/HHH-616

Here is an overview of the issue:
---------------------------------------------------------------------
        Key: HHH-616
    Summary: replicate() with a bidirectional relationship fails (dom4j)
       Type: Bug

     Status: Open
   Priority: Major

 Original Estimate: Unknown
 Time Spent: Unknown
  Remaining: Unknown

    Project: Hibernate3
 Components: 
             core
   Versions:
             3.0.5

   Assignee: Gavin King
   Reporter: David Tashima

    Created: Tue, 14 Jun 2005 5:19 PM
    Updated: Wed, 15 Jun 2005 2:20 PM
Environment: Hibernate 3.0.5; MySQL 4.1.12

Description:
Here is the original forum post:
http://forum.hibernate.org/viewtopic.php?t=943520

Basically, I am trying to transfer stuff from one DB to another via the Dom4j session. I create an XML document from the source DB and then I am using session.replicate() on the receiving end to instantiate the new objects from that XML document.

It works for simple objects, but when I have a bidirectional reference, it is unable to .replicate() the pair of objects, even if I try to commit() them all in the same transaction.

I have created a simple model to reproduce this.

Mapping document:
<hibernate-mapping
    package="data">
    <class name="Foo"
           table="foo"
           >
        <id name="id"
            node="@id"
            type="string"
            unsaved-value="null"
            column="foo_id" >
            <generator class="uuid" />
        </id>
        <property
            name="prop1"
            column="prop1"
            type="string"
            />
        <many-to-one
            name="bar"
            column="bar_id"
            class="Bar"
            not-null="false"
            embed-xml="false"
            />
        <property
            name="index"
            column="foo_index"
            type="int"
            update="true"
            />
     </class>
    <class name="Bar"
           table="bar"
           >
        <id name="id"
            node="@id"
            type="string"
            unsaved-value="null"
            column="bar_id" >
            <generator class="uuid" />
        </id>
        <list
            name="foos"
            node="foos"
            embed-xml="true"
            inverse="true"
            lazy="false">
            <key column="bar_id"/>
            <list-index column="foo_index"/>
            <one-to-many
                class="Foo"
                embed-xml="false"
                node="foo"
                />
        </list>
    </class>
</hibernate-mapping>


Reconstitution code:
        try
        {
            SAXReader reader = new SAXReader();
            Document doc = reader.read(new File("content.xml"));

            Session session = currentSession();
            Session s = session.getSession(EntityMode.DOM4J);
            Transaction txn = s.beginTransaction();
            {
                List elems = doc.getRootElement().elements();
                Iterator it = elems.iterator();
                while(it.hasNext())
                {
                    Element e = (Element)it.next();
                    log.debug(e.getName());
                    if(e.getName().equals("Foo"))
                        s.replicate("data.Foo",e, ReplicationMode.IGNORE);
                    if(e.getName().equals("Bar"))
                        s.replicate("data.Bar",e, ReplicationMode.IGNORE);
                }
            }

            txn.commit();
        }
        catch(DocumentException e)
        {
            log.error(e);
        } 



Here is the stack trace:
150 [main] ERROR org.hibernate.util.JDBCExceptionReporter - Cannot add or update a child row: a foreign key constraint fails
291 [main] ERROR org.hibernate.event.def.AbstractFlushingEventListener - Could not synchronize database state with session
org.hibernate.exception.ConstraintViolationException: could not insert: [data.Foo]
at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:74)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1869)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:2200)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:46)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:223)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:136)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:274)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:730)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:329)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:86)
at Test.reconstitute(Test.java:69)
at Test.main(Test.java:40)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.intellij.rt.execution.application.AppMain.main(AppMain.java:78)
Caused by: java.sql.SQLException: Cannot add or update a child row: a foreign key constraint fails
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2851)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)
at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1366)
at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:952)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1974)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1897)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1758)
at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1853)
... 17 more
Exception in thread "main" org.hibernate.exception.ConstraintViolationException: could not insert: [data.Foo]
at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:74)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1869)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:2200)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:46)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:223)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:136)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:274)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:730)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:329)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:86)
at Test.reconstitute(Test.java:69)
at Test.main(Test.java:40) 



And finally, here is the XML document I am attempting to reconstitute:
<root>
  <Foo id="402881e4045ce90c01045ce90f950002">
    <prop1>abcd</prop1>
    <bar>402881e4045ce90c01045ce90f770001</bar>
    <index>0</index>
  </Foo>
  <Foo id="402881e4045ce90c01045ce90f9f0003">
    <prop1>456</prop1>
    <bar>402881e4045ce90c01045ce90f770001</bar>
    <index>1</index>
  </Foo>
  <Bar id="402881e4045ce90c01045ce90f770001">
    <foos>
      <foo>402881e4045ce90c01045ce90f950002</foo>
      <foo>402881e4045ce90c01045ce90f9f0003</foo>
    </foos>
  </Bar>
</root>




---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.

If you think it was sent incorrectly contact one of the administrators:
   http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa

If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira

[Hibernate-issues] [Hibernate-JIRA] Commented: (HHH-616) replicate() with a bidirectional relationship fails (dom4j)

[<no...@at...>]

The following comment has been added to this issue:

     Author: Konstantin Ignatyev
    Created: Fri, 22 Jul 2005 4:12 PM
       Body:
It is actually possible to replicate the data is replication code respects relationships: put 'parent' objects in the session before 'childs'

The following modification of you script works:
private static void replicate( List elements, String name, String targetName, Session s){
      Iterator it = elements.iterator();
      while(it.hasNext())
      {
          Element e = (Element)it.next();
          log.debug(e.getName());
          if(e.getName().equals(name ))
              s.replicate( targetName ,e, ReplicationMode.IGNORE);

      }
    }


    private static void reconstitute()
    {
        try
        {
            SAXReader reader = new SAXReader();
            Document doc = reader.read(new File("content.xml"));

            Session session = currentSession();
            Session s = session.getSession(EntityMode.DOM4J);
            Transaction txn = s.beginTransaction();
            {
                List elems = doc.getRootElement().elements();
                replicate( elems, "Bar", "data.Bar", s);
               // s.flush();
                replicate( elems, "Foo", "data.Foo", s);
            }

            txn.commit();
        }
        catch(DocumentException e)
        {
            log.error(e);
        }
    }

---------------------------------------------------------------------
View this comment:
  http://opensource.atlassian.com/projects/hibernate/browse/HHH-616?page=comments#action_19000

---------------------------------------------------------------------
View the issue:
  http://opensource.atlassian.com/projects/hibernate/browse/HHH-616

Here is an overview of the issue:
---------------------------------------------------------------------
        Key: HHH-616
    Summary: replicate() with a bidirectional relationship fails (dom4j)
       Type: Bug

     Status: Open
   Priority: Major

 Original Estimate: Unknown
 Time Spent: Unknown
  Remaining: Unknown

    Project: Hibernate3
 Components: 
             core
   Versions:
             3.0.5

   Assignee: Gavin King
   Reporter: David Tashima

    Created: Tue, 14 Jun 2005 5:19 PM
    Updated: Fri, 22 Jul 2005 4:12 PM
Environment: Hibernate 3.0.5; MySQL 4.1.12

Description:
Here is the original forum post:
http://forum.hibernate.org/viewtopic.php?t=943520

Basically, I am trying to transfer stuff from one DB to another via the Dom4j session. I create an XML document from the source DB and then I am using session.replicate() on the receiving end to instantiate the new objects from that XML document.

It works for simple objects, but when I have a bidirectional reference, it is unable to .replicate() the pair of objects, even if I try to commit() them all in the same transaction.

I have created a simple model to reproduce this.

Mapping document:
<hibernate-mapping
    package="data">
    <class name="Foo"
           table="foo"
           >
        <id name="id"
            node="@id"
            type="string"
            unsaved-value="null"
            column="foo_id" >
            <generator class="uuid" />
        </id>
        <property
            name="prop1"
            column="prop1"
            type="string"
            />
        <many-to-one
            name="bar"
            column="bar_id"
            class="Bar"
            not-null="false"
            embed-xml="false"
            />
        <property
            name="index"
            column="foo_index"
            type="int"
            update="true"
            />
     </class>
    <class name="Bar"
           table="bar"
           >
        <id name="id"
            node="@id"
            type="string"
            unsaved-value="null"
            column="bar_id" >
            <generator class="uuid" />
        </id>
        <list
            name="foos"
            node="foos"
            embed-xml="true"
            inverse="true"
            lazy="false">
            <key column="bar_id"/>
            <list-index column="foo_index"/>
            <one-to-many
                class="Foo"
                embed-xml="false"
                node="foo"
                />
        </list>
    </class>
</hibernate-mapping>


Reconstitution code:
        try
        {
            SAXReader reader = new SAXReader();
            Document doc = reader.read(new File("content.xml"));

            Session session = currentSession();
            Session s = session.getSession(EntityMode.DOM4J);
            Transaction txn = s.beginTransaction();
            {
                List elems = doc.getRootElement().elements();
                Iterator it = elems.iterator();
                while(it.hasNext())
                {
                    Element e = (Element)it.next();
                    log.debug(e.getName());
                    if(e.getName().equals("Foo"))
                        s.replicate("data.Foo",e, ReplicationMode.IGNORE);
                    if(e.getName().equals("Bar"))
                        s.replicate("data.Bar",e, ReplicationMode.IGNORE);
                }
            }

            txn.commit();
        }
        catch(DocumentException e)
        {
            log.error(e);
        } 



Here is the stack trace:
150 [main] ERROR org.hibernate.util.JDBCExceptionReporter - Cannot add or update a child row: a foreign key constraint fails
291 [main] ERROR org.hibernate.event.def.AbstractFlushingEventListener - Could not synchronize database state with session
org.hibernate.exception.ConstraintViolationException: could not insert: [data.Foo]
at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:74)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1869)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:2200)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:46)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:223)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:136)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:274)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:730)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:329)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:86)
at Test.reconstitute(Test.java:69)
at Test.main(Test.java:40)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.intellij.rt.execution.application.AppMain.main(AppMain.java:78)
Caused by: java.sql.SQLException: Cannot add or update a child row: a foreign key constraint fails
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2851)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)
at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1366)
at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:952)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1974)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1897)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1758)
at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1853)
... 17 more
Exception in thread "main" org.hibernate.exception.ConstraintViolationException: could not insert: [data.Foo]
at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:74)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1869)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:2200)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:46)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:223)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:136)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:274)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:730)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:329)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:86)
at Test.reconstitute(Test.java:69)
at Test.main(Test.java:40) 



And finally, here is the XML document I am attempting to reconstitute:
<root>
  <Foo id="402881e4045ce90c01045ce90f950002">
    <prop1>abcd</prop1>
    <bar>402881e4045ce90c01045ce90f770001</bar>
    <index>0</index>
  </Foo>
  <Foo id="402881e4045ce90c01045ce90f9f0003">
    <prop1>456</prop1>
    <bar>402881e4045ce90c01045ce90f770001</bar>
    <index>1</index>
  </Foo>
  <Bar id="402881e4045ce90c01045ce90f770001">
    <foos>
      <foo>402881e4045ce90c01045ce90f950002</foo>
      <foo>402881e4045ce90c01045ce90f9f0003</foo>
    </foos>
  </Bar>
</root>




---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.

If you think it was sent incorrectly contact one of the administrators:
   http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa

If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira

[Hibernate-issues] [Hibernate-JIRA] Updated: (HHH-616) replicate() with a bidirectional relationship fails (dom4j)

[Steve E. (JIRA) <no...@at...>]

     [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-616?page=all ]

Steve Ebersole updated HHH-616:
-------------------------------

    Description: 
Here is the original forum post:
http://forum.hibernate.org/viewtopic.php?t=943520

Basically, I am trying to transfer stuff from one DB to another via the Dom4j session. I create an XML document from the source DB and then I am using session.replicate() on the receiving end to instantiate the new objects from that XML document.

It works for simple objects, but when I have a bidirectional reference, it is unable to .replicate() the pair of objects, even if I try to commit() them all in the same transaction.

I have created a simple model to reproduce this.

Mapping document:
<hibernate-mapping
    package="data">
    <class name="Foo"
           table="foo"
           >
        <id name="id"
            node="@id"
            type="string"
            unsaved-value="null"
            column="foo_id" >
            <generator class="uuid" />
        </id>
        <property
            name="prop1"
            column="prop1"
            type="string"
            />
        <many-to-one
            name="bar"
            column="bar_id"
            class="Bar"
            not-null="false"
            embed-xml="false"
            />
        <property
            name="index"
            column="foo_index"
            type="int"
            update="true"
            />
     </class>
    <class name="Bar"
           table="bar"
           >
        <id name="id"
            node="@id"
            type="string"
            unsaved-value="null"
            column="bar_id" >
            <generator class="uuid" />
        </id>
        <list
            name="foos"
            node="foos"
            embed-xml="true"
            inverse="true"
            lazy="false">
            <key column="bar_id"/>
            <list-index column="foo_index"/>
            <one-to-many
                class="Foo"
                embed-xml="false"
                node="foo"
                />
        </list>
    </class>
</hibernate-mapping>


Reconstitution code:
        try
        {
            SAXReader reader = new SAXReader();
            Document doc = reader.read(new File("content.xml"));

            Session session = currentSession();
            Session s = session.getSession(EntityMode.DOM4J);
            Transaction txn = s.beginTransaction();
            {
                List elems = doc.getRootElement().elements();
                Iterator it = elems.iterator();
                while(it.hasNext())
                {
                    Element e = (Element)it.next();
                    log.debug(e.getName());
                    if(e.getName().equals("Foo"))
                        s.replicate("data.Foo",e, ReplicationMode.IGNORE);
                    if(e.getName().equals("Bar"))
                        s.replicate("data.Bar",e, ReplicationMode.IGNORE);
                }
            }

            txn.commit();
        }
        catch(DocumentException e)
        {
            log.error(e);
        } 



Here is the stack trace:
150 [main] ERROR org.hibernate.util.JDBCExceptionReporter - Cannot add or update a child row: a foreign key constraint fails
291 [main] ERROR org.hibernate.event.def.AbstractFlushingEventListener - Could not synchronize database state with session
org.hibernate.exception.ConstraintViolationException: could not insert: [data.Foo]
at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:74)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1869)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:2200)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:46)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:223)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:136)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:274)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:730)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:329)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:86)
at Test.reconstitute(Test.java:69)
at Test.main(Test.java:40)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.intellij.rt.execution.application.AppMain.main(AppMain.java:78)
Caused by: java.sql.SQLException: Cannot add or update a child row: a foreign key constraint fails
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2851)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)
at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1366)
at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:952)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1974)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1897)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1758)
at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1853)
... 17 more
Exception in thread "main" org.hibernate.exception.ConstraintViolationException: could not insert: [data.Foo]
at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:74)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1869)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:2200)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:46)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:223)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:136)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:274)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:730)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:329)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:86)
at Test.reconstitute(Test.java:69)
at Test.main(Test.java:40) 



And finally, here is the XML document I am attempting to reconstitute:
<root>
  <Foo id="402881e4045ce90c01045ce90f950002">
    <prop1>abcd</prop1>
    <bar>402881e4045ce90c01045ce90f770001</bar>
    <index>0</index>
  </Foo>
  <Foo id="402881e4045ce90c01045ce90f9f0003">
    <prop1>456</prop1>
    <bar>402881e4045ce90c01045ce90f770001</bar>
    <index>1</index>
  </Foo>
  <Bar id="402881e4045ce90c01045ce90f770001">
    <foos>
      <foo>402881e4045ce90c01045ce90f950002</foo>
      <foo>402881e4045ce90c01045ce90f9f0003</foo>
    </foos>
  </Bar>
</root>



  was:
Here is the original forum post:
http://forum.hibernate.org/viewtopic.php?t=943520

Basically, I am trying to transfer stuff from one DB to another via the Dom4j session. I create an XML document from the source DB and then I am using session.replicate() on the receiving end to instantiate the new objects from that XML document.

It works for simple objects, but when I have a bidirectional reference, it is unable to .replicate() the pair of objects, even if I try to commit() them all in the same transaction.

I have created a simple model to reproduce this.

Mapping document:
<hibernate-mapping
    package="data">
    <class name="Foo"
           table="foo"
           >
        <id name="id"
            node="@id"
            type="string"
            unsaved-value="null"
            column="foo_id" >
            <generator class="uuid" />
        </id>
        <property
            name="prop1"
            column="prop1"
            type="string"
            />
        <many-to-one
            name="bar"
            column="bar_id"
            class="Bar"
            not-null="false"
            embed-xml="false"
            />
        <property
            name="index"
            column="foo_index"
            type="int"
            update="true"
            />
     </class>
    <class name="Bar"
           table="bar"
           >
        <id name="id"
            node="@id"
            type="string"
            unsaved-value="null"
            column="bar_id" >
            <generator class="uuid" />
        </id>
        <list
            name="foos"
            node="foos"
            embed-xml="true"
            inverse="true"
            lazy="false">
            <key column="bar_id"/>
            <list-index column="foo_index"/>
            <one-to-many
                class="Foo"
                embed-xml="false"
                node="foo"
                />
        </list>
    </class>
</hibernate-mapping>


Reconstitution code:
        try
        {
            SAXReader reader = new SAXReader();
            Document doc = reader.read(new File("content.xml"));

            Session session = currentSession();
            Session s = session.getSession(EntityMode.DOM4J);
            Transaction txn = s.beginTransaction();
            {
                List elems = doc.getRootElement().elements();
                Iterator it = elems.iterator();
                while(it.hasNext())
                {
                    Element e = (Element)it.next();
                    log.debug(e.getName());
                    if(e.getName().equals("Foo"))
                        s.replicate("data.Foo",e, ReplicationMode.IGNORE);
                    if(e.getName().equals("Bar"))
                        s.replicate("data.Bar",e, ReplicationMode.IGNORE);
                }
            }

            txn.commit();
        }
        catch(DocumentException e)
        {
            log.error(e);
        } 



Here is the stack trace:
150 [main] ERROR org.hibernate.util.JDBCExceptionReporter - Cannot add or update a child row: a foreign key constraint fails
291 [main] ERROR org.hibernate.event.def.AbstractFlushingEventListener - Could not synchronize database state with session
org.hibernate.exception.ConstraintViolationException: could not insert: [data.Foo]
at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:74)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1869)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:2200)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:46)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:223)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:136)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:274)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:730)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:329)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:86)
at Test.reconstitute(Test.java:69)
at Test.main(Test.java:40)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.intellij.rt.execution.application.AppMain.main(AppMain.java:78)
Caused by: java.sql.SQLException: Cannot add or update a child row: a foreign key constraint fails
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2851)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)
at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1366)
at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:952)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1974)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1897)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1758)
at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1853)
... 17 more
Exception in thread "main" org.hibernate.exception.ConstraintViolationException: could not insert: [data.Foo]
at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:74)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1869)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:2200)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:46)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:223)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:136)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:274)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:730)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:329)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:86)
at Test.reconstitute(Test.java:69)
at Test.main(Test.java:40) 



And finally, here is the XML document I am attempting to reconstitute:
<root>
  <Foo id="402881e4045ce90c01045ce90f950002">
    <prop1>abcd</prop1>
    <bar>402881e4045ce90c01045ce90f770001</bar>
    <index>0</index>
  </Foo>
  <Foo id="402881e4045ce90c01045ce90f9f0003">
    <prop1>456</prop1>
    <bar>402881e4045ce90c01045ce90f770001</bar>
    <index>1</index>
  </Foo>
  <Bar id="402881e4045ce90c01045ce90f770001">
    <foos>
      <foo>402881e4045ce90c01045ce90f950002</foo>
      <foo>402881e4045ce90c01045ce90f9f0003</foo>
    </foos>
  </Bar>
</root>



    Fix Version: 3.2

> replicate() with a bidirectional relationship fails (dom4j)
> -----------------------------------------------------------
>
>          Key: HHH-616
>          URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-616
>      Project: Hibernate3
>         Type: Bug
>   Components: core
>     Versions: 3.0.5
>  Environment: Hibernate 3.0.5; MySQL 4.1.12
>     Reporter: David Tashima
>     Assignee: Gavin King
>      Fix For: 3.2
>  Attachments: test.zip
>
>
> Here is the original forum post:
> http://forum.hibernate.org/viewtopic.php?t=943520
> Basically, I am trying to transfer stuff from one DB to another via the Dom4j session. I create an XML document from the source DB and then I am using session.replicate() on the receiving end to instantiate the new objects from that XML document.
> It works for simple objects, but when I have a bidirectional reference, it is unable to .replicate() the pair of objects, even if I try to commit() them all in the same transaction.
> I have created a simple model to reproduce this.
> Mapping document:
> <hibernate-mapping
>     package="data">
>     <class name="Foo"
>            table="foo"
>            >
>         <id name="id"
>             node="@id"
>             type="string"
>             unsaved-value="null"
>             column="foo_id" >
>             <generator class="uuid" />
>         </id>
>         <property
>             name="prop1"
>             column="prop1"
>             type="string"
>             />
>         <many-to-one
>             name="bar"
>             column="bar_id"
>             class="Bar"
>             not-null="false"
>             embed-xml="false"
>             />
>         <property
>             name="index"
>             column="foo_index"
>             type="int"
>             update="true"
>             />
>      </class>
>     <class name="Bar"
>            table="bar"
>            >
>         <id name="id"
>             node="@id"
>             type="string"
>             unsaved-value="null"
>             column="bar_id" >
>             <generator class="uuid" />
>         </id>
>         <list
>             name="foos"
>             node="foos"
>             embed-xml="true"
>             inverse="true"
>             lazy="false">
>             <key column="bar_id"/>
>             <list-index column="foo_index"/>
>             <one-to-many
>                 class="Foo"
>                 embed-xml="false"
>                 node="foo"
>                 />
>         </list>
>     </class>
> </hibernate-mapping>
> Reconstitution code:
>         try
>         {
>             SAXReader reader = new SAXReader();
>             Document doc = reader.read(new File("content.xml"));
>             Session session = currentSession();
>             Session s = session.getSession(EntityMode.DOM4J);
>             Transaction txn = s.beginTransaction();
>             {
>                 List elems = doc.getRootElement().elements();
>                 Iterator it = elems.iterator();
>                 while(it.hasNext())
>                 {
>                     Element e = (Element)it.next();
>                     log.debug(e.getName());
>                     if(e.getName().equals("Foo"))
>                         s.replicate("data.Foo",e, ReplicationMode.IGNORE);
>                     if(e.getName().equals("Bar"))
>                         s.replicate("data.Bar",e, ReplicationMode.IGNORE);
>                 }
>             }
>             txn.commit();
>         }
>         catch(DocumentException e)
>         {
>             log.error(e);
>         } 
> Here is the stack trace:
> 150 [main] ERROR org.hibernate.util.JDBCExceptionReporter - Cannot add or update a child row: a foreign key constraint fails
> 291 [main] ERROR org.hibernate.event.def.AbstractFlushingEventListener - Could not synchronize database state with session
> org.hibernate.exception.ConstraintViolationException: could not insert: [data.Foo]
> at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:74)
> at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
> at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1869)
> at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:2200)
> at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:46)
> at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
> at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:223)
> at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:136)
> at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:274)
> at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
> at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:730)
> at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:329)
> at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:86)
> at Test.reconstitute(Test.java:69)
> at Test.main(Test.java:40)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:585)
> at com.intellij.rt.execution.application.AppMain.main(AppMain.java:78)
> Caused by: java.sql.SQLException: Cannot add or update a child row: a foreign key constraint fails
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2851)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)
> at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1366)
> at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:952)
> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1974)
> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1897)
> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1758)
> at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22)
> at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1853)
> ... 17 more
> Exception in thread "main" org.hibernate.exception.ConstraintViolationException: could not insert: [data.Foo]
> at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:74)
> at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
> at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1869)
> at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:2200)
> at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:46)
> at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
> at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:223)
> at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:136)
> at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:274)
> at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
> at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:730)
> at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:329)
> at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:86)
> at Test.reconstitute(Test.java:69)
> at Test.main(Test.java:40) 
> And finally, here is the XML document I am attempting to reconstitute:
> <root>
>   <Foo id="402881e4045ce90c01045ce90f950002">
>     <prop1>abcd</prop1>
>     <bar>402881e4045ce90c01045ce90f770001</bar>
>     <index>0</index>
>   </Foo>
>   <Foo id="402881e4045ce90c01045ce90f9f0003">
>     <prop1>456</prop1>
>     <bar>402881e4045ce90c01045ce90f770001</bar>
>     <index>1</index>
>   </Foo>
>   <Bar id="402881e4045ce90c01045ce90f770001">
>     <foos>
>       <foo>402881e4045ce90c01045ce90f950002</foo>
>       <foo>402881e4045ce90c01045ce90f9f0003</foo>
>     </foos>
>   </Bar>
> </root>

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira

[Hibernate-issues] [Hibernate-JIRA] Commented: (HHH-616) replicate() with a bidirectional relationship fails (dom4j)

[David T. (JIRA) <no...@at...>]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-616?page=comments#action_21127 ] 

David Tashima commented on HHH-616:
-----------------------------------

Thank you Konstantin, your advice solved my particular problem.

But it certainly begs the question, what happens if you have a cyclical schema (Foo-->Bar-->Donut-->Foo)?

And should the order that you replicate() the objects *really* matter if you don't flush?


I've posted test3.zip. which has a test case with cyclical dependenices.

> replicate() with a bidirectional relationship fails (dom4j)
> -----------------------------------------------------------
>
>          Key: HHH-616
>          URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-616
>      Project: Hibernate3
>         Type: Bug
>   Components: core
>     Versions: 3.0.5
>  Environment: Hibernate 3.0.5; MySQL 4.1.12
>     Reporter: David Tashima
>     Assignee: Gavin King
>      Fix For: 3.2
>  Attachments: test.zip
>
>
> Here is the original forum post:
> http://forum.hibernate.org/viewtopic.php?t=943520
> Basically, I am trying to transfer stuff from one DB to another via the Dom4j session. I create an XML document from the source DB and then I am using session.replicate() on the receiving end to instantiate the new objects from that XML document.
> It works for simple objects, but when I have a bidirectional reference, it is unable to .replicate() the pair of objects, even if I try to commit() them all in the same transaction.
> I have created a simple model to reproduce this.
> Mapping document:
> <hibernate-mapping
>     package="data">
>     <class name="Foo"
>            table="foo"
>            >
>         <id name="id"
>             node="@id"
>             type="string"
>             unsaved-value="null"
>             column="foo_id" >
>             <generator class="uuid" />
>         </id>
>         <property
>             name="prop1"
>             column="prop1"
>             type="string"
>             />
>         <many-to-one
>             name="bar"
>             column="bar_id"
>             class="Bar"
>             not-null="false"
>             embed-xml="false"
>             />
>         <property
>             name="index"
>             column="foo_index"
>             type="int"
>             update="true"
>             />
>      </class>
>     <class name="Bar"
>            table="bar"
>            >
>         <id name="id"
>             node="@id"
>             type="string"
>             unsaved-value="null"
>             column="bar_id" >
>             <generator class="uuid" />
>         </id>
>         <list
>             name="foos"
>             node="foos"
>             embed-xml="true"
>             inverse="true"
>             lazy="false">
>             <key column="bar_id"/>
>             <list-index column="foo_index"/>
>             <one-to-many
>                 class="Foo"
>                 embed-xml="false"
>                 node="foo"
>                 />
>         </list>
>     </class>
> </hibernate-mapping>
> Reconstitution code:
>         try
>         {
>             SAXReader reader = new SAXReader();
>             Document doc = reader.read(new File("content.xml"));
>             Session session = currentSession();
>             Session s = session.getSession(EntityMode.DOM4J);
>             Transaction txn = s.beginTransaction();
>             {
>                 List elems = doc.getRootElement().elements();
>                 Iterator it = elems.iterator();
>                 while(it.hasNext())
>                 {
>                     Element e = (Element)it.next();
>                     log.debug(e.getName());
>                     if(e.getName().equals("Foo"))
>                         s.replicate("data.Foo",e, ReplicationMode.IGNORE);
>                     if(e.getName().equals("Bar"))
>                         s.replicate("data.Bar",e, ReplicationMode.IGNORE);
>                 }
>             }
>             txn.commit();
>         }
>         catch(DocumentException e)
>         {
>             log.error(e);
>         } 
> Here is the stack trace:
> 150 [main] ERROR org.hibernate.util.JDBCExceptionReporter - Cannot add or update a child row: a foreign key constraint fails
> 291 [main] ERROR org.hibernate.event.def.AbstractFlushingEventListener - Could not synchronize database state with session
> org.hibernate.exception.ConstraintViolationException: could not insert: [data.Foo]
> at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:74)
> at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
> at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1869)
> at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:2200)
> at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:46)
> at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
> at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:223)
> at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:136)
> at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:274)
> at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
> at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:730)
> at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:329)
> at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:86)
> at Test.reconstitute(Test.java:69)
> at Test.main(Test.java:40)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:585)
> at com.intellij.rt.execution.application.AppMain.main(AppMain.java:78)
> Caused by: java.sql.SQLException: Cannot add or update a child row: a foreign key constraint fails
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2851)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)
> at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1366)
> at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:952)
> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1974)
> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1897)
> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1758)
> at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22)
> at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1853)
> ... 17 more
> Exception in thread "main" org.hibernate.exception.ConstraintViolationException: could not insert: [data.Foo]
> at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:74)
> at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
> at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1869)
> at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:2200)
> at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:46)
> at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
> at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:223)
> at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:136)
> at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:274)
> at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
> at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:730)
> at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:329)
> at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:86)
> at Test.reconstitute(Test.java:69)
> at Test.main(Test.java:40) 
> And finally, here is the XML document I am attempting to reconstitute:
> <root>
>   <Foo id="402881e4045ce90c01045ce90f950002">
>     <prop1>abcd</prop1>
>     <bar>402881e4045ce90c01045ce90f770001</bar>
>     <index>0</index>
>   </Foo>
>   <Foo id="402881e4045ce90c01045ce90f9f0003">
>     <prop1>456</prop1>
>     <bar>402881e4045ce90c01045ce90f770001</bar>
>     <index>1</index>
>   </Foo>
>   <Bar id="402881e4045ce90c01045ce90f770001">
>     <foos>
>       <foo>402881e4045ce90c01045ce90f950002</foo>
>       <foo>402881e4045ce90c01045ce90f9f0003</foo>
>     </foos>
>   </Bar>
> </root>

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira

[Hibernate-issues] [Hibernate-JIRA] Updated: (HHH-616) replicate() with a bidirectional relationship fails (dom4j)

[David T. (JIRA) <no...@at...>]

     [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-616?page=all ]

David Tashima updated HHH-616:
------------------------------

    Attachment: test3.zip

Test case w/ cyclical many-to-one dependencies

> replicate() with a bidirectional relationship fails (dom4j)
> -----------------------------------------------------------
>
>          Key: HHH-616
>          URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-616
>      Project: Hibernate3
>         Type: Bug
>   Components: core
>     Versions: 3.0.5
>  Environment: Hibernate 3.0.5; MySQL 4.1.12
>     Reporter: David Tashima
>     Assignee: Gavin King
>      Fix For: 3.2
>  Attachments: test.zip, test3.zip
>
>
> Here is the original forum post:
> http://forum.hibernate.org/viewtopic.php?t=943520
> Basically, I am trying to transfer stuff from one DB to another via the Dom4j session. I create an XML document from the source DB and then I am using session.replicate() on the receiving end to instantiate the new objects from that XML document.
> It works for simple objects, but when I have a bidirectional reference, it is unable to .replicate() the pair of objects, even if I try to commit() them all in the same transaction.
> I have created a simple model to reproduce this.
> Mapping document:
> <hibernate-mapping
>     package="data">
>     <class name="Foo"
>            table="foo"
>            >
>         <id name="id"
>             node="@id"
>             type="string"
>             unsaved-value="null"
>             column="foo_id" >
>             <generator class="uuid" />
>         </id>
>         <property
>             name="prop1"
>             column="prop1"
>             type="string"
>             />
>         <many-to-one
>             name="bar"
>             column="bar_id"
>             class="Bar"
>             not-null="false"
>             embed-xml="false"
>             />
>         <property
>             name="index"
>             column="foo_index"
>             type="int"
>             update="true"
>             />
>      </class>
>     <class name="Bar"
>            table="bar"
>            >
>         <id name="id"
>             node="@id"
>             type="string"
>             unsaved-value="null"
>             column="bar_id" >
>             <generator class="uuid" />
>         </id>
>         <list
>             name="foos"
>             node="foos"
>             embed-xml="true"
>             inverse="true"
>             lazy="false">
>             <key column="bar_id"/>
>             <list-index column="foo_index"/>
>             <one-to-many
>                 class="Foo"
>                 embed-xml="false"
>                 node="foo"
>                 />
>         </list>
>     </class>
> </hibernate-mapping>
> Reconstitution code:
>         try
>         {
>             SAXReader reader = new SAXReader();
>             Document doc = reader.read(new File("content.xml"));
>             Session session = currentSession();
>             Session s = session.getSession(EntityMode.DOM4J);
>             Transaction txn = s.beginTransaction();
>             {
>                 List elems = doc.getRootElement().elements();
>                 Iterator it = elems.iterator();
>                 while(it.hasNext())
>                 {
>                     Element e = (Element)it.next();
>                     log.debug(e.getName());
>                     if(e.getName().equals("Foo"))
>                         s.replicate("data.Foo",e, ReplicationMode.IGNORE);
>                     if(e.getName().equals("Bar"))
>                         s.replicate("data.Bar",e, ReplicationMode.IGNORE);
>                 }
>             }
>             txn.commit();
>         }
>         catch(DocumentException e)
>         {
>             log.error(e);
>         } 
> Here is the stack trace:
> 150 [main] ERROR org.hibernate.util.JDBCExceptionReporter - Cannot add or update a child row: a foreign key constraint fails
> 291 [main] ERROR org.hibernate.event.def.AbstractFlushingEventListener - Could not synchronize database state with session
> org.hibernate.exception.ConstraintViolationException: could not insert: [data.Foo]
> at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:74)
> at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
> at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1869)
> at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:2200)
> at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:46)
> at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
> at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:223)
> at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:136)
> at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:274)
> at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
> at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:730)
> at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:329)
> at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:86)
> at Test.reconstitute(Test.java:69)
> at Test.main(Test.java:40)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:585)
> at com.intellij.rt.execution.application.AppMain.main(AppMain.java:78)
> Caused by: java.sql.SQLException: Cannot add or update a child row: a foreign key constraint fails
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2851)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)
> at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1366)
> at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:952)
> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1974)
> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1897)
> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1758)
> at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22)
> at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1853)
> ... 17 more
> Exception in thread "main" org.hibernate.exception.ConstraintViolationException: could not insert: [data.Foo]
> at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:74)
> at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
> at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1869)
> at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:2200)
> at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:46)
> at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
> at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:223)
> at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:136)
> at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:274)
> at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
> at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:730)
> at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:329)
> at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:86)
> at Test.reconstitute(Test.java:69)
> at Test.main(Test.java:40) 
> And finally, here is the XML document I am attempting to reconstitute:
> <root>
>   <Foo id="402881e4045ce90c01045ce90f950002">
>     <prop1>abcd</prop1>
>     <bar>402881e4045ce90c01045ce90f770001</bar>
>     <index>0</index>
>   </Foo>
>   <Foo id="402881e4045ce90c01045ce90f9f0003">
>     <prop1>456</prop1>
>     <bar>402881e4045ce90c01045ce90f770001</bar>
>     <index>1</index>
>   </Foo>
>   <Bar id="402881e4045ce90c01045ce90f770001">
>     <foos>
>       <foo>402881e4045ce90c01045ce90f950002</foo>
>       <foo>402881e4045ce90c01045ce90f9f0003</foo>
>     </foos>
>   </Bar>
> </root>

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira

[Hibernate-issues] [Hibernate-JIRA] Updated: (HHH-616) replicate() with a bidirectional relationship fails (dom4j)

[Steve E. (JIRA) <no...@at...>]

     [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-616?page=all ]

Steve Ebersole updated HHH-616:
-------------------------------

    Fix Version:     (was: 3.2)
                 3.2 tmp

> replicate() with a bidirectional relationship fails (dom4j)
> -----------------------------------------------------------
>
>          Key: HHH-616
>          URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-616
>      Project: Hibernate3
>         Type: Bug

>   Components: core
>     Versions: 3.0.5
>  Environment: Hibernate 3.0.5; MySQL 4.1.12
>     Reporter: David Tashima
>     Assignee: Gavin King
>      Fix For: 3.2 tmp
>  Attachments: test.zip, test3.zip
>
>
> Here is the original forum post:
> http://forum.hibernate.org/viewtopic.php?t=943520
> Basically, I am trying to transfer stuff from one DB to another via the Dom4j session. I create an XML document from the source DB and then I am using session.replicate() on the receiving end to instantiate the new objects from that XML document.
> It works for simple objects, but when I have a bidirectional reference, it is unable to .replicate() the pair of objects, even if I try to commit() them all in the same transaction.
> I have created a simple model to reproduce this.
> Mapping document:
> <hibernate-mapping
>     package="data">
>     <class name="Foo"
>            table="foo"
>            >
>         <id name="id"
>             node="@id"
>             type="string"
>             unsaved-value="null"
>             column="foo_id" >
>             <generator class="uuid" />
>         </id>
>         <property
>             name="prop1"
>             column="prop1"
>             type="string"
>             />
>         <many-to-one
>             name="bar"
>             column="bar_id"
>             class="Bar"
>             not-null="false"
>             embed-xml="false"
>             />
>         <property
>             name="index"
>             column="foo_index"
>             type="int"
>             update="true"
>             />
>      </class>
>     <class name="Bar"
>            table="bar"
>            >
>         <id name="id"
>             node="@id"
>             type="string"
>             unsaved-value="null"
>             column="bar_id" >
>             <generator class="uuid" />
>         </id>
>         <list
>             name="foos"
>             node="foos"
>             embed-xml="true"
>             inverse="true"
>             lazy="false">
>             <key column="bar_id"/>
>             <list-index column="foo_index"/>
>             <one-to-many
>                 class="Foo"
>                 embed-xml="false"
>                 node="foo"
>                 />
>         </list>
>     </class>
> </hibernate-mapping>
> Reconstitution code:
>         try
>         {
>             SAXReader reader = new SAXReader();
>             Document doc = reader.read(new File("content.xml"));
>             Session session = currentSession();
>             Session s = session.getSession(EntityMode.DOM4J);
>             Transaction txn = s.beginTransaction();
>             {
>                 List elems = doc.getRootElement().elements();
>                 Iterator it = elems.iterator();
>                 while(it.hasNext())
>                 {
>                     Element e = (Element)it.next();
>                     log.debug(e.getName());
>                     if(e.getName().equals("Foo"))
>                         s.replicate("data.Foo",e, ReplicationMode.IGNORE);
>                     if(e.getName().equals("Bar"))
>                         s.replicate("data.Bar",e, ReplicationMode.IGNORE);
>                 }
>             }
>             txn.commit();
>         }
>         catch(DocumentException e)
>         {
>             log.error(e);
>         } 
> Here is the stack trace:
> 150 [main] ERROR org.hibernate.util.JDBCExceptionReporter - Cannot add or update a child row: a foreign key constraint fails
> 291 [main] ERROR org.hibernate.event.def.AbstractFlushingEventListener - Could not synchronize database state with session
> org.hibernate.exception.ConstraintViolationException: could not insert: [data.Foo]
> at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:74)
> at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
> at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1869)
> at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:2200)
> at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:46)
> at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
> at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:223)
> at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:136)
> at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:274)
> at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
> at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:730)
> at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:329)
> at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:86)
> at Test.reconstitute(Test.java:69)
> at Test.main(Test.java:40)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:585)
> at com.intellij.rt.execution.application.AppMain.main(AppMain.java:78)
> Caused by: java.sql.SQLException: Cannot add or update a child row: a foreign key constraint fails
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2851)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)
> at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1366)
> at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:952)
> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1974)
> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1897)
> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1758)
> at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22)
> at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1853)
> ... 17 more
> Exception in thread "main" org.hibernate.exception.ConstraintViolationException: could not insert: [data.Foo]
> at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:74)
> at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
> at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1869)
> at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:2200)
> at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:46)
> at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
> at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:223)
> at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:136)
> at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:274)
> at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
> at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:730)
> at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:329)
> at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:86)
> at Test.reconstitute(Test.java:69)
> at Test.main(Test.java:40) 
> And finally, here is the XML document I am attempting to reconstitute:
> <root>
>   <Foo id="402881e4045ce90c01045ce90f950002">
>     <prop1>abcd</prop1>
>     <bar>402881e4045ce90c01045ce90f770001</bar>
>     <index>0</index>
>   </Foo>
>   <Foo id="402881e4045ce90c01045ce90f9f0003">
>     <prop1>456</prop1>
>     <bar>402881e4045ce90c01045ce90f770001</bar>
>     <index>1</index>
>   </Foo>
>   <Bar id="402881e4045ce90c01045ce90f770001">
>     <foos>
>       <foo>402881e4045ce90c01045ce90f950002</foo>
>       <foo>402881e4045ce90c01045ce90f9f0003</foo>
>     </foos>
>   </Bar>
> </root>

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira

[Hibernate-issues] [Hibernate-JIRA] Updated: (HHH-616) replicate() with a bidirectional relationship fails (dom4j)

[Steve E. (JIRA) <no...@at...>]

     [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-616?page=all ]

Steve Ebersole updated HHH-616:
-------------------------------

    Fix Version:     (was: 3.2.0.alpha2)
                 3.2.0

> replicate() with a bidirectional relationship fails (dom4j)
> -----------------------------------------------------------
>
>          Key: HHH-616
>          URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-616
>      Project: Hibernate3
>         Type: Bug

>   Components: core
>     Versions: 3.0.5
>  Environment: Hibernate 3.0.5; MySQL 4.1.12
>     Reporter: David Tashima
>     Assignee: Gavin King
>      Fix For: 3.2.0
>  Attachments: test.zip, test3.zip
>
>
> Here is the original forum post:
> http://forum.hibernate.org/viewtopic.php?t=943520
> Basically, I am trying to transfer stuff from one DB to another via the Dom4j session. I create an XML document from the source DB and then I am using session.replicate() on the receiving end to instantiate the new objects from that XML document.
> It works for simple objects, but when I have a bidirectional reference, it is unable to .replicate() the pair of objects, even if I try to commit() them all in the same transaction.
> I have created a simple model to reproduce this.
> Mapping document:
> <hibernate-mapping
>     package="data">
>     <class name="Foo"
>            table="foo"
>            >
>         <id name="id"
>             node="@id"
>             type="string"
>             unsaved-value="null"
>             column="foo_id" >
>             <generator class="uuid" />
>         </id>
>         <property
>             name="prop1"
>             column="prop1"
>             type="string"
>             />
>         <many-to-one
>             name="bar"
>             column="bar_id"
>             class="Bar"
>             not-null="false"
>             embed-xml="false"
>             />
>         <property
>             name="index"
>             column="foo_index"
>             type="int"
>             update="true"
>             />
>      </class>
>     <class name="Bar"
>            table="bar"
>            >
>         <id name="id"
>             node="@id"
>             type="string"
>             unsaved-value="null"
>             column="bar_id" >
>             <generator class="uuid" />
>         </id>
>         <list
>             name="foos"
>             node="foos"
>             embed-xml="true"
>             inverse="true"
>             lazy="false">
>             <key column="bar_id"/>
>             <list-index column="foo_index"/>
>             <one-to-many
>                 class="Foo"
>                 embed-xml="false"
>                 node="foo"
>                 />
>         </list>
>     </class>
> </hibernate-mapping>
> Reconstitution code:
>         try
>         {
>             SAXReader reader = new SAXReader();
>             Document doc = reader.read(new File("content.xml"));
>             Session session = currentSession();
>             Session s = session.getSession(EntityMode.DOM4J);
>             Transaction txn = s.beginTransaction();
>             {
>                 List elems = doc.getRootElement().elements();
>                 Iterator it = elems.iterator();
>                 while(it.hasNext())
>                 {
>                     Element e = (Element)it.next();
>                     log.debug(e.getName());
>                     if(e.getName().equals("Foo"))
>                         s.replicate("data.Foo",e, ReplicationMode.IGNORE);
>                     if(e.getName().equals("Bar"))
>                         s.replicate("data.Bar",e, ReplicationMode.IGNORE);
>                 }
>             }
>             txn.commit();
>         }
>         catch(DocumentException e)
>         {
>             log.error(e);
>         } 
> Here is the stack trace:
> 150 [main] ERROR org.hibernate.util.JDBCExceptionReporter - Cannot add or update a child row: a foreign key constraint fails
> 291 [main] ERROR org.hibernate.event.def.AbstractFlushingEventListener - Could not synchronize database state with session
> org.hibernate.exception.ConstraintViolationException: could not insert: [data.Foo]
> at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:74)
> at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
> at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1869)
> at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:2200)
> at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:46)
> at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
> at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:223)
> at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:136)
> at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:274)
> at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
> at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:730)
> at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:329)
> at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:86)
> at Test.reconstitute(Test.java:69)
> at Test.main(Test.java:40)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:585)
> at com.intellij.rt.execution.application.AppMain.main(AppMain.java:78)
> Caused by: java.sql.SQLException: Cannot add or update a child row: a foreign key constraint fails
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2851)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)
> at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1366)
> at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:952)
> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1974)
> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1897)
> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1758)
> at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22)
> at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1853)
> ... 17 more
> Exception in thread "main" org.hibernate.exception.ConstraintViolationException: could not insert: [data.Foo]
> at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:74)
> at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
> at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1869)
> at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:2200)
> at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:46)
> at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
> at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:223)
> at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:136)
> at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:274)
> at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
> at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:730)
> at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:329)
> at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:86)
> at Test.reconstitute(Test.java:69)
> at Test.main(Test.java:40) 
> And finally, here is the XML document I am attempting to reconstitute:
> <root>
>   <Foo id="402881e4045ce90c01045ce90f950002">
>     <prop1>abcd</prop1>
>     <bar>402881e4045ce90c01045ce90f770001</bar>
>     <index>0</index>
>   </Foo>
>   <Foo id="402881e4045ce90c01045ce90f9f0003">
>     <prop1>456</prop1>
>     <bar>402881e4045ce90c01045ce90f770001</bar>
>     <index>1</index>
>   </Foo>
>   <Bar id="402881e4045ce90c01045ce90f770001">
>     <foos>
>       <foo>402881e4045ce90c01045ce90f950002</foo>
>       <foo>402881e4045ce90c01045ce90f9f0003</foo>
>     </foos>
>   </Bar>
> </root>

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira

[Hibernate-issues] [Hibernate-JIRA] Updated: (HHH-616) replicate() with a bidirectional relationship fails (dom4j)

[Steve E. (JIRA) <no...@at...>]

     [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-616?page=all ]

Steve Ebersole updated HHH-616:
-------------------------------

    Fix Version:     (was: 3.2.0 cr1)
                 3.2.0

> replicate() with a bidirectional relationship fails (dom4j)
> -----------------------------------------------------------
>
>          Key: HHH-616
>          URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-616
>      Project: Hibernate3
>         Type: Bug

>   Components: core
>     Versions: 3.0.5
>  Environment: Hibernate 3.0.5; MySQL 4.1.12
>     Reporter: David Tashima
>     Assignee: Gavin King
>      Fix For: 3.2.0
>  Attachments: test.zip, test3.zip
>
>
> Here is the original forum post:
> http://forum.hibernate.org/viewtopic.php?t=943520
> Basically, I am trying to transfer stuff from one DB to another via the Dom4j session. I create an XML document from the source DB and then I am using session.replicate() on the receiving end to instantiate the new objects from that XML document.
> It works for simple objects, but when I have a bidirectional reference, it is unable to .replicate() the pair of objects, even if I try to commit() them all in the same transaction.
> I have created a simple model to reproduce this.
> Mapping document:
> <hibernate-mapping
>     package="data">
>     <class name="Foo"
>            table="foo"
>            >
>         <id name="id"
>             node="@id"
>             type="string"
>             unsaved-value="null"
>             column="foo_id" >
>             <generator class="uuid" />
>         </id>
>         <property
>             name="prop1"
>             column="prop1"
>             type="string"
>             />
>         <many-to-one
>             name="bar"
>             column="bar_id"
>             class="Bar"
>             not-null="false"
>             embed-xml="false"
>             />
>         <property
>             name="index"
>             column="foo_index"
>             type="int"
>             update="true"
>             />
>      </class>
>     <class name="Bar"
>            table="bar"
>            >
>         <id name="id"
>             node="@id"
>             type="string"
>             unsaved-value="null"
>             column="bar_id" >
>             <generator class="uuid" />
>         </id>
>         <list
>             name="foos"
>             node="foos"
>             embed-xml="true"
>             inverse="true"
>             lazy="false">
>             <key column="bar_id"/>
>             <list-index column="foo_index"/>
>             <one-to-many
>                 class="Foo"
>                 embed-xml="false"
>                 node="foo"
>                 />
>         </list>
>     </class>
> </hibernate-mapping>
> Reconstitution code:
>         try
>         {
>             SAXReader reader = new SAXReader();
>             Document doc = reader.read(new File("content.xml"));
>             Session session = currentSession();
>             Session s = session.getSession(EntityMode.DOM4J);
>             Transaction txn = s.beginTransaction();
>             {
>                 List elems = doc.getRootElement().elements();
>                 Iterator it = elems.iterator();
>                 while(it.hasNext())
>                 {
>                     Element e = (Element)it.next();
>                     log.debug(e.getName());
>                     if(e.getName().equals("Foo"))
>                         s.replicate("data.Foo",e, ReplicationMode.IGNORE);
>                     if(e.getName().equals("Bar"))
>                         s.replicate("data.Bar",e, ReplicationMode.IGNORE);
>                 }
>             }
>             txn.commit();
>         }
>         catch(DocumentException e)
>         {
>             log.error(e);
>         } 
> Here is the stack trace:
> 150 [main] ERROR org.hibernate.util.JDBCExceptionReporter - Cannot add or update a child row: a foreign key constraint fails
> 291 [main] ERROR org.hibernate.event.def.AbstractFlushingEventListener - Could not synchronize database state with session
> org.hibernate.exception.ConstraintViolationException: could not insert: [data.Foo]
> at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:74)
> at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
> at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1869)
> at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:2200)
> at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:46)
> at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
> at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:223)
> at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:136)
> at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:274)
> at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
> at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:730)
> at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:329)
> at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:86)
> at Test.reconstitute(Test.java:69)
> at Test.main(Test.java:40)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:585)
> at com.intellij.rt.execution.application.AppMain.main(AppMain.java:78)
> Caused by: java.sql.SQLException: Cannot add or update a child row: a foreign key constraint fails
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2851)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)
> at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1366)
> at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:952)
> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1974)
> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1897)
> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1758)
> at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22)
> at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1853)
> ... 17 more
> Exception in thread "main" org.hibernate.exception.ConstraintViolationException: could not insert: [data.Foo]
> at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:74)
> at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
> at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1869)
> at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:2200)
> at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:46)
> at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
> at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:223)
> at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:136)
> at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:274)
> at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
> at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:730)
> at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:329)
> at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:86)
> at Test.reconstitute(Test.java:69)
> at Test.main(Test.java:40) 
> And finally, here is the XML document I am attempting to reconstitute:
> <root>
>   <Foo id="402881e4045ce90c01045ce90f950002">
>     <prop1>abcd</prop1>
>     <bar>402881e4045ce90c01045ce90f770001</bar>
>     <index>0</index>
>   </Foo>
>   <Foo id="402881e4045ce90c01045ce90f9f0003">
>     <prop1>456</prop1>
>     <bar>402881e4045ce90c01045ce90f770001</bar>
>     <index>1</index>
>   </Foo>
>   <Bar id="402881e4045ce90c01045ce90f770001">
>     <foos>
>       <foo>402881e4045ce90c01045ce90f950002</foo>
>       <foo>402881e4045ce90c01045ce90f9f0003</foo>
>     </foos>
>   </Bar>
> </root>

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira

[Hibernate-issues] [Hibernate-JIRA] Updated: (HHH-616) replicate() with a bidirectional relationship fails (dom4j)

[Steve E. (JIRA) <no...@at...>]

     [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-616?page=all ]

Steve Ebersole updated HHH-616:
-------------------------------

    Fix Version: 3.2.0
                     (was: 3.2.0.cr2)

> replicate() with a bidirectional relationship fails (dom4j)
> -----------------------------------------------------------
>
>          Key: HHH-616
>          URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-616
>      Project: Hibernate3
>         Type: Bug

>   Components: core
>     Versions: 3.0.5
>  Environment: Hibernate 3.0.5; MySQL 4.1.12
>     Reporter: David Tashima
>     Assignee: Gavin King
>      Fix For: 3.2.0
>  Attachments: test.zip, test3.zip
>
>
> Here is the original forum post:
> http://forum.hibernate.org/viewtopic.php?t=943520
> Basically, I am trying to transfer stuff from one DB to another via the Dom4j session. I create an XML document from the source DB and then I am using session.replicate() on the receiving end to instantiate the new objects from that XML document.
> It works for simple objects, but when I have a bidirectional reference, it is unable to .replicate() the pair of objects, even if I try to commit() them all in the same transaction.
> I have created a simple model to reproduce this.
> Mapping document:
> <hibernate-mapping
>     package="data">
>     <class name="Foo"
>            table="foo"
>            >
>         <id name="id"
>             node="@id"
>             type="string"
>             unsaved-value="null"
>             column="foo_id" >
>             <generator class="uuid" />
>         </id>
>         <property
>             name="prop1"
>             column="prop1"
>             type="string"
>             />
>         <many-to-one
>             name="bar"
>             column="bar_id"
>             class="Bar"
>             not-null="false"
>             embed-xml="false"
>             />
>         <property
>             name="index"
>             column="foo_index"
>             type="int"
>             update="true"
>             />
>      </class>
>     <class name="Bar"
>            table="bar"
>            >
>         <id name="id"
>             node="@id"
>             type="string"
>             unsaved-value="null"
>             column="bar_id" >
>             <generator class="uuid" />
>         </id>
>         <list
>             name="foos"
>             node="foos"
>             embed-xml="true"
>             inverse="true"
>             lazy="false">
>             <key column="bar_id"/>
>             <list-index column="foo_index"/>
>             <one-to-many
>                 class="Foo"
>                 embed-xml="false"
>                 node="foo"
>                 />
>         </list>
>     </class>
> </hibernate-mapping>
> Reconstitution code:
>         try
>         {
>             SAXReader reader = new SAXReader();
>             Document doc = reader.read(new File("content.xml"));
>             Session session = currentSession();
>             Session s = session.getSession(EntityMode.DOM4J);
>             Transaction txn = s.beginTransaction();
>             {
>                 List elems = doc.getRootElement().elements();
>                 Iterator it = elems.iterator();
>                 while(it.hasNext())
>                 {
>                     Element e = (Element)it.next();
>                     log.debug(e.getName());
>                     if(e.getName().equals("Foo"))
>                         s.replicate("data.Foo",e, ReplicationMode.IGNORE);
>                     if(e.getName().equals("Bar"))
>                         s.replicate("data.Bar",e, ReplicationMode.IGNORE);
>                 }
>             }
>             txn.commit();
>         }
>         catch(DocumentException e)
>         {
>             log.error(e);
>         } 
> Here is the stack trace:
> 150 [main] ERROR org.hibernate.util.JDBCExceptionReporter - Cannot add or update a child row: a foreign key constraint fails
> 291 [main] ERROR org.hibernate.event.def.AbstractFlushingEventListener - Could not synchronize database state with session
> org.hibernate.exception.ConstraintViolationException: could not insert: [data.Foo]
> at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:74)
> at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
> at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1869)
> at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:2200)
> at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:46)
> at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
> at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:223)
> at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:136)
> at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:274)
> at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
> at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:730)
> at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:329)
> at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:86)
> at Test.reconstitute(Test.java:69)
> at Test.main(Test.java:40)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:585)
> at com.intellij.rt.execution.application.AppMain.main(AppMain.java:78)
> Caused by: java.sql.SQLException: Cannot add or update a child row: a foreign key constraint fails
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2851)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)
> at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1366)
> at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:952)
> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1974)
> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1897)
> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1758)
> at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22)
> at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1853)
> ... 17 more
> Exception in thread "main" org.hibernate.exception.ConstraintViolationException: could not insert: [data.Foo]
> at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:74)
> at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
> at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1869)
> at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:2200)
> at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:46)
> at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
> at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:223)
> at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:136)
> at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:274)
> at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
> at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:730)
> at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:329)
> at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:86)
> at Test.reconstitute(Test.java:69)
> at Test.main(Test.java:40) 
> And finally, here is the XML document I am attempting to reconstitute:
> <root>
>   <Foo id="402881e4045ce90c01045ce90f950002">
>     <prop1>abcd</prop1>
>     <bar>402881e4045ce90c01045ce90f770001</bar>
>     <index>0</index>
>   </Foo>
>   <Foo id="402881e4045ce90c01045ce90f9f0003">
>     <prop1>456</prop1>
>     <bar>402881e4045ce90c01045ce90f770001</bar>
>     <index>1</index>
>   </Foo>
>   <Bar id="402881e4045ce90c01045ce90f770001">
>     <foos>
>       <foo>402881e4045ce90c01045ce90f950002</foo>
>       <foo>402881e4045ce90c01045ce90f9f0003</foo>
>     </foos>
>   </Bar>
> </root>

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira

[Hibernate-issues] [Hibernate-JIRA] Updated: (HHH-616) replicate() with a bidirectional relationship fails (dom4j)

[Steve E. (JIRA) <no...@at...>]

     [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-616?page=all ]

Steve Ebersole updated HHH-616:
-------------------------------

    Fix Version: 3.2.2
                     (was: 3.2.0.cr3)

> replicate() with a bidirectional relationship fails (dom4j)
> -----------------------------------------------------------
>
>          Key: HHH-616
>          URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-616
>      Project: Hibernate3
>         Type: Bug

>   Components: core
>     Versions: 3.0.5
>  Environment: Hibernate 3.0.5; MySQL 4.1.12
>     Reporter: David Tashima
>     Assignee: Gavin King
>      Fix For: 3.2.2
>  Attachments: test.zip, test3.zip
>
>
> Here is the original forum post:
> http://forum.hibernate.org/viewtopic.php?t=943520
> Basically, I am trying to transfer stuff from one DB to another via the Dom4j session. I create an XML document from the source DB and then I am using session.replicate() on the receiving end to instantiate the new objects from that XML document.
> It works for simple objects, but when I have a bidirectional reference, it is unable to .replicate() the pair of objects, even if I try to commit() them all in the same transaction.
> I have created a simple model to reproduce this.
> Mapping document:
> <hibernate-mapping
>     package="data">
>     <class name="Foo"
>            table="foo"
>            >
>         <id name="id"
>             node="@id"
>             type="string"
>             unsaved-value="null"
>             column="foo_id" >
>             <generator class="uuid" />
>         </id>
>         <property
>             name="prop1"
>             column="prop1"
>             type="string"
>             />
>         <many-to-one
>             name="bar"
>             column="bar_id"
>             class="Bar"
>             not-null="false"
>             embed-xml="false"
>             />
>         <property
>             name="index"
>             column="foo_index"
>             type="int"
>             update="true"
>             />
>      </class>
>     <class name="Bar"
>            table="bar"
>            >
>         <id name="id"
>             node="@id"
>             type="string"
>             unsaved-value="null"
>             column="bar_id" >
>             <generator class="uuid" />
>         </id>
>         <list
>             name="foos"
>             node="foos"
>             embed-xml="true"
>             inverse="true"
>             lazy="false">
>             <key column="bar_id"/>
>             <list-index column="foo_index"/>
>             <one-to-many
>                 class="Foo"
>                 embed-xml="false"
>                 node="foo"
>                 />
>         </list>
>     </class>
> </hibernate-mapping>
> Reconstitution code:
>         try
>         {
>             SAXReader reader = new SAXReader();
>             Document doc = reader.read(new File("content.xml"));
>             Session session = currentSession();
>             Session s = session.getSession(EntityMode.DOM4J);
>             Transaction txn = s.beginTransaction();
>             {
>                 List elems = doc.getRootElement().elements();
>                 Iterator it = elems.iterator();
>                 while(it.hasNext())
>                 {
>                     Element e = (Element)it.next();
>                     log.debug(e.getName());
>                     if(e.getName().equals("Foo"))
>                         s.replicate("data.Foo",e, ReplicationMode.IGNORE);
>                     if(e.getName().equals("Bar"))
>                         s.replicate("data.Bar",e, ReplicationMode.IGNORE);
>                 }
>             }
>             txn.commit();
>         }
>         catch(DocumentException e)
>         {
>             log.error(e);
>         } 
> Here is the stack trace:
> 150 [main] ERROR org.hibernate.util.JDBCExceptionReporter - Cannot add or update a child row: a foreign key constraint fails
> 291 [main] ERROR org.hibernate.event.def.AbstractFlushingEventListener - Could not synchronize database state with session
> org.hibernate.exception.ConstraintViolationException: could not insert: [data.Foo]
> at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:74)
> at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
> at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1869)
> at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:2200)
> at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:46)
> at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
> at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:223)
> at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:136)
> at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:274)
> at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
> at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:730)
> at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:329)
> at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:86)
> at Test.reconstitute(Test.java:69)
> at Test.main(Test.java:40)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:585)
> at com.intellij.rt.execution.application.AppMain.main(AppMain.java:78)
> Caused by: java.sql.SQLException: Cannot add or update a child row: a foreign key constraint fails
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2851)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)
> at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1366)
> at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:952)
> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1974)
> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1897)
> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1758)
> at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22)
> at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1853)
> ... 17 more
> Exception in thread "main" org.hibernate.exception.ConstraintViolationException: could not insert: [data.Foo]
> at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:74)
> at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
> at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1869)
> at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:2200)
> at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:46)
> at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
> at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:223)
> at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:136)
> at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:274)
> at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
> at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:730)
> at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:329)
> at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:86)
> at Test.reconstitute(Test.java:69)
> at Test.main(Test.java:40) 
> And finally, here is the XML document I am attempting to reconstitute:
> <root>
>   <Foo id="402881e4045ce90c01045ce90f950002">
>     <prop1>abcd</prop1>
>     <bar>402881e4045ce90c01045ce90f770001</bar>
>     <index>0</index>
>   </Foo>
>   <Foo id="402881e4045ce90c01045ce90f9f0003">
>     <prop1>456</prop1>
>     <bar>402881e4045ce90c01045ce90f770001</bar>
>     <index>1</index>
>   </Foo>
>   <Bar id="402881e4045ce90c01045ce90f770001">
>     <foos>
>       <foo>402881e4045ce90c01045ce90f950002</foo>
>       <foo>402881e4045ce90c01045ce90f9f0003</foo>
>     </foos>
>   </Bar>
> </root>

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira