When attempting to display CLOB results in an Oracle
test, I am getting an unsupported datatype error.
After chasing this one for a while, I found that the code
to get the MD5 string representation for a CLOB
(SqlTypeUtils.convertToString()) is calling:
This call throws a SqlException (using the Oracle "thin"
jdbc driver), which is displayed as an unsupported
The javadoc for the java.sql.clob class specifies that the
start position should be 1-based, not 0-based. If I
change this to:
the error goes away and everything works as expected.
From code inspection it appears that the code for BLOBs
has the same issue, but I have not tested this yet.