Introduction

S2HsqldbServer is a S2 component ot start hsqldb database server when Seaser2 starts.

Requirements

S2HsqldbServer requires the followings:

S2	hsqldb
2.1.11 or later	1.7.3 or later

Download

S2Hsqldb may be downloaded from here.

Installation

S2 and Hsqldb must be installed before using S2Hsqldb. Hsqldb should be setup as follows:

Extract files from downloaded archive file to some directory.
Export/Import extracted hsqldb directory to the project directory (where development will be done).
In the following explanation, Hsqldb directory will be
referenced by %DBDATA_PATH%, and database name will be referenced by %DBDATA_NAME%.

After installing these software, S2Hsqldb is installed as follows:

Extract files from downloaded archive file to some directory.
Move the file s2-hsqldbserver-x.x.x.jar that was extracted from the archive file to a directory where CLASSPATH is set.
Add s2-hsqldbserver-x.x.x.jar to the CLASSPATH.

Usage

To use S2Hsqldb, following 3 files must be modified:

hsql.dicon
app.dicon
j2ee.dicon

Modifying hsql.dicon file

Modify hsql.dicon file included in the zip archive file as follows:

hsql.dicon

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE components PUBLIC "-//SEASAR2.1//DTD S2Container//EN"
    "http://www.seasar.org/dtd/components21.dtd">

<components namespace="S2HsqldbServer">
  <component name="xaDataSource" class="org.seasar.server.hsqldb.HsqldbServerImpl">
    <!-- Modify database property replacing %DBDATA_PATH% and %DBDATA_NAME%
         with the actual values -->
    <property name="database">"%DBDATA_PATH%/%DBDATA_NAME"</property>
    <property name="dbname">"dbname"</property> <- This row may be deleted
    <property name="port">9001</property>
    <property name="silent">false</property>
    <property name="trace">false</property>
    <property name="tls">false</property>

    <property name="user">"sa"</property>
    <property name="password">""</property>

    <initMethod    name="start" />
    <destroyMethod name="stop">
      <arg>@org.seasar.server.hsqldb.HsqldbServer@SHUTDOWN_MODE_COMPACT</arg>
    </destroyMethod>
  </component>
</components>

Move this hsql.dicon file to some directory. This directory will be reference as %DICON_PATH%.

Modifying app.dicon file

Modify app.dicon file as follows replacing %DICON_PATH% with the actual directory of where hsql.dicon is located.

app.dicon

<components>
    ...
    <include path="%DICON_PATH$/hsql.dicon"/>
</components>

Modifying j2ee.dicon file

Deploy your application. If you are using Tomcat, start Tomcat. When S2
starts, dicon files will be read in app.dicon, hsql.dicon order.

Modify the j2ee.dicon file to set database connection information.

j2ee.dicon

    <component name="xaDataSource"
        class="org.seasar.extension.dbcp.impl.XADataSourceImpl">
        <property name="driverClassName">
            "org.hsqldb.jdbcDriver"
        </property>
        <property name="URL">
            "jdbc:hsqldb:hsql://localhost:9001"
        </property>
        <property name="user">"sa"</property>
        <property name="password">""</property>
    </component>

Trans. by H.Ozawa