File based database in Java

Question

Are there any libraries create programs in java that uses a file as a database and you don't have to install database services on the computer you are going to use it?

Answer 1

there is a very good java binding for SQLite databases called SqliteJDBC:

http://www.zentus.com/sqlitejdbc/

Answer 2

We are successfully using http://www.sqlite.org/ along with http://www.zentus.com/sqlitejdbc/ as JDBC driver.

Answer 3

Derby and Hypersonic SQL can both be run in memory and server modes.

Answer 4

For example HSQLDB or Apache Derby can run in Embedded mode.

Answer 5

Derby can run in the Embedded mode as mentioned above. It actually is included in Java 6 SE and called Java DB instead (although it is really just Apache Derby). It is quite easy to use, although the default database tool (ij) isn't great. I would use something like SQuirreL SQL to view the data.

Answer 6

Besides the already mentioned embedded relational databases, there are also non-relational embedded Java databases like exist (an XML DB) or db4o (an object DB).

Answer 7

What about H2?

H2 is a relational database management system written in Java. It can be embedded in Java applications or run in the client-server mode. The disk footprint (size of the jar file) is about 1 MB. (Wikipedia)