HSQLDB

Added by   Donny Lee, last edited by   Donny Lee  on Feb 21, 2011  ( view change)

HSQLDB is memory database.

pom.xml

<dependency> <groupId>hsqldb</groupId> <artifactId>hsqldb</artifactId> <version>1.8.0.7</version> <scope>test</scope> </dependency>

jdbc.properties

hsql will scan directory hsql by jdbc.url , find all report.* file and load these.eg:have report.script which sql script, and report.properties which hsql properties ,so when hsql start will load these file.you can write create table sql in *.script or *.sql ,you like jdbc.driverClassName=org.hsqldb.jdbcDriver jdbc.url=jdbc:hsqldb:res:/com/radicasys/intimate/report/hsql/report jdbc.username=sa jdbc.password=