[DRILL-7466] Configurable number of connection in JDBC storage connection pool

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.17.0
• Fix Version/s: 1.18.0
• Component/s: Storage - JDBC
• Assignee: Arina Ielchiieva
• Reporter: Priyanka Bhoir
• Created: 05/Dec/19 14:36
• Updated: 16/Mar/20 16:18
• Resolved: 23/Jan/20 15:57

Description

Drill does not allow the number of connections in the pool to configured

When a JDBC storage plugin is created, it creates 8 connections per plugin which happen to be the default for dbcp connection pool. Currently, there is no way to configure these parameters using storage configuration. Max Idle is set to 8 leaving all connections open even when unused. This situation creates an unnecessary connection to DB.

These parameters must be made configuration in the JDBC storage plugin configuration.

NOTE
In DRILL-7639 BasicDataSource was replaced with Hikari, sourceParameters sections remains and allows to configure data source, Hikari related configuration properties should be used instead. List of Hikari properties: https://github.com/brettwooldridge/HikariCP.

Issue Links

• is part of: DRILL-7467 Jdbc plugin enhancements and fixes