db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "[SAS] Justin Swall" <JSw...@swallservices.com>
Subject RE: Opening/Converting a Derby Embedded DB with the Derby Network Server
Date Sun, 28 Mar 2010 21:50:04 GMT
I figured out my first problem.  The version of the LOB we are currently
using is one subversion older than the new version I am doing my testing
on.  The old version of the software used HSQL and the new version uses
Derby so what I actually have is an old HSQL DB.  I'm going to install
the old version on my test system, attach the HSQL DB, then do an
in-place upgrade to the latest subversion as it should update the DB as
part of the upgrade.  Hopefully once upgraded I'll be able to figure out
how to attach it to the network server without incident.  I'll keep this
thread updated as I know more.

Justin Swall 
Swall's Associated Services

-----Original Message-----
From: [SAS] Justin Swall [mailto:JSwall@swallservices.com] 
Sent: Sunday, March 28, 2010 2:22 PM
To: derby-user@db.apache.org
Subject: Opening/Converting a Derby Embedded DB with the Derby Network

I have an LOB application that uses a Derby Embedded DB (Openbravo POS @
sourceforge.net).  Their application does support using the network
server however so I spent some time over my weekend running some tests
with a copy of the app, installing the JDK & Derby and seeing if I can
get it talking to the network server instead of the embedded server.  So
far so good, I was able to get it to connect to the network server and
create a new DB and it is now successfully working off the new DB.

My question is I currently have a copy of the embedded DB files (the
.script and .properties files).  How can I get the data out of this
embedded DB and over into a DB that can be mounted with the Network
Server?  Is there some way to just directly mount this existing DB in
the network server or does it need to be converted?  

I'm certain that this is a pretty basic question but I swear I've
googled and searched the mailing list archives and so far can't figure
out what to do so I'm looking to the experts for help.

Thanks in advance.

Justin Swall
Swall's Associated Services

View raw message