Spring 中使用 HSQLDB

在spring的配置文件spring.xml中添加xmlns:jdbc， 申明hsqldb数据源创建hsqldb数据库，使用jdbc:initialize-database指明初始化数据库的sql脚本。

hsqldb2之后提供了对不同数据库语法的支持，例如使用可以通过sql.syntax_ora=true使hsqldb支持oracle语法。

 

hsqldb的connection URL 按照下面表格中的规范定义

 Memory Database URL

Driver and Protocol	Host and Port Example	Database Example
jdbc:hsqldb:mem:	not available	accounts

 

例子：spring.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
    xmlns:beans="http://www.springframework.org/schema/beans"
    xmlns:context="http://www.springframework.org/schema/context"
    xmlns:jdbc="http://www.springframework.org/schema/jdbc"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://www.springframework.org/schema/beans
                        http://www.springframework.org/schema/beans/spring-beans-3.1.xsd
                        http://www.springframework.org/schema/context
                        http://www.springframework.org/schema/context/spring-context-3.1.xsd
                        http://www.springframework.org/schema/jdbc
                        http://www.springframework.org/schema/jdbc/spring-jdbc-3.1.xsd">

    <context:component-scan base-package="com.example" />


    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
        <property name="driverClassName" value="org.hsqldb.jdbcDriver" />
        <property name="url" value="jdbc:hsqldb:mem:mydb;sql.syntax_ora=true" />
        <property name="username" value="sa" />
        <property name="password" value="" />
        <property name="initialSize" value="5" />
        <property name="maxActive" value="10" />
        <property name="poolPreparedStatements" value="true" />
        <property name="maxOpenPreparedStatements" value="10" />
    </bean>

    <jdbc:initialize-database data-source="dataSource">
        <jdbc:script location="classpath:schema.sql" />
    </jdbc:initialize-database>
</beans>