JavaMuse

Unit-testing Hibernate with HsqlDB

The Motivation

I've used lots of methods to transform data between databases and object code. From hand-coded SQL to JDO to EJB. I've never found a method I liked particularly well. This distaste has become especially acute since adopting test-driven development (TDD) as a guiding philosophy.

Unit-testing should have as few barriers as possible. For relational databases those barriers range from external dependencies (is the database running?) to speed to keeping the relational schema synchronized with your object model. For these reasons it is vital to keep database access code away from the core object model and to test as much as possible without touching a real database.

This has often led me to one of two patterns. The first is externalizing all data access to domain objects and their relationships to separate classes or interfaces. These are typically data store objects that can retrieve, edit, delete and add domain entities. This is the easiest to mock-out for unit-testing, but tends to leave your domain model objects as data-only objects with little or no related behavior. Ideally access to child records would be directly from the parent object rather than handing the parent object to some third-party class to determine the children.

The other method has been to have the domain objects have access to an interface into the data-mapping layer a la Martin Fowler’s Data Mapper pattern. This has the advantage of pushing object relationships inside the domain model where the object-relational interface can be expressed once. Classes that use the domain model are unaware of the persistence mechanism because it is internalized into the domain model itself. This keeps your code focused on the business problem you are trying to solve and less about the object-relational mapping mechanism.

My current project involves crunching a number of baseball statistics and running simulations with the data. Since the data was already in a relational database it was a chance for me to explore the Hibernate object-relational mapping system. I have been very impressed with Hibernate, but I ran into the problem was trying to insert a layer of indirection while using Hibernate as my data mapper for unit-testing. The extra layer was so flimsy that it felt embarrassing to write it. The real deployed version was simply a pass-through to a Hibernate-specific implementation. Even worse, the mock versions had more complexity in them than the real "production" version simply because they didn't have some of the basic object storage and mapping that came with Hibernate.

I also had enough complex Hibernate query usage that I wanted to unit-test this significat portion of the application. However, testing against a ‘live’ database is a bad idea, because it almost invariably introduces a maintenance nightmare. In addition, since tests are best when they are independent from each other, using the same obvious primary keys in test fixture data means you have to create code to clean the database before each test case, which is a real problem when lots of relationships are involved

By using HSQLDB and Hibernate's powerful schema-generation tool I was able to unit-test the mapping layer of the application and find numerous bugs in my object queries I would not have found as easily by manual testing. With the techniques outlines below I was able unit-test my entire application during development with no compromises in test coverage.

Setting up HSQLDB

I used version 1.7.3.0 of HSQLDB. To use an in-memory version of the database you need to invoke the static loader for the org.hsqldb.jdbcDriver. Then when you get a JDBC connection you use JDBC url such as jdbc:hsqldb:mem:yourdb where 'yourdb' is the name of the in-memory database you want to use.

Since I'm using Hibernate (3.0 beta 4), I hardly ever need to touch real-live JDBC objects. Instead I can let Hibernate do the heavy lifting for me--including automatically creating the database schema from my Hibernate mapping files. Since Hibernate creates its own connection pool it will automatically load the HSQLDB JDBC driver based on the configuration code lives in a class called TestSchema. Below is the static initializer for the class.

Hibernate provides a number of different ways to configure the framework, including programmatic configuration. The code above sets up the connection pool. Note that the user name 'sa' is required to use HSQLDB's in-memory database. Also be sure to specify a blank as the password. To enable Hibernate's automatic schema generation set the hibernate.hbm2ddl.auto property to 'create-drop'.

Testing In Practice

My project is crunching a bunch of baseball statistics so I add the four classes that I'm mapping ( Player, PitchingStint, BattingStint and FieldingStint). Finally I create a Hibernate SessionFactory and insert it into the HibernateUtil class which simply provides a single access method for my entire application for Hibernate sessions. The code for the HibernateUtil is below:

Since all of my code (production code as well as unit-tests) get their Hibernate sessions from the HibernateUtil I can configure it in one place. For unit-tests the first bit of code to access the TestSchema class will invoke the static initializer which will setup Hibernate and inject the test SessionFactory into the HibernateUtil. For production code the SessionFactory will be initialized lazily using the standard hibernate.cfg.xml configuration mechanism.

So what does this look like in the unit-tests? Below is a snippet of a test that checks the the logic for determining what positions a player is eligible to play at for a fantasy baseball league:

