Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Using MySQL with Grails 2.0 - finding external connector .jar
- dataSource {
- pooled = true
- //driverClassName = "org.h2.Driver"
- //username = "sa"
- //password = ""
- driverClassName = "com.mysql.jdbc.Driver"
- username = "bob"
- password = "password"
- }
- hibernate {
- cache.use_second_level_cache = true
- cache.use_query_cache = true
- cache.region.factory_class = 'net.sf.ehcache.hibernate.EhCacheRegionFactory'
- }
- // environment specific settings
- environments {
- development {
- dataSource {
- //dbCreate = "create-drop" // one of 'create', 'create-drop', 'update', 'validate', ''
- //url = "jdbc:h2:mem:devDb;MVCC=TRUE"
- dbCreate = "update" // one of 'create', 'create-drop', 'update', 'validate', ''
- url = "jdbc:mysql://localhost:3306/tekevent"
- }
- }
- test {
- dataSource {
- dbCreate = "create-drop"
- url = "jdbc:h2:mem:testDb;MVCC=TRUE"
- }
- }
- production {
- dataSource {
- dbCreate = "update"
- url = "jdbc:h2:prodDb;MVCC=TRUE"
- pooled = true
- properties {
- maxActive = -1
- minEvictableIdleTimeMillis=1800000
- timeBetweenEvictionRunsMillis=1800000
- numTestsPerEvictionRun=3
- testOnBorrow=true
- testWhileIdle=true
- testOnReturn=true
- validationQuery="SELECT 1"
- }
- }
- }
- }
- repositories {
- ...
- mavenCentral()
- }
- dependencies {
- ...
- runtime 'mysql:mysql-connector-java:5.1.16'
- }
Add Comment
Please, Sign In to add comment