> Last but least is it possible to cast a select directly to a ClassRecord? > IE > > PostRecord post = create.select.from(POST).fetchOne()
It will work in this particular case, as you're selecting all columns from a single table. But this alternative API is more reliable: PostRecord post = create.selectFrom(POST).fetchOne(); Note the relevant section in the manual: http://www.jooq.org/doc/2.6/manual/sql-building/sql-statements/select-statement/#N1070B Cheers Lukas
