Hi,

I will get a set of data from one table (select based on condition and having as list) and need to insert the data into another table.

What is the best approach for doing this.

Example:

Table A

ID GrpId Name Age
1 21 Test 22
2 21 Test1 23

Select from the above table A and insert into table B

ID GrpId Name Age
3 22 Test 22
4 22 Test1 23

GrpId will be changed at runtime insert.

I'm trying this by getting a list and insert record one by one. Hibernate mapping can be done for this? Please help me.