I really love in-memory databases like H2, which you can embed in your Java application. They are great for testing your SQL scripts and running unit tests that need a database.

However, H2 is not the only DB, you also have Apache Derby and HSQL to choose from.