On Wed, Apr 21, 2010 at 4:00 PM, Knut Anders Hatlen <[email protected]> wrote: > 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 > >
OK, I guess I could look into that and see what I can make of it. Thanks for helping me out. -- George H [email protected]
