2015-09-18 0:21 GMT+02:00 Aner Perez <[email protected]>: > > You are right, I must have been running the wrong code when I ran my > original test. I just retested with bulkAll() and I get an error now which > is not surprising since it would be a single insert statement with 80,000 > rows! > > Caused by: java.io.IOException: Tried to send an out-of-range integer as > a 2-byte value: 1764906 > > Seems like the JDBC request has to be under 64K :-) >
Ah, yes, true. There are various limitations like that. There's also a maximum number of bind variables in many databases... > bulkAfter() is what we needed and it is working great, thanks! > Great, thank you for your feedback! -- 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.
