Hibernate [Electronic resources] : A Developers Notebook نسخه متنی

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 HypersonicSQL,
this is its current incarnation. Much of the Hibernate documentation
uses the older name.)

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 is 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
hsqldb.sourceforge.net
):

hsqldb is a relational database engine written in Java, with a JDBC
driver, supporting a rich subset of ANSI-92 SQL (BNF tree format). It
offers a small (less than 160k), fast database engine which offers both
in memory and disk based tables. Embedded and server modes are
available. Additionally, it includes tools such as a minimal web server,
in-memory query and management tools (can be run as applets), and a
number of demonstration examples.

NOTE

Go on, download
HSQLDB. Heck, take two, they're small!

1.2.2 How do I do that?

Getting the database is simply a matter of visiting the project page at

hsqldb.sourceforge.net
and clicking the link to download the current stable version. This will take you to a typical SourceForge downloads
page with the current release highlighted. Pick your mirror and
download the zip archive. There's nothing to install or configure; we'll
show you how to use it shortly.

1.2.3 What about...

...MySQL, PostgreSQL, Oracle, DB2, Sybase, Informix, or some other common
database? Don't worry, Hibernate can work with all these and others.
We'll talk about how you specify 'dialects' for different databases
later on. And if you really want, you can try to figure out how to work
with your favorite from the start, but it will mean extra work for you in
following along with the examples, and you'll miss out on a great opportunity
to discover HSQLDB.