Use Derby for an application which runs on CD?

[sarah.kho]

Hi
Thank you for reading my post.
I am looking to use Derby database as the data repository for my application which Runs on CD. (ReadOnly). The application has 5 tables and all data are stored into the database during the software development.

I am wondering whether it is possible to use Derby as ReadOnly and in-memory database to ensure the fastest possible running time.

Thanks.

[francois.orsini]

Hi Sarah,

Yes, you can have a Derby database as part of a ZIP / JAR archive and access it in read-only mode.

More information below:
http://db.apache.org/derby/docs/dev/devguide/devguide-single.html#cdevdeploy15325

In-Memory Derby storage is experimental in 10.5.x - Here you can read some documentation primer about it:
http://wiki.apache.org/db-derby/InMemoryBackEndPrimer

You can create / load an in-memory database from a backup, see Knut Anders's blog entry for more information:
http://blogs.sun.com/kah/entry/derby_10_5_preview_in

Hope this helps

--francois

On Wed, Sep 16, 2009 at 11:24 AM, sarah.kho <sarah.kho@...> wrote:

Hi
Thank you for reading my post.
I am looking to use Derby database as the data repository for my application
which Runs on CD. (ReadOnly). The application has 5 tables and all data are
stored into the database during the software development.

I am wondering whether it is possible to use Derby as ReadOnly and in-memory
database to ensure the fastest possible running time.

Thanks.


--
View this message in context: http://www.nabble.com/Use-Derby-for-an-application-which-runs-on-CD--tp25477845p25477845.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.

[Rick Hillegas-2]

Hi Sarah,

It should be possible to use Derby the way you describe (in-memory,
faulted-in from disk). Right now you need to use backup and restore to
snapshot and re-instantiate an in-memory database. Making this easier to
do is on our list of possible enhancements for the next feature release,
10.6.

Hope this helps,
-Rick

sarah.kho wrote:

> Hi
> Thank you for reading my post.
> I am looking to use Derby database as the data repository for my application
> which Runs on CD. (ReadOnly). The application has 5 tables and all data are
> stored into the database during the software development.
>
> I am wondering whether it is possible to use Derby as ReadOnly and in-memory
> database to ensure the fastest possible running time.
>
> Thanks.
>
>
>