One of the most important things in unit-testing is to keep your test-cases isolated. Since this method still involves a database, you need a way to clean your database prior to each test case. I have four tables in my schema so I wrote a reset() method on the TestSchema that removes all rows from the tables using JDBC. Note because HSQLDB knows about foreign keys, the order in which the tables are deleted is important. Here is the code:

When bulk deletes become finalized in Hibernate 3.0 we should able to remove this last bit of direct JDBC from our application. Until then we have to get a Connection and issue direct SQL to the database.

Be sure not to close your Connection, closing the Session is sufficient for resource cleanup. Out of habits developed from writing lots of hand-crafted JDBC code, the first version closed the JDBC Connection. Since I configured Hibernate to create a connection pool with only one Connection I completely torpedoed any tests after the first one.Be sure to watch out for this!

Since you can never be sure what state the database may be in when your test class is running (imagine running all of your test cases), you should include database cleanup in your setUp() methods like so:

Conclusion

Being able to test against a real-live RDBMS without all of the hassles of trying to run tests against your deployed database is essential, even when working with sophisticated O/R mappers like Hibernate. The example I showed here is not exclusive to Hibernate and could probably be made to work with JDO or TopLink, though Hibernate makes this kind of testing particularly easy since it has a built-in schema generation tool. With a setup like the one described above you don't ever have to leave the comfort of your IDE and still have extensive test coverage over your code.

posted @ 2007-03-13 14:05 滿山紅葉 閱讀(432) | 評(píng)論 (0) | 編輯 收藏

HSQLDB文檔

				jdbc:hsqldb:c:\db\test 
		

				jdbc:hsqldb:http://websrv
		

				jdbc:hsqldb:. 
		

				c1=DriverManager.getConnection("jdbc:hsqldb:.","sa",""); 
		

				c2=DriverManager.getConnection("jdbc:hsqldb:test","sa","");
		

				c3=DriverManager.getConnection("jdbc:hsqldb:http://dbserver","sa",""); 
		

				c4=DriverManager.getConnection("jdbc:hsqldb:hsql://dbserver","sa","");
		

posted @ 2007-03-13 14:01 滿山紅葉 閱讀(356) | 評(píng)論 (0) | 編輯 收藏

vimtutor 亂碼

posted @ 2007-02-28 19:06 滿山紅葉 閱讀(258) | 評(píng)論 (0) | 編輯 收藏

ubuntu 6.10 edgy 安裝與配置

posted @ 2007-02-17 14:34 滿山紅葉 閱讀(715) | 評(píng)論 (16) | 編輯 收藏

Hello,World in Hibernate 入門

本文介紹如何用hibernate寫一個(gè)hello world 程序，以及說明Hibernate下的對(duì)象的識(shí)別。
1、配置文件hibernate.cfg.xml：

<? xml?version = ' 1.0 ' ?encoding = ' utf-8 ' ?>
<! DOCTYPE?hibernate - configuration?PUBLIC
???????? " -//Hibernate/Hibernate?Configuration?DTD?3.0//EN "
???????? " http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd " >

< hibernate - configuration >

???? < session - factory >

???????? <!-- ?Database?connection?settings? -->
???????? < property?name = " connection.driver_class " > com.mysql.jdbc.Driver </ property >
???????? < property?name = " connection.url " > jdbc:mysql: // localhost:3306/eg</property>
???????? < property?name = " connection.username " > root </ property >
???????? < property?name = " connection.password " > 4864452 </ property >

???????? <!-- ?JDBC?connection?pool?(use?the?built - in)? -->
???????? < property?name = " connection.pool_size " > 1 </ property >

???????? <!-- ?SQL?dialect? -->
???????? < property?name = " dialect " > org.hibernate.dialect.MySQLInnoDBDialect </ property >

???????? <!-- ?Enable?Hibernate ' s?automatic?session?context?management?-->
???????? < property?name = " current_session_context_class " > thread </ property >

???????? <!-- ?Disable?the?second - level?cache?? -->
???????? < property?name = " cache.provider_class " > org.hibernate.cache.NoCacheProvider </ property >

???????? <!-- ?Echo?all?executed?SQL?to?stdout? -->
???????? < property?name = " show_sql " > true </ property >

???????? <!-- ?Drop?and?re - create?the?database?schema?on?startup?
???????? < property?name = " hbm2ddl.auto " > create </ property >
????????? -->
????
???????? < mapping?resource = " eg/Message.hbm.xml " />
????????
????????
???? </ session - factory >

