db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From dmclea...@comcast.net
Subject Re: SQL for inserting BLOB data?
Date Wed, 29 Nov 2006 13:09:19 GMT
In the meantime, you should be able to use the String function "getByte()" (with the appropriate

character coding if necessary) and then use a SerialBlob - new 
SerialBlob(byte[]).

Donald


 -------------- Original message ----------------------
From: "Andrew McIntyre" <mcintyre.a@gmail.com>
> On 11/28/06, Ray Kiddy <kiddyr@apple.com> wrote:
> >
> > If one is writing SQL to create tables and insert
> > data and one has a BLOB column, how can
> > one do this?
> 
> There is not currently a way to do this with just SQL. However, there
> is an open JIRA for similar functionality and there has been some
> discussion around it. See:
> 
> http://issues.apache.org/jira/browse/DERBY-378
> 
> http://mail-archives.apache.org/mod_mbox/db-derby-dev/200610.mbox/%3c45410499.80
> 8@gmail.com%3e
> 
> Note that from the discussion, the functionality that would be
> provided would be a procedure to load the contents of a BLOB from a
> file.

Mime
View raw message