PostgreSQL connection settings and JDBC URL.
PostgreSQL connection settings and JDBC URL.
(build-jdbc-url {:keys [host port name application-name statement-timeout-ms]})Build the PostgreSQL JDBC URL from db-config.
Session settings ride on the URL so every physical connection in the pool gets them:
options,
so sessions run in local time (BOU-431)reported reads it
from the exception for parsing (BOU-626)Build the PostgreSQL JDBC URL from `db-config`. Session settings ride on the URL so every physical connection in the pool gets them: - stringtype=unspecified: let the server infer the type of string literals - ApplicationName: identifies the connection in pg_stat_activity - options: statement_timeout guard, and a TimeZone that does not take — pgjdbc sends the JVM's timezone in the startup packet after `options`, so sessions run in local time (BOU-431) - reWriteBatchedInserts: batches multi-row INSERTs into single statements - logServerErrorDetail=false: keeps the server's Detail (the row, the key's value) out of exception messages and so out of logs; `reported` reads it from the exception for parsing (BOU-626)
HikariCP defaults for a server database.
HikariCP defaults for a server database.
(session-statements _db-config)A connectivity probe only. The session settings are on the JDBC URL above — a SET here would reach just the one pooled connection that ran it.
A connectivity probe only. The session settings are on the JDBC URL above — a SET here would reach just the one pooled connection that ran it.
cljdoc builds & hosts documentation for Clojure/Script libraries
| Ctrl+k | Jump to recent docs |
| ← | Move to previous article |
| → | Move to next article |
| Ctrl+/ | Jump to the search field |