Hi,

So you have used ResultSet.getClob(...).toString()? This isn't the
correct way to get the content. For most databases, this will return
the object identifier (for Apache Derby, you will get
"org.apache.derby.impl.jdbc.EmbedClob@530d0eae", for HSQLDB, you will
get "org.hsqldb.jdbc.JDBCClobClient@331c89c"). H2 tries to return
something useful for small objects (the content), but escaped. For
large objects, only a placeholder is returned.

Use ResultSet.getString(...) instead, or (as you did)
clob.getSubString((long)1, (int)(clob.length()).

Regards,
Thomas

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/h2-database?hl=en.

Reply via email to