CF Snippets

HSQLdb Datasource Configuration

Connect to an HSQL flat-file database from CFML by placing this datasource struct configuration in your Application.cfc.

this.datasources["hsqldb"] = {
  class: "org.hsqldb.jdbcDriver"
  , connectionString: "jdbc:hsqldb:file:#expandPath( '/PATH/TO/FILE' )#"
};