</ hibernate - configuration >

2、源文件：

package ?eg;

public ? class ?Message? {
???? private ?Long?id;
???? private ?String?text;
?????????????
???? private ?Message?nextMessage;

???? public ?Message()? {}
???? public ?Message(String?text) {
???????? this .text = text;
????}
????
???? public ? void ?setId(Long?id)? {
???????? this .id? = ?id;?
????}

???? public ? void ?setText(String?text)? {
???????? this .text? = ?text;?
????}

???? public ? void ?setNextMessage(Message?nextMessage)? {
???????? this .nextMessage? = ?nextMessage;?
????}
??????? public ?Long?getId()? {
???????? return ?( this .id);?
????}
??????? public ?String?getText()? {
???????? return ?( this .text);?
????}
??????? public ?Message?getNextMessage()? {
???????? return ?( this .nextMessage);?
????} ?
}

3、配置文件：Messsage.hbm.xml

<? xml?version = " 1.0 " ?encoding = " utf-8 " ?>

<! DOCTYPE?hibernate - mapping?PUBLIC
???? " -//Hibernate/Hibernate?Mapping?DTD?3.0//EN " ?
???? " http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd " >

< hibernate - mapping >
???? < class
????????name =" eg.Message "
????????table = " MESSAGE "
???? >

???????? < id
????????????name = " id "
????????????column = " MESSAGE_ID "
????????????type = " java.lang.Long "
???????? >
???????????? < generator? class = " native " />
?????????????????????????
???????? </ id >
???????? < property
????????????name = " text "
????????????type = " java.lang.String "
????????????update = " true "
????????????insert = " true "
????????????column = " MESSAGE_TEXT "
???????? />

???????? < many - to - one
????????????name = " nextMessage "
???????????? class = " jmuse.eg.Message "
????????????cascade = " all "
????????????outer - join = " auto "
????????????update = " true "
????????????insert = " true "
????????????column = " NEXT_MESSAGE_ID "
???????? />

?????? </ class >

</ hibernate - mapping >

4、最后的包結(jié)構(gòu)：

+ lib?
?????antlr.jar?
?????cglib.jar?
?????asm.jar?
?????asm - attrs.jars?
?????commons - collections.jar?
?????commons - logging.jar?
?????hibernate3.jar?
?????jta.jar?
?????dom4j.jar?
?????log4j.jar?
＋src?
???? + eg
???????Message.java
???????Message.hbm.xml
???????TestMessage.java
?????hibernate.cfg.ml
?????log4j.properties

5、測(cè)試：

?session.beginTransaction();
????????Message?m = new ?Message( " hello,world " );
????????session.save(m);
????????session.getTransaction().commit();
????????session.close();

?你會(huì)發(fā)現(xiàn)在數(shù)據(jù)庫(kù)中有一條信息了，id=1
Hibernate的對(duì)象識(shí)別是通過對(duì)象的Id 來識(shí)別的：
如：

我們剛才在數(shù)據(jù)庫(kù)中保存了一個(gè)Id為1的Message對(duì)象。
如果：
session.beginTraction();
Message?m = new ?Message();
m.setId( new ?Long( 1 ));
m.setText( " This?is?another?greeting " );
session.saveOrUpdate(m);
sesion.getTraction.commit();

posted @ 2007-02-10 17:42 滿山紅葉 閱讀(575) | 評(píng)論 (0) | 編輯 收藏

對(duì)象的存儲(chǔ)和關(guān)系型數(shù)據(jù)庫(kù)

