Friday, May 18, 2012

Dynamically setting up a H2 datasource on OpenBD


<cfset DatasourceCreate("enlist"
    , {
        drivername: "org.h2.Driver"
        , hoststring: "jdbc:h2:" & ExpandPath('./') & "/WEB-INF/bluedragon/h2databases/enlist;AUTO_SERVER=TRUE;IGNORECASE=false;MODE=MySQL"
        , initstring: "RUNSCRIPT FROM '#ExpandPath("../docs/sql")#/mysql_createDB.sql'\;"
        , databasename: "enlist"
        , username: "enlist"
        , password: "enlist"
    }) />


No comments:

Post a Comment