File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Looking for DB advice Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Looking for DB advice" Watch "Looking for DB advice" New topic

Looking for DB advice

Dave Brown
Ranch Hand

Joined: Mar 08, 2005
Posts: 301
Hi all,

Looking for some advice on which DB to use. I'm used to writing J2EE
apps with MySQL using sqlyog as my sql gui but i want to embark on
developing a desktop app which will need to have its own 'local' database.

I havent really a clue on how to use this, one of my aims is to make
this project an easily installable application as, 'fingers crossed' it
will be sold as an off the shelf product, therefor will also be
installed using either WISE or Installshield.

Its a shame MySQL dont do a free, Oh yeah thats the other requirement,
I'm hoping to find an opensource DB, well something that I wont have to
fork out for licenses anyway. its a shame Mysql dont offer a standalone
db format with a set of classes to access it as i like using MySQL
products so far.

Well if anyone has any suggestions or recommendations, advice is greatly


Regards, Dave Brown
SCJP 6 - [url][/url] - Check out Grails Forum
Steven Bell
Ranch Hand

Joined: Dec 29, 2004
Posts: 1071
It sounds like hsqldb would be a good fit for you, although I've never really used it myself.
Masoud Kalali
Ranch Hand

Joined: Jul 08, 2004
Posts: 531

I did not exactly get what you need.
If you are looking for A pure Java DB server in OSS then check out for
Derby it is Apache licensed and very capable . It has an embeded version which make it possible to use the db features with out any pain of installation.

also has a free version of thier Pure Java database . but i did not check it yet

hope it helps

Masoud Kalali
Software Engineer - My Weblog - GlassFish Security
I agree. Here's the link:
subject: Looking for DB advice
It's not a secret anymore!