pools {
	default {
		jdbcUrl = "jdbc:mysql://localhost:3306/db?useSSL=false"
		username = "username"
		password = "password"

		minimumIdle = 5
		maximumPoolSize = 10

		autoCommit = false
		connectionTimeout = 300000
		//driverClassName = "com.mysql.jdbc.Driver" - deprecated
		driverClassName = "com.mysql.cj.jdbc.Driver"

		cachePrepStmts = true
		prepStmtCacheSize = 250
		prepStmtCacheSqlLimit = 2048

		useServerPrepStmts = true //todo ???
	}

	// This syntax inherits the config from pools.default.
	// We can then override or add additional properties.
	transactional = ${pools.default} {
		poolName = "transactional"
	}

	processing = ${pools.default} {
		poolName = "processing"
		maximumPoolSize = 30
	}
}