Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-6738

validationQuery option for JDBC storage plugin

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.14.0
    • Fix Version/s: 1.18.0
    • Component/s: Storage - JDBC
    • Labels:
      None
    • 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.

      Description

      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 in Drill's 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.

      connectionTestQuery should be used instead of validationQuery. Example of configuration:

      {
        "type": "jdbc",
        "driver": "org.postgresql.Driver",
        "url": "jdbc:postgresql://localhost:5959/my_db?defaultRowFetchSize=2",
        "username": "my_user",
        "password": "my_pass",
        "caseInsensitiveTableNames": false,
        "sourceParameters": {
          "connectionTestQuery": "select * from information_schema.collations"
        },
        "enabled": true
      }
      

        Attachments

        Issue Links

          Activity

            People

            • Assignee:
              arina Arina Ielchiieva
              Reporter:
              appler Cheolgoo Kang

              Dates

              • Created:
                Updated:
                Resolved:

                Issue deployment