Hi,
there is something I don't understand, with the whole blob stuff in torque: I tried
defining a BLOB column, which has correctly created the column in my database. But the
problems start as soon as I try to save a record: Torque relies on Village, which
incurs in a JDK bug related to the way oracle answers to the ResultsetMetaData method
getPrecision(): since the size of a BLOB may be 4Gb, the Integer.parseInt method
explodes and throws a NumberFormatException. The same does NOT happen with LONG as it
allows "only" 2Gb of data.
Well, just to try, I patched village and caused it to swallow the
NumberFormatException, answering Integer.MAX_VALUE to the getPosition. I wanted to see
how the blob management is done but... it seems there is no blob management at all! If
I have correctly understood what happens, loading a 128 Kb image, and putting it in a
blob column does not work as expected: after some working, the save method just takes
the byte array and uses it to create a string, which is then put into the db with a
default:
stmt.setString (stmtNumber, this.asString());
break;
where stmt is a prepared statement which has a ? for the picture column. Well, at this
point Oracle complains about the size of the picture, which exceeds a maximum:
actually, Oracle documentation states that in order to work with blobs and clobs one
has to use streaming, so trying to use setXXX methods is useless, and Oracle BLOB
support in Torque is not really working. Am I wrong?
