OK, interesting. If that's really all there is to it, a workaround would be to simply batch the insert and not use the stored procedure at all. Ideally, you'd be using the import API that I've mentioned earlier: https://www.jooq.org/doc/latest/manual/sql-execution/importing
It allows for fine-tuning bulk / batch / commit sizes 2017-11-09 17:21 GMT+01:00 <[email protected]>: > SQL procedure looks like this: > > PROCEDURE MainSchema.insertPerson(inName varchar(50), inSurname > varchar(50)) > BEGIN > insert into Persons (Name, Surname, LogTime) > values (inName, inSurname, NOW()); > > #there's auto-increment id as well, not important for this example > > END > > -- > You received this message because you are subscribed to the Google Groups > "jOOQ User Group" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
