On 04/21/10 10:17 AM, George H wrote: > Thanks for the extra info. I guess I am still stuck. I have then > another question, how does one insert large BLOBs (ie., 1MB size) into > derby just from the IJ console? I know we "shouldn't" compare derby > to mysql but with mysql I can insert bytes into a BLOB column by > forming a very very very long SQL insert statement and just place the > bytes in there or put them in hex format. Doesn't derby have a > facility to do something like this? or is a prepared statement the > only way to go about this? >
I don't think there is a way to do this from IJ. Except, perhaps, if you could live with reading the contents of the BLOB from a file with the import procedures (http://db.apache.org/derby/docs/10.5/tools/ctoolsimport16245.html). -- Knut Anders