Connection Pooling

I've noticed there isn't that much information about how to setup connection pooling with grails on the mailing lists so I figured I'd put up a quick post about it. In this example I want to create c3p0 connection pools for all profiles that use postgreSQL.In resources.groovy we add the following:

import com.mchange.v2.c3p0.ComboPooledDataSource
import org.codehaus.groovy.grails.commons.ConfigurationHolder

def config = ConfigurationHolder.config

if(config.dataSource.url =~ 'postgresql') {
     dataSource(ComboPooledDataSource) {
      driverClass = 'org.postgresql.Driver'
      user = config.dataSource.username
      password = config.dataSource.password
      jdbcUrl = config.dataSource.url
         maxStatements = 180
         minPoolSize = 10
         acquireIncrement = 5
         maxPoolSize = 100
     }
}

and something like this to your configuration (Config.groovy or wherever you keep your profile configurations):

dataSource {
 username = 'postgres'
 password = ''
 url = 'jdbc:postgresql://127.0.0.1:5432/databasename'
}

Fire it up with the right profile and you should see the 10 initial connections to your postgres database by running ps -U postgres u at the console.

Can haz cuneckshun puling!