Hi all...

I'm looking for an MS Access equivalent database solution for my Java
application.  My equivalent I mean the database is contained in a
single file, i.e. mdb file (where I can distribute the application
with the single MDB for the application to work).  It should support
SQL and all the rest of it, but no fancy stuff like triggers are
needed.

The reason I don't use Access mdb itself is because the internals of
Access can change between Office versions (like the one between Access
95 and Access 97/2000), and I don't want the situation where I
suddenly find myself with a database that's outdated and
un-upgradable.

If there isn't a direct equivalent, what database would you recommend
for an application that runs in a client PC (no client-server
mumbo-jumbo here) that requires data that is stored in a database.

In my research I've looked at HSQLDB.  I've just downloaded it and
haven't evaluated it yet to see if it fits my requirements.

Thanks in advance for any help you can give!

Donny