Error when saving relationship

[Sathya Sekar]

Hello,

I am trying out a simple one-many relationship using XDoclet :

The parent's XML :

 
<hibernate-mapping>
    <class
        name="com.test.Parent"
        table="parent"
        dynamic-update="false"
        dynamic-insert="false"
    >
 
        <id
            name="id"
            column="id"
            type="int"
        >
            <generator class="native">
            </generator>
        </id>
 
        <property
            name="name"
            type="java.lang.String"
            update="true"
            insert="true"
            access="property"
            column="name"
        />
 
        <set
            name="children"
            table="Child"
            lazy="false"
            inverse="false"
            cascade="all"
            sort="unsorted"
        >
 
              <key
                  column="parent_id"
              >
              </key>
 
              <one-to-many
                  class="com.test.Child"
              />
        </set>
 
        <!--
            To add non XDoclet property mappings, create a file named
                hibernate-properties-Parent.xml
            containing the additional properties and place it in your merge dir.
        -->
 
    </class>
 
</hibernate-mapping>

and the class code :

/**
 * @hibernate.class 
 * table = "parent"
 */
public class Parent {
int id;
String name;
Set children = new HashSet();

 
/**
 * @hibernate.id
 * column = "id"
 * generator-class = "native"
 * 
 * @return Returns the id.
 */
public int getId() {
return id;
}

/**
 * @param id The id to set.
 */
public void setId(int id) {
this.id = id;
}


/**
 * @hibernate.property 
 * column = "name"
 * 
 * @return Returns the name.
 */
public String getName() {
return name;
}
/**
 * @param name The name to set.
 */
public void setName(String name) {
this.name = name;
}
 


/**
 * @hibernate.set 
 * cascade = "all"
 * table = "Child"
 * @hibernate.collection-one-to-many 
 * class = "com.test.Child"
 * @hibernate.collection-key 
 * column = "parent_id"
 * 
 * @return Returns the children.
 */
public Set getChildren() {
return children;
}
/**
 * @param children The children to set.
 */
public void setChildren(Set children) {
this.children = children;
}


public void addChild(Child child) {
if(!children.contains(child))
children.add(child);
}
 

public void removeChild(Child child) {
if(children.contains(child))
children.remove(child);
}
}
 

The child's XML :

 
<hibernate-mapping>
    <class
        name="com.test.Child"
        table="child"
        dynamic-update="false"
        dynamic-insert="false"
    >
 
        <id
            name="id"
            column="id"
            type="int"
        >
            <generator class="native">
            </generator>
        </id>
 
        <property
            name="name"
            type="java.lang.String"
            update="true"
            insert="true"
            access="property"
            column="name"
        />
 
        <!--
            To add non XDoclet property mappings, create a file named
                hibernate-properties-Child.xml
            containing the additional properties and place it in your merge dir.
        -->
 
    </class>
 
</hibernate-mapping>
 

and the class code :

/**
 * @hibernate.class 
 * table = "child"
 */
public class Child {
int id;
String name;
//Parent parent;

public Child() {
//super();
}

public Child(String nm) {
this.name = nm;
}


/**
 * @hibernate.id
 * column = "id"
 * generator-class = "native"
 * 
 * @return Returns the id.
 */
public int getId() {
return id;
}

/**
 * @param id The id to set.
 */
public void setId(int id) {
this.id = id;
}


/**
 * @hibernate.property 
 * column = "name"
 * 
 * @return Returns the name.
 */
public String getName() {
return name;
}
/**
 * @param name The name to set.
 */
public void setName(String name) {
this.name = name;
}
}
 

I am trying to add the child to the parent :

  
SessionFactory sessionFactory = config.buildSessionFactory();
Session session = sessionFactory.openSession();
Transaction txn = null;

try {
txn = session.beginTransaction();
Parent p = new Parent();
p.setName("Steve");

Child c = new Child("Child1");

p.addChild(c);
 
session.save(p);
txn.commit();
}
catch(HibernateException e) {
if(txn != null) txn.rollback();
throw e;
}
finally {
session.close();
}

This causes the below failure :

     [java] (impl.SessionImpl                    2379) Could not synchronize database state with session
     [java] net.sf.hibernate.HibernateException: Batch update row count wrong: 0
     [java] at net.sf.hibernate.impl.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:65)
     [java] at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:126)
     [java] at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2421)
     [java] at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2372)

This error does not happen if I follow the route of
- save parent and commit
- save child and commit
- add child to parent and commit

Anything I am doing wrong ?

Thanks.

[Alexandru Popescu]

Sathya take a look at this and also investigate more on native keys. I guess these are creating you problems.

./pope