Is it possible to have a embedded database in a web application?

Is it possible to have a embedded database in a small web application? What I need is there should开发者_JAVA技巧 not be any need to install any database in the server machine. By just adding a jar in the folder the database should work.

I am using Java EE, and Netbeans as my IDE. If its possible, what are the open source databases that can be embedded.

Any pointers to some good tutorials will be more helpfull.

HSQLDB, a popular embedded database, is just one jar file that you can drop in your application.

SQLite is the big one. MySQL has an embedded server, but you need to purchase a commercial license for it. Firebird also has an embedded server which it's free.

I haven't tried that but thinking about it, I think you can. I have worked with HSQLDB before and all I had to do was to run the embedded db and then run my client. You can do this by creating a cmd script in Windows or .sh script in Linux.

Some embedded databases:

H2

HSQLDB

Java DB