The simplest Java SQL provider?

Question

I need SQL functionalities for a Java JSE application, but dont need a whole SQL server, with things like listen on a port, connection string or even a standalone process to be runned or configured.

I also would prefer to work with files as storages, so that file path identifies DB data.

So given to the DB API the name of a file, I would need perform SQL with the file as DB storage, supporting tables, search, joins and inserts, without thinking to things like ports, external processes, server installation, ecc.. Without any other configurration action, since any other configurable feature is not needed.

Is there some library, preferrably installable as single .jar, that provides this functionality?

If there is not this library, which file-based DB is the simplest to configure and use within JSE, and which configuration steps are needed to perform a query in the provided DB and deploy it with (working) the java .jar application?

Answer 1

I suggest Derby db.apache.org/derby/

Answer 2

I have used HSQLDB in the past and liked it. Depending on what your needs are, you might also be interested in JoSQL which allows you to do SQL type of queries on java collections.

Answer 3

Sure, Hypersonic SQL or Derby, the database that comes bundled with Java 7, will both fill the bill. SQLite would be a third alternative.

Answer 4

I like H2 Database very much. It compares very well with other database engines.

Answer 5

you may want to check this out:

http://www.sqlite.org/