Looking for DB advice

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,

It sounds like hsqldb would be a good fit for you, although I've never really used it myself.

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