2013/6/20 Lukas Eder <[email protected]> > Hi Tim, > > 2013/6/19 <[email protected]> > > 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. >> > > So, in order to get an oracle.sql.CLOB type, I suspect that you have used > "plain SQL" to generate your query? > > ResultQuery<Record> q = // setup a query with plain SQL? > > That case indeed isn't covered by integration tests, which it should. I > have registered #2534 for this: > https://github.com/jOOQ/jOOQ/issues/2534 > > Given the fact that jOOQ currently doesn't expose actual LOB types, this > is probably a bug. I'll have to see how this could be fixed. > > 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) ? >> > > Yes, that's a good idea, too. In fact, this check could be made very > early. I have registered #2535 for this: > https://github.com/jOOQ/jOOQ/issues/2535 >
#2535 is implemented in Github master and will be available in the next 3.1.0-SNAPSHOT, today: https://oss.sonatype.org/content/repositories/snapshots/org/jooq/ Cheers Lukas > > > >> 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. >> > > Absolutely! Thanks for reporting > > Cheers > Lukas > -- 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.
