Hello, thanks for your quick reply.
I just do: Result<Record> records = context.select(<list of fields>).from(DOCUMENTSTABLE).where(DOCUMENTSTABLE.IDELEMENT.eq(filters.getElementId())).fetch(); And then I read the field's values with record.getValue(DOCUMENTSTABLE.<tablefield>) for every field. The problem there was, that the returned value of the BLOB (bytea) field was much larger than when writing the data. I write and read it as byte array. It turned out that the content of the read byte array was made of hex numbers (in text format) instead of bytes containing the original data. Maybe there is a way to detect the returned type of data for postgres' 'bytea' datatype from version 9 on. Greetings Mike -- 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 [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
