hibernate 1-many insertion

[raj baig]

hi Ranchers,
i have 2 beans (employee,address)with the properties
Employee: empid,empname,empsal,address[Set] : pk: empid
Address : addid,empid,city,state pk: composite id (addid,empid)

and my hbm file

   <class name="my.pack.Employee" table="employee">
        <id name="empId" column="empid" type="java.lang.Integer">
        <generator class="assigned"/>
        </id>
       <property name="empName" column="empname"/>
<property name="empSal" column="empsal"/>
<set name="address" cascade="all" inverse="true" lazy="true">
<key column="empId" />
<one-to-many class="my.pack.Address" />
</set>
    </class>
 
 <class name="my.pack.Address" table="address">
        <!-- <id name="addId" column="addId" type="java.lang.Integer">
        <generator class="assigned"/>
        </id> -->
<composite-id>
<key-property name="addId" />
<key-property name="empId" />
</composite-id>
       <property name="city" column="city"/>
<property name="state" column="state"/>
 </class>
 
     my main class code
    
     my.pack.Address addr=new my.pack.Address();
     addr.setAddId(1111);
     addr.setEmpId(2222);
     addr.setCity("MyCity");
     addr.setState("MyState");
     Set addrSet=new HashSet();
     addrSet.add(addr);

     my.pack.Employee emp=new my.pack.Employee();
     emp.setEmpId(2222);
     emp.setEmpName("myname");
     emp.setEmpSal(99999);
     emp.setAddress(addrSet);
 
   // when i use like it is giving error : 
 
Caused by: java.sql.BatchUpdateException: Cannot add or update a child row: a foreign key constraint fails (`pack/addre
s`, CONSTRAINT `FKBB979BF4231B8CBF` FOREIGN KEY (`empid`) REFERENCES `employee` (`empid`))
        at com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:647)
        at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:58)
        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:195)
     
   

when i load it is giving me the data from two tables.
But when i insert it gives me the error.


Thangs in advance
Raj.

[David Madouros]

Make sure you are saving your instance of Employee and not Address. Let us know if it doesn't work.

[raj baig]

i am saving employee obj.

[madhuchilipi reddy]

u take empid in first table as primary keyj.
in second table we want to give the references to empid of second table.

[raj baig]

hi madhu,
i tried but giving the same error.
can you provide some more help.

Raj.

[David Madouros]

Hey Raj,

This is what I probably should have said the first time...
I recreated your situation (see code below) and I only get the constraint violation if I save address without first saving employee. Could there be a difference in our implementations?

    
<class name="Employee" table="employee">
<id name="employeeId" column="employee_id">
<generator class="assigned" />
</id>
<property name="name" />
<property name="salary" />
<set name="addresses" cascade="all" inverse="true" lazy="true">
<key column="employee_id" />
<one-to-many class="Address" />
</set>
</class>
 
<class name="Address" table="address">
<composite-id>
<key-property name="addressId" column="address_id" />
<key-property name="employeeId" column="employee_id" />
</composite-id>
<property name="city" />
<property name="state" />
</class>
 
public static void main( String[] args ) {
 
    Session session = HibernateUtil.getSession();
    Transaction tx = session.beginTransaction();
 
    Address address = new Address();
    address.setAddressId( 1111 );
    address.setEmployeeId( 2222 );
    address.setCity( "MyCity" );
    address.setState( "MyState" );
    Set addresses = new HashSet();
    addresses.add( address );
 
    Employee employee = new Employee();
    employee.setEmployeeId( 2222 );
    employee.setName( "myname" );
    employee.setSalary( 99999 );
    employee.setAddresses( addresses );
 
    session.save( employee ); // successful
    //session.save( address ); // fails with constraint violation if save(employee) commented
 
    tx.commit();
    HibernateUtil.closeSession();
}

[ March 07, 2007: Message edited by: David Madouros ]

[raj baig]

hi David,

I did as you showed.

       my.pack.Address addr=new my.pack.Address();
addr.setAddId(1007);
addr.setEmpId(2005);
addr.setCity("mycity");
addr.setState("mystate");
Set addrSet=new HashSet();
addrSet.add(addr);
 
        my.pack.Employee emp=new my.pack.Employee();
emp.setEmpId(2005);
emp.setEmpName("myname");
emp.setEmpSal(30000);
emp.setAddress(addrSet);
session.save(emp);
tx.commit();
 
       

But it is working fine when we load the data .
problam occurs when we insert the data . it is giving constraint
violation exception.