One To Many BidirectionalMapping

[vivek dhiman]

Hi

I have an issue in the below code in bidirectional mapping. As i am new in hibernate so not exactly knows where i am wrong.
My first class file is as below: Customer2.java

package Bi;

public class Customer2
{
	private int customerId;
    private String customerName;
    private int forevenId;
    private Vendor2 parentObjets;
 
    public Vendor2 getParentObjets() {
        return parentObjets;
    }
    public void setParentObjets(Vendor2 parentObjets) {
        this.parentObjets = parentObjets;
    }
    public int getCustomerId() {
        return customerId;
    }
    public void setCustomerId(int customerId) {
        this.customerId = customerId;
    }
    public String getCustomerName() {
        return customerName;
    }
    public void setCustomerName(String customerName) {
        this.customerName = customerName;
    }
 
    public int getForevenId() {
        return forevenId;
    }
    public void setForevenId(int forevenId) {
        this.forevenId = forevenId;
    }

}

Vendor2.java

package Bi;

import java.util.Set;

public class Vendor2
{
	private int vendorId;
    private String vendorName;
    private Set children;
 
    public int getVendorId() {
        return vendorId;
    }
    public void setVendorId(int vendorId) {
        this.vendorId = vendorId;
    }
    public String getVendorName() {
        return vendorName;
    }
    public void setVendorName(String vendorName) {
        this.vendorName = vendorName;
    }
    public Set getChildren() {
        return children;
    }
    public void setChildren(Set children) {
        this.children = children;
    }

}

Customer2 Mapping File

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated Oct 20, 2012 7:32:30 PM by Hibernate Tools 3.4.0.CR1 -->
<hibernate-mapping>
    <class name="Bi.Customer2" table="CUSTOMER2">
        <id name="forevenId" type="int">
            <column name="FOREVENID" />
            <generator class="assigned" />
        </id>
        <property name="customerId" type="int">
            <column name="CUSTOMERID" />
        </property>
        <property name="customerName" type="java.lang.String">
            <column name="CUSTOMERNAME" />
        </property>
        <many-to-one name="parentObjets" class="Bi.Vendor2" fetch="join">
            <column name="VENDORID" />
        </many-to-one>
    </class>
</hibernate-mapping>

Vendor2 Mapping File

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated Oct 20, 2012 7:32:30 PM by Hibernate Tools 3.4.0.CR1 -->
<hibernate-mapping>
    <class name="Bi.Vendor2" table="VENDOR2">
        <id name="vendorId" type="int">
            <column name="VENDORID" />
            <generator class="assigned" />
        </id>
        <property name="vendorName" type="java.lang.String">
            <column name="VENDORNAME" />
        </property>
        <set name="children" table="VENDOR2" inverse="true" lazy="true">
            <key>
                <column name="CHILDREN" />
            </key>
            <one-to-many class="Bi.Customer2"/>
        </set>
    </class>
</hibernate-mapping>

My Logic File is :

package Bi;

import java.util.*;

import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
import org.hibernate.service.ServiceRegistry;
import org.hibernate.service.ServiceRegistryBuilder;

public class OtMBi 
{
	private static SessionFactory sessionFactory;
	private static ServiceRegistry serviceRegistry;

	public static void main(String args[])
	{
	Session session = null;
		
			try
			{
	Configuration cfg= new Configuration().configure("hibernate.cfg.xml");
	serviceRegistry = new ServiceRegistryBuilder().applySettings(cfg.getProperties()).buildServiceRegistry();
	sessionFactory = cfg.buildSessionFactory(serviceRegistry);
			
		
	session = sessionFactory.openSession();
	Vendor2 v =new Vendor2();
	 
    v.setVendorId(101);
    v.setVendorName("java4s");

    Customer2 c1=new Customer2();

     c1.setCustomerId(504);
     c1.setCustomerName("customer4");

     Customer2 c2=new Customer2();

     c2.setCustomerId(505);
     c2.setCustomerName("customer5");           

     Customer2 c3=new Customer2();

     c3.setCustomerId(506);
     c3.setCustomerName("customer6");

     // one-to-many
     Set s=new HashSet();

        s.add(c1);
        s.add(c2);
        s.add(c3);              

      v.setChildren(s);

      // many-to-one          

      c1.setParentObjets(v);
      c2.setParentObjets(v);
      c3.setParentObjets(v);

      Transaction tx = session.beginTransaction();

                      session.save(c1);
              //session.save(v);

tx.commit();


System.out.println("One To Many Bi-Directional is Done..!!");
	}
catch(Exception th)
{
	th.printStackTrace();
	
}
			finally
			{
			session.close();
			sessionFactory.close();
			}
}
}

Exception that i am getting

INFO: HHH000232: Schema update complete
Hibernate: select vendor2x_.VENDORID, vendor2x_.VENDORNAME as VENDORNAME9_ from public.VENDOR2 vendor2x_ where vendor2x_.VENDORID=?
Hibernate: insert into public.CUSTOMER2 (CUSTOMERID, CUSTOMERNAME, VENDORID, FOREVENID) values (?, ?, ?, ?)
Hibernate: update public.CUSTOMER2 set CUSTOMERID=?, CUSTOMERNAME=?, VENDORID=? where FOREVENID=?
Oct 20, 2012 8:14:04 PM org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions
WARN: SQL Error: 0, SQLState: 23503
Oct 20, 2012 8:14:04 PM org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions
ERROR: ERROR: insert or update on table "customer2" violates foreign key constraint "fk6268c146f6fdda6"
  Detail: Key (vendorid)=(101) is not present in table "vendor2".
org.hibernate.exception.ConstraintViolationException: ERROR: insert or update on table "customer2" violates foreign key constraint "fk6268c146f6fdda6"
  Detail: Key (vendorid)=(101) is not present in table "vendor2".
	at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:128)
	at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)
	at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:129)
	at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81)
	at $Proxy5.executeUpdate(Unknown Source)
	at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:56)
	at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3016)
	at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2918)
	at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3247)
	at org.hibernate.action.internal.EntityUpdateAction.execute(EntityUpdateAction.java:140)
	at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:362)
	at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:354)
	at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:276)
	at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:326)
	at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:52)
	at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1214)
	at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:403)
	at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.beforeTransactionCommit(JdbcTransaction.java:101)
	at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.commit(AbstractTransactionImpl.java:175)
	at Bi.OtMBi.main(OtMBi.java:69)
Caused by: org.postgresql.util.PSQLException: ERROR: insert or update on table "customer2" violates foreign key constraint "fk6268c146f6fdda6"
  Detail: Key (vendorid)=(101) is not present in table "vendor2".
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:304)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:601)
	at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:122)
	... 17 more

Thanks.

[Bill Gorder]

Vivek,

You have marked this topic as resolved. Was that intentional? If not let me know and I can fix it for you. People are less likely to comment on posts that are marked as resolved.

[vivek dhiman]

Thanks Bill for reply. I spent some time and found the mistake that was in my vendor2 mapping file. The there was wrong field in key tag.
Now its working.