File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/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


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
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
 
Similar Threads
Making schema changes to an Application
How to store data in an application which will be distributed
rescuing database from MySql data folder
how can find mysql database address?
How Do You Determine a Closed Socket?