Hello, jOOQ supports all sorts of SQL expressions, including MAX() and +. Here's how:
DSL.max(col).add(1) Do note, however, that this works only if you're the only process accessing the table concurrently. If you want to prevent race conditions on generated IDs, better use sequences, identity columns, auto_increment columns, or something similar. Hope this helps, Lukas 2016-09-14 13:44 GMT+02:00 BTJ <bt.johan...@gmail.com>: > I have a table that has a column that uses max(col) + 1 as it's value when > doing an insert. Is there a way for JOOQ to support this, without actually > writing my own sql statement for insert for this table? > > > Regards, > > BTJ > > -- > 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 jooq-user+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- 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 jooq-user+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
