Insert multiple rows in Jooq throws compilation error

Question

I have a table called VARS that has two columns VAR_NAME and VAR_TYPE. I also have a list of POJOs to insert in this table. The POJO class is called Var and has two fields called varName and varType.

Note that the fields match so Jooq can derive and apply in the insert.

When I try to insert the list of Vars, I get a compilation error:

    InsertSetStep insert = create.insertInto(VARS);

    for (Var var: vars) {
        VarsRecord rec = new VarsRecord();
        rec.from(var);
        insert.set(rec);
    }

    insert.execute();   // <-- error here

The error:

The method execute() is undefined for the type InsertSetStep

How to run this insert?
What should be used instead of InsertSetStep?
Should I excecute an insertInto for each row?

user_521799 · Answer

Try to avoid the historic mutability of the DSL API as it might change in the next major release. Use DSLContext.batchInsert(Collection) instead:

List list = new ArrayList<>(vars.size());
for (Var var : vars) {
    VarsRecord rec = new VarsRecord();
    rec.from(var);
    list.add(rec);
}
create.batchInsert(list).execute();

Insert multiple rows in Jooq throws compilation error

1 Answers