1.2 get the HSQLDB database engine
Hibernate can work with a large number of relational databases, bringing opportunities to work with the database you plan to use in the next project. We need to pick out a look at our example, fortunately, this has a great choice. Free, open source, 100% Java's HSQLDB project is strong enough to be able to store the background storage of several of our business software projects. Surprisingly, it is incredible, and it is quite simple, so it is perfect for what we discussed. (If you have heard Hypersonicsql, HSQLDB is its current form. Most Hibernate documents use the original name.)
If you see hsql.sourceforge.net/ Don't feel panic, it seems that this project seems to have been closed. That is a wrong address - this is an address about the predecessor of the current HSQLDB project. Use the address mentioned below to find the current version of this database engine.
1.2.1
Why do I want it?
Databases that will be downloaded based on everyone can download and it is easy to experience, meaning that you don't have to translate any SQL Tsi and operating system commands because you can use the database yourself (and may also mean you can save one or two Time to learn how to download, install, and configure one of those typical database environments). Finally, if you are a HSQLDB newbie, this is an impression that you may have a deep impression, then use it to use it into your own project. Just like this project's home page (home page is hsqldb.sourceforge.net):
HSQLDB is a relational database engine written with Java, including JDBC drivers, a sufficient subset of ANSI-92 SQL (BNF). It provides a small (less than 160K), fast-based data engine based on memory and disk tables. Embedded and server patterns are available. And it also includes many tools such as: a minimal web server, internal query, and management tools (can be run as an applet run) and a large number of sample programs.
prompt:
Continue, download HSQLDB. Well, download two, anyway, they are small.
1.2.2
what should I do?
Getting a database is just some project sites such as access to HSQLDB.SourceForge.net, click on the current stable version of the link to download these things. These steps will guide you to a typical SourceForge download page, and the current version will highlight. Select a mirror and download the ZIP file. Without any installation and configuration, you will give you how to use it.
1.2.3
on...
... mysql, postgreSQL, Oracle, DB2, Sybase, Informix, other normal databases? Don't worry, Hibernate can work with all of these or other databases. We will discuss how to specify "dialects" for different databases. If you really want, you can try your most pleasant database at the beginning, but you will make some extra work when you follow these examples, and you will miss the excellent opportunity to discover HSQLDB.
