On Sep 13, 3:30 pm, Lukas Eder <[email protected]> wrote: > > I guess calling store() and refresh() manually opens the door to race > > conditions again, while a storeAndRefresh() > > implementation that uses 'RETURNING ...' can guarantee that the > > returned values are indeed the ones that were inserted. > > Hmm, but then again. To be 100% sure, jOOQ would need to use an UPDATE > .. RETURNING clause, too. I'm not sure if this sort of construct is > supported by any RDBMS, or by JDBC's generated keys functionality...?
I don't know about the other RDBMS, but UPDATE .. RETURNING is supported by Postgres.
