Embedding a database into a Java web start application

[Dobedani]

Dear All,

Can anybody tell me how difficult it would be to embed a relational
database with a small footprint to my stanalone Java application. I
intend to distribute the app by means of Java Web Start. I'm not so
bothered about the availability of drivers and / or the programming of
the database queries. I am rather worried that it may be difficult to
get Java Web Start to install the database correctly and to start it
without the user knowing it. Should I expect permission problems? I
have ever messed around with the McKoi database. Would that be a
suitable DBMS for my purpose? Or would you recommend the Berkeley DB
Java edition formerly produced by SleepyCat - now owned by Oracle? TIA

Kind regards,
Dobedani

 

[Ian Wilson]

Dear All,

Can anybody tell me how difficult it would be to embed a relational
database with a small footprint to my stanalone Java application.

On a scale of 1 to 10: 2 for someone relatively new to Java like me.
Apache Derby (IBM Cloudscape) or any of several similar products are
designed to be used this way.

See
http://java.sun.com/developer/technicalArticles/J2SE/Desktop/javadb

I
intend to distribute the app by means of Java Web Start. I'm not so
bothered about the availability of drivers and / or the programming of
the database queries. I am rather worried that it may be difficult to
get Java Web Start to install the database correctly and to start it
without the user knowing it.

A single-user embedded database doesn't need starting does it? In the
case of Derby you need to include one derby jar file in your install.

The above URL has a section on "Deploying your application".

Should I expect permission problems?

I find it is always best to expect problems

I
have ever messed around with the McKoi database. Would that be a
suitable DBMS for my purpose? Or would you recommend the Berkeley DB
Java edition formerly produced by SleepyCat - now owned by Oracle? TIA

No idea, sorry. I use Derby.

 

[David Segall]

Dear All,

Can anybody tell me how difficult it would be to embed a relational
database with a small footprint to my stanalone Java application. I
intend to distribute the app by means of Java Web Start.

Apache Derby <http://db.apache.org/derby/> a.k.a. IBM Cloudscape
<http://www-306.ibm.com/software/data/cloudscape/> a.k.a. Sun Java DB
<http://developers.sun.com/prodtech/javadb> is intended for this
purpose. You can include the jar in your application and run it within
the same JVM.

 

[IchBin]

Dear All,

Can anybody tell me how difficult it would be to embed a relational
database with a small footprint to my stanalone Java application. I
intend to distribute the app by means of Java Web Start. I'm not so
bothered about the availability of drivers and / or the programming of
the database queries. I am rather worried that it may be difficult to
get Java Web Start to install the database correctly and to start it
without the user knowing it. Should I expect permission problems? I
have ever messed around with the McKoi database. Would that be a
suitable DBMS for my purpose? Or would you recommend the Berkeley DB
Java edition formerly produced by SleepyCat - now owned by Oracle? TIA

Kind regards,
Dobedani

I would look at HSQLDB.
http://www.hsqldb.org

 

[Dobedani]

Hi David, Ian and IchBin,

Thanks for all the replies. I've had a look at the Derby database as
well as at the HSQLDB webpages. Could not find information whether it
is easy to deploy the HSQLDB database with Java Web Start. The
derby.jar is just over 2MB large but the hsqldb.jar only about 325 kB.
Any further contribution will be appreciated.

Kind regards,
Dobedani