In-memory database for testing

Application.cfc

component displayname="Application" {

    // Set up an in-memory testing datasource
    // You may need to install the H2 driver (or Apache Derby, or whatever)
    this.datasources[ "testing" ] = {
        class: 'org.h2.Driver',
        connectionString: 'jdbc:h2:mem:testing;MODE=MySQL',
        username = "sa"
    };

    this.datasource = "testing";

}