jOOQ: Exclude column in update

user_1362485 0
Viewed 679

In this code I update a BOOKS row, trying not to set null the value of column TITLE because in myPojo is null and I don't want to override it (i.e. I attempt to exclude the column from the update):

        BooksRecord rec = new BooksRecord();
        rec.from(myPojo);               
        context.update(BOOKS)
           .set(rec)
           .set(BOOKS.TITLE, BOOKS.TITLE)
           .where(BOOKS.SK.eq(sk))
           .execute();

But this doesn't work, the TITLE column is set with null. Is there a way to make this work?

jooq jdbc java
1 Answers

Do it like this:

BooksRecord rec = new BooksRecord();
rec.from(myPojo);
rec.reset(BOOKS.TITLE);
rec.update();

The call to Record.reset(Field) resets the field's underlying Record.changed() flag prior to any further action, such as Record.update(), or when you copy the record's changed values into an Update statement like you did.

user_5217990
Related