dataSource {
    pooled = true
    jmxExport = true
    //driverClassName = "org.h2.Driver"
    driverClassName = "net.sourceforge.jtds.jdbc.Driver"
    username = "sa"
    password = "Expertflow464"
}
hibernate {
   cache.use_second_level_cache = true
   cache.use_query_cache = false
   //  cache.region.factory_class =
   'net.sf.ehcache.hibernate.EhCacheRegionFactory' // Hibernate 3
    cache.region.factory_class =
   'org.hibernate.cache.ehcache.EhCacheRegionFactory' // Hibernate 4
   singleSession = true // configure OSIV singleSession mode
   logSql = true
}

// environment specific settings
environments {
  development {
     dataSource {
        dbCreate = "update" // one of 'create', 'create-drop',
        'update', 'validate', ''
        //url =
        "jdbc:h2:mem:devDb;MVCC=TRUE;LOCK_TIMEOUT=10000;
         DB_CLOSE_ON_EXIT=FALSE"
         url = "jdbc:jtds:sqlserver://192.168.1.35:1433/efadminpanel"
         driverClassName = "net.sourceforge.jtds.jdbc.Driver"
         username = "sa"
         password = "Expertflow464"
    }
}
production {
    dataSource {
        dbCreate = "update"
        //url = "jdbc:h2:prodDb;MVCC=TRUE;LOCK_TIMEOUT=10000;DB_CLOSE_ON_EXIT=FALSE"
        url = "jdbc:jtds:sqlserver://192.168.1.35:1433/efadminpanel"
        driverClassName = "net.sourceforge.jtds.jdbc.Driver"
        username = "sa"
        password = "Expertflow464"
        properties {
            // See http://grails.org/doc/latest/guide/conf.html#dataSource for documentation
            jmxEnabled = true
            initialSize = 5
            maxActive = 50
            minIdle = 5
            maxIdle = 25
            maxWait = 10000
            maxAge = 10 * 60000
            timeBetweenEvictionRunsMillis = 5000
            minEvictableIdleTimeMillis = 60000
            validationQuery = "SELECT 1"
            validationQueryTimeout = 3
            validationInterval = 15000
            testOnBorrow = true
            testWhileIdle = true
            testOnReturn = false
            jdbcInterceptors = "ConnectionState"
            defaultTransactionIsolation =
            java.sql.Connection.TRANSACTION_READ_COMMITTED
        }
    }
 }
}