aaaa

dataSource {
	pooled = true
	jmxExport = true
	driverClassName = "com.mysql.jdbc.Driver"
	username = "prismdba"
	password = "password"
	password = "QAZwsxEDC123"  //product
}
hibernate {
	cache.use_second_level_cache = true
	cache.use_query_cache = false
	//cache.region.factory_class = 'org.hibernate.cache.SingletonEhCacheRegionFactory' // Hibernate 3
	cache.region.factory_class = 'org.hibernate.cache.ehcache.SingletonEhCacheRegionFactory' // Hibernate 4
	singleSession = true // configure OSIV singleSession mode
	flush.mode = 'manual' // OSIV session flush mode outside of transactional context
}

// environment specific settings
environments {
	development {
		dataSource {
			dbCreate = "update" // one of 'create', 'create-drop', 'update', 'validate', ''
			username = "prismdba"
			password = "password"
			url = "jdbc:mysql://localhost:3306/nposms?useUnicode=yes&characterEncoding=UTF-8"
		}
	}
	
	test {
		dataSource {
			dbCreate = "update"
			url = "jdbc:mysql://192.168.1.152:3306/nposms?useUnicode=yes&characterEncoding=UTF-8"
			username = "prismdba"
			password = "password"
			properties {
				// See https://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
			}
		}
	}

    klaverio {
        println "Using klaverio datasource"
        dataSource {
            dbCreate = "update"
            username = "prismdba"
            password = "QAZwsxEDC123"
            url = "jdbc:mysql://klaverio.c5zd4oxwvys7.ap-southeast-1.rds.amazonaws.com:3306/nposms?useUnicode=yes&characterEncoding=UTF-8"

            properties {
                // See https://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
            }
        }
    }

	prismbhamas { // doesn't seem to like a hyphen here
		println "Using prism-bhamas datasource"
		dataSource {
			dbCreate = "update"
			username = "prismrds"
			password = "1qazxsw2"
			url = "jdbc:mysql://prism-bhamas-rds.cucuwdqljar7.ap-southeast-1.rds.amazonaws.com:3306/nposms?useUnicode=yes&characterEncoding=UTF-8"

			properties {
				// See https://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
			}
		}
	}
}