ORM 的原則是將一個(gè)類映射到一張表上，然而對(duì)象和關(guān)系型數(shù)據(jù)庫(kù)之間有一點(diǎn)的差異。
對(duì)象和對(duì)象之間的關(guān)系有一對(duì)一，一對(duì)多，多對(duì)多。這三個(gè)關(guān)系的關(guān)系的存儲(chǔ)是有差異的。
1、一對(duì)一：我們可以用兩張表分別表示兩個(gè)類。他們之間的關(guān)系我們可以用主關(guān)鍵字或者外關(guān)鍵字來表示。然而這里有一個(gè)粒度的問題(The problem of granularity )。關(guān)于粒度問題見第4點(diǎn)。
2、一對(duì)多：我們也可以用兩張表來表示兩個(gè)類。他們的關(guān)系我們可以用外鍵來關(guān)聯(lián)。
3、多對(duì)多：我們可以用兩張表來表示這兩個(gè)類。用第三張表來表示他們之間的關(guān)系。
4、關(guān)于問題的粒度：
??????如：一個(gè)用戶和一個(gè)地址之間的關(guān)系。當(dāng)然我們可以用一對(duì)一的方法來解決。
然而這樣是否合理？也許最好的方法是在數(shù)據(jù)庫(kù)中增加一個(gè)新的數(shù)據(jù)類型Address(country state city zipcode etc.)。這樣我們就很容易把這個(gè)粒度問題解決了。不幸的是，數(shù)據(jù)庫(kù)是不允許自定義類型的（也許現(xiàn)在的數(shù)據(jù)庫(kù)可以，鄙人不太清楚，呵呵）。Hibernate 對(duì)這個(gè)問題有了很好的解決。見以后的文章。
5、對(duì)象之間可以有繼承的關(guān)系，這是數(shù)據(jù)庫(kù)望洋興嘆的。Hibernate 對(duì)這個(gè)問題有了很好的解決。見以后的文章。
6、對(duì)象的身份識(shí)別問題。
??? 大家都知道，java中的對(duì)象識(shí)別是用equals()和haseCode()來實(shí)現(xiàn)。
???舉例：

package ?jmuse.eg;
/**?*/ /**
?*@hibernate.class?table="MESSAGE"
?*
? */

public ? class ?Message? {
???? private ?Long?id;
???? private ?String?text;
???? private ?String?string;
???? public ? void ?setString(String?s) {
????????string = s;
????}
???? /**?*/ /**
?????*@hibernate.property?
?????*
????? */
????? public ?String?getString() {
???????? return ? this .string;
????}
????
???? private ?Message?nextMessage;
???? public ?Message()? {}
???? public ?Message(String?text) {
???????? this .text = text;
????}
????
???? public ? void ?setId(Long?id)? {
???????? this .id? = ?id;?
????}

???? public ? void ?setText(String?text)? {
???????? this .text? = ?text;?
????}

???? public ? void ?setNextMessage(Message?nextMessage)? {
???????? this .nextMessage? = ?nextMessage;?
????}
???? /**?*/ /**
?????*@hibernate.id?column="MESSAGE_ID"?generator-class="native"
?????*
????? */
???? public ?Long?getId()? {
???????? return ?( this .id);?
????}
???? /**?*/ /**
?????*@hibernate.property?column="MESSAGE_TEXT"
?????*
????? */
???? public ?String?getText()? {
???????? return ?( this .text);?
????}
???? /**?*/ /**
?????*@hibernate.many-to-one?column="NEXT_MESSAGE_ID"?cascade="all"
?????*
????? */
???? public ?Message?getNextMessage()? {
???????? return ?( this .nextMessage);?
????}
}

這樣的類由于沒有實(shí)現(xiàn)equals()和haseCode()，所以如果用下面的代碼我們可以看到如下輸出：

Message?m1 = new ?Message("Hello");
Message?m2 = new ?Message("Hello");
if (!(m2.equals(m1)) )log.info( " m1?and?m2?are?not?idential " );
else ?log.info( " m1?and?m2?are?identical " );

////////////// /out?put //////////////
m1?and?m2?are?not?idential

但是我們加上如下代碼：

? public ? boolean ?equals(Object?o) {
???????? if ( this == o)? return ? true ;
???????? if ( ! (o? instanceof ?Message))?
???????????????? return ? false ;
???????? final ?Message?m = (Message)o;
???????? return ? this .getText().equals(m.getText());
????}
???? public ? int ?hashCode() {
???????? // return?text==null?System.identityHashCode(this):text.hashCode();
???????? int ?hase = 20 ;
????????
???????? return ? 20 * hase + getText().hashCode();
????}

//////////// out?put //////////// /
m1?and?m2?are?identical

這就是java的對(duì)象識(shí)別。如果你將修改后的Message對(duì)象加入到j(luò)ava.util.Set中，不管你加多少，最后size()仍然為1。
?那么hibernate中的對(duì)象識(shí)別如何呢？見以后文章。呵呵。

?

posted @ 2007-02-10 14:44 滿山紅葉 閱讀(653) | 評(píng)論 (0) | 編輯 收藏