DB Connection Not Closed (ARCH8084)

Key kotlin.performance.db-connection-not-closed · Severity error · Category performance

Flags DriverManager.getConnection / dataSource.connection / prepareStatement whose result is not wrapped in use { } or closed in finally.

Incorrect

val c = dataSource.connection
c.prepareStatement(sql).execute()

Correct

dataSource.connection.use { c -> c.prepareStatement(sql).use { it.execute() } }

Fix

Wrap connections and statements in use { } so they return to the pool on every path.