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

Replace DBCP2 with HikariCP in RDBMS (JDBC) plugin

    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

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: