[
https://issues.apache.org/jira/browse/DRILL-6738?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Arina Ielchiieva resolved DRILL-6738.
-------------------------------------
Resolution: Fixed
Merged into master with commit id 50cd931da0364355535029db8e9d7a1445218803.
> 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)
