Need a database compact edition (FREE)

[PhpLover1984]

Hello,

Which dbms (compact and free) do you advice me to use with my first Java desktop single user database application, with supporting standard SQL, and which I can install with my exe application without any changings on the computer settings (windows or unix/linux).

Thank u for the answer in advance

[JosAH]

Java 1.6 comes with its own small relational database management system (also completely written in Java). It's Derby from the Apache project, renamed by Sun to JavaDB. It comes bundled with your distribution (including all documentation).

kind regards,

Jos

[cmdr]

I think SQLite(http://sqlite.org) is the best.
For a JDBC driver look at: http://www.zentus.com/sqlitejdbc/

By the way, Mozilla Firefox is using it too
in order to store internal urls history, etc

[PhpLover1984]

I am going to use netbeans for developing my small application. Which choice is the right one for me? JavaDB of SQLite?

Thank you/ dank u. :)

[JosAH]

@PhpLover1984
Netbeans doesn't have anything to do with a database management choice; JavaDB is already installed on your disk if you have the JDK 1.6 installed; maybe SQLLite is a better choice; maybe not.

kind regards,

Jos

[PhpLover1984]

@JosAH
I know what you mean. I asked if I can use netbeans as a tool to handle the administration of JavaDB.

[JosAH]

@PhpLover1984
There hardly is any administration; you can create schemas and tables and views etc. You can grant or revoke rights to/from users. All can be done through simple data definition statements. There are a few tools that come with the package but I haven't used them at all. Read the documentation; it possibly is installed on your hard disk already.

kind regards,

Jos