Hi,
The problem is that ColdFusion tries to read from the Clob after the
result set has been closed. I can reproduce the problem:
ResultSet rs = stat.executeQuery("select * from test");
rs.next();
Clob c = (Clob) rs.getClob(2);
while(rs.next());
String s = c.getSubString(1, 20000);
H2 doesn't print a nice error message; the error message of Apache
Derby is better:
"You cannot invoke other java.sql.Clob/java.sql.Blob methods after
calling the free() method or after the Blob/Clob's transaction has
been committed or rolled back."
So, I'm afraid there is nothing I can do to solve the problem. It
doesn't look like a bug in H2; it looks like ColdFusion doesn't follow
the JDBC spec here. Maybe the problem is fixed in a newer version of
ColdFusion (if it is really ColdFusion that is calling those methods)?
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.
