jdbc url

Sqlite

• http://www.zentus.com/sqlitejdbc/ : Original
• http://www.xerial.org/trac/Xerial/wiki/SQLiteJDBC : 개선판
• Class : org.sqlite.JDBC
• url : jdbc:sqlite:F:/data/com.astroframe.seoulbus/databases/station.sqlite
• multithread에서 쓰면 안되요 : http://stackoverflow.com/questions/5117248/spring-sqlite-in-multi-threaded-application

<dependency>
 <groupId>org.xerial</groupId>
 <artifactId>sqlite-jdbc</artifactId>
 <version>3.7.2</version>
</dependency>

HSQL

• Driver : org.hsqldb.jdbcDriver
  • Datasource : org.hsqldb.jdbc.jdbcDataSource
• URL 형식
  • jdbc:hsqldb:file:/./DATABASE/db/sampledb
  • jdbc:hsqldb:file:/D:/work/hsql/sample1/sampledb
  • jdbc:hsqldb:hsql://localhost/sampledb
  • jdbc:hsqldb:mem:mymemdb