Hi,

In the Hibernate,I am aware that, to insert data in foreign key in the table,
first we have to make the object of primary key table, then we can use that object as foriegn key for inserting data in another table.

but the problem is that, if i want to insert the 1 million record at a time, then each time i should first create the object of primary key table.
so the 1 million primary key table's objects are created.

so, is there any way to aviod of creating 1 million primary key table's objects for inserting 1 million records in foreign key table?

Happy Coding!! :-)

I don't really get your problem. Why will you insert data into a table just because it is referenced by a different table.

Lets say A.fid references B.id

But if you think that for a row in A its not related to any rows of B then in A just keep the foreign key column null.

Also its not required that each row in A should have a corresponding row in B. If the relation is many to one then one row in B can be referenced by all the rows in A. So if you want to insert 1 million rec in A then you dont have to insert 1 million records in B.

Hi littypreethkr,

I think you are not understanding my problem.
I am not trying to insert the record in both primary and foreign key table.

my problem is like this:

for example:

my TblB pojo is like this:

public String name;
public date sDate;
public com.example.TblA tblA;

Public TblB(com.example.TblA tblA,String name,String sDate){
this.tblA = tblA;
this.name = name;
this.sDate = sDate;
}


now in HibernateDao Class....

TblA tblA = (TblA) hibernateTemplate.get(bean.getId());
TblB tblB = new TblB(tblA,"Information", new Date());
hibernateTemplate.save(tblB);

now here TblA has a primary key named as 'Id'.
TblB has a foreign key name 'id' with many to one relationship.

now if i want to insert 1 million record in TblB, for that i should first create the object of TblA.
so that the object of TblA is also created 1 million times.

So Is there any way so that i can remove that dependency?

If the foreign key field is a null-able column then you can do this this:



Otherwise as the relation is a many to one, you can relate an existing TblA object to the new TblB records which you create.