aspose file tools*
The moose likes JDBC 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
Bookmark "Looking for DB advice" Watch "Looking for DB advice" New topic
Author

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

Thanks,


Regards, Dave Brown
SCJP 6 - [url]http://www.dbws.net/[/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
Author
Ranch Hand

Joined: Jul 08, 2004
Posts: 531

Hi
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 http://incubator.apache.org/derby/index.html 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 http://www.daffodildb.com/ 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: http://aspose.com/file-tools
 
subject: Looking for DB advice