Embedding a database into a Java web start application

Thread view:

Dobedani - 12 Sep 2006 15:43 GMT

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

Reply to this Message

Ian Wilson - 12 Sep 2006 16:07 GMT

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

Reply to this Message

David Segall - 12 Sep 2006 16:16 GMT

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

Reply to this Message

Dobedani - 13 Sep 2006 08:53 GMT

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

Reply to this Message

IchBin - 12 Sep 2006 17:22 GMT

> Dear All,
>
[quoted text clipped - 11 lines]
> Kind regards,
> Dobedani

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

Signature

Thanks in Advance...
IchBin, Pocono Lake, Pa, USA http://weconsultants.phpnet.us
'If there is one, Knowledge is the "Fountain of Youth"'
-William E. Taylor, Regular Guy (1952-)

Reply to this Message

Embedding a database into a Java web start application

Free Magazines