I am a new user to JOOQ but have a question about retrieving BLOB and CLOB
columns (I understand that there is not full support for LOBs, and that's
fine)
When I query a table with a CLOB column
ResultQuery<Record> q = // setup a query
for (Result<Record> r : q.fetch()) {
java.sql.Clob c = r.getValue("CLOB_COLUMN", java.sql.Clob.class);
}
I get an error telling me that oracle.sql.CLOB cannot be converted to
java.sql.Clob. But oracle.sql.CLOB implements java.sql.Clob.
In the ConvertAll class if after all the checks have been performed before
failing the conversion could you check if the two types are compatible with
Class.isAssignableFrom(Class) ?
I can just retrieve the value as an Object for the time being and cast it
myself to java.sql.Clob but feels like the conversion system should handle
this case for me.
Thanks,
Tim
--
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.
