Thomas,
This is very strange. Coldfusion has no problems at all with BLOBS
from Derby, SQL server, Oracle, and ALL other databases.. ONLY with
H2. ColdFusion uses JDBC for its database communication. I'm using the
latest Java runtime, and the latest version of ColdFusion with all
patched applied.
Wim
Thomas Mueller schreef:
> 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.
