Hi Aym, 2013/10/30 <[email protected]>
> Hi, > > Just started playing with Jooq, looks really good!. > Thanks for the feedback! > One question though, I'm trying to insert a movieRecord to table with id > (autogenerated) using DSLContext().executeInsert(). > But it throws exception "Caused by: org.postgresql.util.PSQLException: > ERROR: null value in column "id" violates not-null constraint" > > But if I attach configuration to movieRecord and fire movieRecord.store() > it works. > > Any reason why executeInsert() behaves differently? > There has been some confusion recently around this subject with respect to jOOQ's handling NULL values and the changed flag. Most of it was discussed in this interesting thread: https://groups.google.com/d/msg/jooq-user/8MBETRVrLCM/oAt9hbE6kY4J Can you provide some code showing how to produce the error with executeInsert() ? I don't think that should happen, unless you actually set the ID value to NULL. Cheers Lukas -- 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/groups/opt_out.
