Upgrade to hsql v2 as embedded test db to support CLOB datatypes

The currently used version of hsql, v1.8.3, doesn't support CLOB types that 
makes it hard to write automated integration tests for integrations that use 
JDBC endpoints based on tables with CLOB-columns. 

v2 of hsql added support for CLOB-columns so we should upgrade to v2 to support 
CLOB columns in automated integration tests.

Initial tests however revealed problems with input-stream already closed when 
trying out the CLOB support while running the standard tests involving a 
jdbc-endpoint.

To upgrade to hsql v2 simply modify the pom.xml to:

        <dependency>
            <groupId>org.soitoolkit.commons.poms</groupId>
            <artifactId>soitoolkit-test-dependencies</artifactId>
            <version>${soitoolkit.version}</version>
            <type>pom</type>
            <scope>test</scope>
            <exclusions>
                <exclusion>
                    <groupId>hsqldb</groupId>
                    <artifactId>hsqldb</artifactId>
                </exclusion>
            </exclusions>
        </dependency>

        <dependency>
            <groupId>org.hsqldb</groupId>
            <artifactId>hsqldb</artifactId>
            <version>2.2.9</version>
            <scope>test</scope>
        </dependency>

In the end soitoolkit-test-dependencies/pom.xml should be updated to use hsql 
v2.

Original issue reported on code.google.com by magnus.l...@gmail.com on 30 Dec 2012 at 7:40

soi-toolkit / soi-toolkit-google-code

Upgrade to hsql v2 as embedded test db to support CLOB datatypes #321