HSQL: follow-up

It appears that sometimes one would like to use lightweight HSQL for unit / integration testing of his (hers) Spring-aware application. Nothing simpler ;-)
First thing is preparing Spring bean able to manage lifecycle of an instance of the HSQL database. This could be written by hand, but fortunately convenient class is already available in the Springmodules project. Bean implementation is to be found here.
Second thing is Spring XML configuration of the bean. My sample code is as follows:

  <bean id="dataSource"
    class="org.apache.commons.dbcp.BasicDataSource" 
    destroy-method="close">
    <property name="driverClassName" 
              value="org.hsqldb.jdbcDriver"/>
    <property name="url" 
              value="jdbc:hsqldb:hsql://localhost/test"/>
    <property name="username" value="sa"/>
    <property name="password" value=""/>
    <property name="defaultAutoCommit" value="true"/>
  </bean>

  <bean id="dataBase" 
    class="springmodules.HsqlServerBean"
    singleton="true" lazy-init="false">
    <property name="dataSource">
      <ref bean="dataSource"/>
    </property>
    <property name="serverProperties">
      <props>
        <prop key="server.port">9001</prop>
        <prop key="server.database.0">
          file:webapps/SampleApp/db/test</prop>
        <prop key="server.dbname.0">test</prop>
      </props>
    </property>
  </bean>

Configuration is pretty straight-forward. Note that we're using DataSource referring to the database configuration. This is done because:
a) Spring bean requires DataSource to commence db shutdown when container goes down
b) helps encapsulating database properties in one entity
The latter can be used more when Hibernate is also in the game. SessionFactory can be configured to use the DataSource with such code as:

  <bean id="sessionFactoryBean" class=
  "org.springframework.orm.hibernate3.LocalSessionFactoryBean">
    <property name="configLocation" 
                 value="classpath:hibernate.cfg.xml"/>
    <property name="dataSource" >
      <ref bean="dataSource"/>
    </property>
  </bean>

Have fun!