Spring에서 HSQLDB 설정하기

 

스프링 설정파일에서 xml을 다음과 같이설정한다.

<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:jd="http://www.springframework.org/schema/jdbc"
xsi:schemaLocation="http://www.springframework.org/schema/beans
      http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
      http://www.springframework.org/schema/jdbc
      http://www.springframework.org/schema/jdbc/spring-jdbc-3.0.xsd"> 
 
<jdbc:embedded-database id="dataSourceSpied" type="HSQL" /> 
      
     <jdbc:initialize-database data-source="dataSourceSpied" ignore-failures="DROPS">
        <jdbc:script location="classpath:database/hsqldb/schema.sql" />
        <jdbc:script location="classpath:database/hsqldb/data.sql" />
    </jdbc:initialize-database>

 

schema.sql

create table t_sample (
    sample_no   int           not null,
    title       varchar(500)  not null,
    description varchar(1000) not null,
    primary key (sample_no)
);
 

data.sql

insert into t_sample (sample_no, title, description) values (1, '타이틀 1', '설명 1');
insert into t_sample (sample_no, title, description) values (2, '타이틀 2', '설명 2');
insert into t_sample (sample_no, title, description) values (3, '타이틀 3', '설명 3');
commit;