Commented by: Roman Rokytskyy (rrokytskyy)

It is correct re. how to call the underlying FBBlob instance, but the result you get will not be precise - the average chars per byte won't work with UTF-8. That is the reason why I did not implement the method.

Commented by: Sebastian Bösl (sboesl)

I see.
For the purpose of hibernate it's not necessary to be precise since the value is only used as a hint for the buffer size, so even a constant value would have worked for me.
The reason I opened this issue was that I would prefer an official solution for the sake of future updates.
So if the issue will be handled in the 2.3 version I won't mind if you close this ticket

Commented by: @mrotteveel

JDBC does not require this method to be implemented: http://docs.oracle.com/javase/7/docs/api/java/sql/Clob.html#length() :
SQLFeatureNotSupportedException - if the JDBC driver does not support this method. FBDriverNotCapableException extends SQLFeatureNotSupportedException (in the Java 6 and 7 version of Jaybird).

Maybe there are other drivers out there that do the same, so maybe it is wise to handle the exception generically

Commented by: Pablo León (palevi)

This is also causing problems with Mybatis 3.4.x (3.3.x and previous where working ok):

Error querying database. Cause: org.apache.ibatis.executor.result.ResultMapException: Error attempting to get column 'DIRECCION' from result set. Cause: org.firebirdsql.jdbc.FBDriverNotCapableException: Cannot determine length for CLOB

Commented by: @mrotteveel

Unfortunately it is impossible to do this correctly with UTF8 (without reading the entire blob). And as this is an optional JDBC method, you'll need to ask MyBatis if they really need this method.

More curiously though, Jaybird handles a BLOB SUB_TYPE TEXT primarily as a longvarchar, and java.sql.Clob is actually just supported as a fallback; however according to https://github.com/mybatis/mybatis-3/blob/master/src/main/java/org/apache/ibatis/type/TypeHandlerRegistry.java#L91 the LONGVARCHAR handling is mapped to ClobTypeHandler, instead of the StringTypeHandler or maybe the ClobReaderTypeHandler.

The ClobTypeHandler (https://github.com/mybatis/mybatis-3/blob/master/src/main/java/org/apache/ibatis/type/ClobTypeHandler.java) obtains a string using:

public String getNullableResult(ResultSet rs, int columnIndex)
throws SQLException {
String value = "";
Clob clob = rs.getClob(columnIndex);
if (clob != null) {
int size = (int) clob.length();
value = clob.getSubString(1, size);
}
return value;
}

The workaround is to configure an alternative type handler (eg the StringTypeHandler).