You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@drill.apache.org by "Arina Ielchiieva (Jira)" <ji...@apache.org> on 2020/01/23 15:58:00 UTC

[jira] [Resolved] (DRILL-7466) Configurable number of connection in JDBC storage connection pool

     [ https://issues.apache.org/jira/browse/DRILL-7466?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Arina Ielchiieva resolved DRILL-7466.
-------------------------------------
    Resolution: Fixed

Merged into master with commit id 50cd931da0364355535029db8e9d7a1445218803.

> Configurable number of connection in JDBC storage connection pool
> -----------------------------------------------------------------
>
>                 Key: DRILL-7466
>                 URL: https://issues.apache.org/jira/browse/DRILL-7466
>             Project: Apache Drill
>          Issue Type: Improvement
>          Components: Storage - JDBC
>    Affects Versions: 1.17.0
>            Reporter: Priyanka Bhoir
>            Assignee: Arina Ielchiieva
>            Priority: Major
>             Fix For: 1.18.0
>
>
> 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.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)