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

Replace DBCP2 with HikariCP in RDBMS (JDBC) plugin

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

Details

    Description

      Hikari is much faster and more reliable than DBCP2.
      See comparison and benchmarks:
      https://beansroasted.wordpress.com/2017/07/29/connection-pool-analysis/
      https://github.com/brettwooldridge/HikariCP

      sourceParameters section will allow setting data source parameters listed in https://github.com/brettwooldridge/HikariCP

      Example:

          "sourceParameters" : {
              "minimumIdle" : 5,
              "autoCommit": false,
              "connectionTestQuery": "select * from information_schema.collations",
              "dataSource.cachePrepStmts": true,
              "prepStmtCacheSize": 250
            }
      

      Example of full 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": {
          "autoCommit": false
        },
        "enabled": true
      }
      

      Attachments

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            arina Arina Ielchiieva
            arina Arina Ielchiieva
            Vova Vysotskyi Vova Vysotskyi
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Issue deployment