Use Derby for an application which runs on CD?

["sarah.kho" <sa...@gmail.com>]

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.

Re: Use Derby for an application which runs on CD?

[Rick Hillegas <Ri...@Sun.COM>]

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.
>
>
>   

Re: Use Derby for an application which runs on CD?

[Francois Orsini <fr...@gmail.com>]

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 <sa...@gmail.com> 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.
>
>