[jira] [Updated] (DRILL-6738) validationQuery option for JDBC storage plugin

["Arina Ielchiieva (Jira)" <ji...@apache.org>]

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

Arina Ielchiieva updated DRILL-6738:
------------------------------------
    Fix Version/s: 1.18.0

> validationQuery option for JDBC storage plugin
> ----------------------------------------------
>
>                 Key: DRILL-6738
>                 URL: https://issues.apache.org/jira/browse/DRILL-6738
>             Project: Apache Drill
>          Issue Type: Improvement
>          Components: Storage - JDBC
>    Affects Versions: 1.14.0
>         Environment: Apache Drill version 1.14.0 running on CentOS 7.0.1406.
> MySQL version 5.5.43 running on CentOS 6.4.
> MySQL connector/j version 5.1.44.
>            Reporter: Cheolgoo Kang
>            Assignee: Arina Ielchiieva
>            Priority: Major
>             Fix For: 1.18.0
>
>
> Currently JDBC storage plugin uses DBCP2 for the connection pooling, but it wouldn't validate the connection's still available or not, and it'd just spit the connection lost error.
> We should be able to have a validationQuery option described [here|https://commons.apache.org/proper/commons-dbcp/configuration.html] in Drill's JDBC storage plugin configuration.



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