db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jim Murphy <jim.mur...@pobox.com>
Subject Re: Trying to "update from" - Derby 10.1
Date Sun, 13 Jan 2008 19:27:56 GMT

I support 5 different DB types and each have a single script file that
performs each version's migration.  Our product is pretty widely available
and deployed - for dev tools.  For architectural simplicity I was hoping to
stay with this pattern.  I run the script s part of my application -  if the
user chooses to do an inplace upgrade. But for militant, enterprise DBAs the
app can just provide the scripts that they can inspect and run on their own. 
If there is custom code it dirties up this process.

As it turns out I'm written this "manual" blob creator but its the first
time I've had to do it - and I don't like doing it.

Thanks for the help.


Bryan Pendleton wrote:
>> My last problem is converting varchars to blob records.  Anyone have any
>> insights?
> I'm afraid I don't have a lot of experience working with blobs, but is it
> workable for you to write a Java program to perform this task? If so, it
> seems like you should be able to:
>   - select the varchar data into a Java string using JDBC.
>   - create a CLOB object in Java using the string data
>   - set the CLOB object into your database using JDBC.
> I think you can find lots of blob/clob example programs in the Derby
> source tree, in the "java/testing" subdirectory.
> thanks,
> bryan

View this message in context: http://www.nabble.com/Trying-to-%22update-from%22---Derby-10.1-tp14778557p14789878.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.

View raw message