Problem reading CLOB values from Oracle

[mbknor]

I try to map an Oracle CLOB column to a String.
Sql2o called toString on the Clob-object and gets a string ala "com.oracle.Clob@6756767".

I worked around the problem like this:

    private static class ClobConverter extends StringConverter {
        @Override
        public String convert(Object o) {
            if ( o instanceof Clob) {
                Clob clob = (Clob)o;
                try {
                    return clob.getSubString(1, (int)clob.length());
                } catch (SQLException e) {
                    throw new RuntimeException("Error reading clob-value", e);
                }
            } else {
                return super.convert(o);
            }
        }
    }

and

Convert.registerConverter(String.class, new ClobConverter());