How to insert List<Object> to database using hibernate without Iterate?

Question

I have a List which are include 'Job' Entities. So I need to insert to database that List as a batch without iterating. what is the best way to do that?

@Override
@Transactional(propagation = Propagation.REQUIRED, rollbackFor = Exception.class)
public JobResult save(JobDTO dto) throws Exception {

    JobResult result = new JobResult(new Job(), dto);
    try {
        JobMapper.getInstance().dtoToDomain(result.getDtoEntity(), result.getDomainEntity());
        setBatchJobData(result);
        result.addToMessageList("Jobs Added Successfully.");
        result.updateDtoIdAndVersion();
    } catch (Exception ex) {
        ex.printStackTrace();
        result.setResultStatusError();
        result.addToErrorList(ex.getMessage());
    }
    return result;

}

private void setBatchJobData(JobResult result) throws Exception{
    List<Job> jobs = new ArrayList<>();
    for (Integer scheduleTaskId : result.getDtoEntity().getScheduleTaskIds()) {
        Job job = new Job();
        AgreementScheduleTask agreementScheduleTask = agreementScheduleTaskDao.findOne(scheduleTaskId);
        setJobData(job, agreementScheduleTask);
        setAssets(job, agreementScheduleTask);
        jobs.add(job);
    }   

}

You want a solution that iterate for you ? Because at some point that list need to be iterated.. — AxelH
– AxelH, Commented Aug 31, 2017 at 9:37

maya16 · Accepted Answer · 2017-08-31 10:15:47Z

2

If you are using spring,

use map instead of List. Map<String, Job> jobs = new HashMap<>();
Add the Jobs to the Map.
save at one go : jobRepository.save(jobs)

answered Aug 31, 2017 at 10:15

maya16

6432 gold badges7 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to insert List<Object> to database using hibernate without Iterate?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related