jamesfredley commented on PR #15502:
URL: https://github.com/apache/grails-core/pull/15502#issuecomment-4051351866
```
dataSource:
# ── First-class Grails properties (handled by DataSourceSettings) ──
url: jdbc:mysql://localhost:3306/mydb # → HikariConfig.jdbcUrl
(via alias)
driverClassName: com.mysql.cj.jdbc.Driver # →
HikariConfig.driverClassName
username: root # →
HikariConfig.username (via alias → "user")
password: secret # → HikariConfig.password
readOnly: false # →
DataSourceBuilder.readOnly + defaultReadOnly
pooled: true # Grails-only: use
pooled DataSource?
type: com.zaxxer.hikari.HikariDataSource # Force specific pool
implementation
jndiName: java:comp/env/jdbc/myDS # JNDI lookup (bypasses
pool entirely)
# ── HikariCP-specific properties (passed through to HikariConfig) ──
properties:
# Pool sizing
maximumPoolSize: 10 #
setMaximumPoolSize(int)
minimumIdle: 5 # setMinimumIdle(int)
# Timeouts (in milliseconds)
connectionTimeout: 30000 #
setConnectionTimeout(long)
idleTimeout: 600000 # setIdleTimeout(long)
maxLifetime: 1800000 # setMaxLifetime(long)
validationTimeout: 5000 #
setValidationTimeout(long)
keepaliveTime: 0 # setKeepaliveTime(long)
leakDetectionThreshold: 0 #
setLeakDetectionThreshold(long)
initializationFailTimeout: 1 #
setInitializationFailTimeout(long)
# Connection behavior
autoCommit: true # setAutoCommit(boolean)
connectionTestQuery: SELECT 1 #
setConnectionTestQuery(String)
connectionInitSql: SET NAMES utf8mb4 #
setConnectionInitSql(String)
transactionIsolation: TRANSACTION_READ_COMMITTED #
setTransactionIsolation(String)
catalog: mydb # setCatalog(String)
schema: public # setSchema(String)
isolateInternalQueries: false #
setIsolateInternalQueries(boolean)
# Pool management
poolName: MyAppPool # setPoolName(String)
allowPoolSuspension: false #
setAllowPoolSuspension(boolean)
registerMbeans: false #
setRegisterMbeans(boolean)
# JDBC driver pass-through properties (PR #15502 fixes this)
dbProperties:
cachePrepStmts: true
prepStmtCacheSize: 250
prepStmtCacheSqlLimit: 2048
useSSL: false
serverTimezone: UTC
# Health check properties
healthCheckProperties:
connectivityCheckTimeoutMs: 1000
expected99thPercentileMs: 10
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
