Status/Resolution/Reason: Closed/Withdrawn/
Reporter/Name(from Bugbase): Wim Dewijngaert / Wim Dewijngaert (Wimpie)
Created: 07/29/2011
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
Problem:
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?
Method:
<cfquery datasource="myh2db" name="qry" maxrows="1">select picture from mydatabase where id = 1</cfquery>
Result:
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/2011Attachments:
Comments: