tracker issue : CF-3043921

select a category, or use search below
(searches all categories and all time range)

Bug 86998:When using a H2 JDBC database, BLOBS cannot be read

| View in Tracker

Status/Resolution/Reason: Closed/Withdrawn/

Reporter/Name(from Bugbase): Wim Dewijngaert / Wim Dewijngaert (Wimpie)

Created: 07/29/2011

Components: Database, General

Versions: 9.0.1

Failure Type: Unspecified

Found In Build/Fixed In Build: 0000 /

Priority/Frequency: Trivial / Unknown

Locale/System: English / Win All

Vote Count: 0


When using a H2 JDBC database, BLOBS cannot be read. As soon as you do a select with a BLOB in the result, a "file not found" error appears.I've contacted H2 support about this, and they said the full error was "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." . It looks like ColdFusion doesn't follow the JDBC spec here., according to the H2 support people. Can you please fix this?

<cfquery datasource="myh2db" name="qry" maxrows="1">select picture from mydatabase where id = 1</cfquery>

File not found: "C:/Windows/Temp/h2.temp.d73926d6138df934.6.temp.db"

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	3043921

External Customer Info:
External Company:  
External Customer Name: Wim Dewijngaert
External Customer Email: 1BA46E1644AB735B992016B7
External Test Config: 07/29/2011