1.2. Getting the HSQLDB Database Engine
Hibernate works with a great many relational databases; chances are, it will work with the one you are planning to use for your next project. We need to pick one to focus on in our examples, and luckily there's an obvious choice. The free, open source, 100% Java HSQLDB project is powerful enough that it forms the backing storage for several of our commercial software projects. Surprisingly, it's also incredibly self-contained and simple to install, so it's perfect to discuss here. (If you've heard of Hypersonic SQL, this is its current incarnation. Much of the Hibernate documentation uses the older name.)
Tip:
Don't panic if you end up at http://hsql.sourceforge.net/ and it seems like the project has been shutdown. That's the wrong address—it's talking about the predecessor to the current HSQLDB project. Use the address below to find the current version of the database engine.
1.2.1. Why do I care?
Examples based on a database that everyone can download and easily experiment with mean you won't have to translate any of the SQL dialects or operating system commands to work with your available databases (and may even mean you can save a day or two learning how to download, install, and configure one of the more typical database environments). Finally, if hsqldb i new to you, chances are good you'll be impressed and intrigued, and may well end up using it in your own projects. As it says on the project home page (at http://hsqldb.sourceforge.net ...