> http://dev.mysql.com/doc/refman/5.0/en/innodb-locking-reads.html > > As I can see they are missing, but when working with transactions, > they are really needed. How do I make them?
Good point. As for now, these kinds of clauses are not yet supported. I will schedule an improvement in a future release: https://sourceforge.net/apps/trac/jooq/ticket/420 In the mean time, I think you will have to fall back to a workaround. Either you can try to use a plain SQL object (admittedly, not a very nice workaround), or you create a wrapper for Select<?>, adding the additional SQL at the end.
