I have a collection of tuples that need to be inserted into a table as new records.
I was trying to create a List of TableRecord objects built off of these Tuples via MYTABLE.newRecord() and then insert them with batchInsert(), but the fields I am not setting are getting sent to Postgres 9.6 as NULL instead of DEFAULT which causes a constraint violation. I tried calling record.setValue(MYTABLE.ACOLUMN, DSL.defaultValue(MYTABLE.ACOLUMN)), but that gives a compile error that the type for T can't be determined. I am currently trying to switch to using insertInto().columns(<just the ones I have>) and then looping over the records to build a series of .values() calls, but it seems like I have to pull the values out of the records manually since .values() doesn't have a form that takes a TableRecord object. What am I doing wrong here? -Daniel -- 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.
