hsqldb 간략 설치 , 테스트 컴퓨터

from http://www.javaworld.co.kr/tag/HSQLDB 따라하기

1. download hsqldb.jar from http://hsqldb.org/

2. mkdir E:\svn\hsqltest
3. copy hsqldb.jar to  E:\svn\hsqltest\lib

4. hsqldb 서버 실행
E:\svn\hsqltest>java -classpath lib\hsqldb.jar org.hsqldb.Server -database.0 file:data/test -dbname.0 jiniland


alias 는 jiniland
db는 data/test

5. hsqldb용 databasemanager 실행
java -classpath lib/hsqldb.jar org.hsqldb.util.DatabaseManager

jdbc:hsqldb:hsql://localhost/jiniland

6. 샘플 스키마 (테스트 테이블) 생성

create table test(
 id integer primary key,
 firstname varchar(20),
 name varchar(50),
 zip integer)

실행 Ctrl-Enter