Revision history [back]

To retrieve all the results as a single Java record in JOOQ, you can use the fetchOne() method with a RecordMapper.

Here is an example query:

Record record = context.select().from(TABLE_NAME)
    .where(condition)
    .fetchOne(new RecordMapper<Record, Record>() {
        @Override
        public Record map(Record record) {
            return record;
        }
    });

In the above example, TABLE_NAME and condition are placeholders for the name of the database table and any conditions you want to apply to the query.

The RecordMapper is used to map the result set to a single Java record. In this case, we are simply returning the entire Record.

The fetchOne() method is used to retrieve the single result as a Record object. If multiple results are returned, only the first row is returned. If no results are returned, a null value is returned.