Uploaded image for project: 'Jira Cloud'
  1. Jira Cloud
  2. JRACLOUD-38751

The DBCP pool-test-on-borrow parameter should explicitly be set to false on the dbconfig.xml file

    XMLWordPrintable

Details

    • Suggestion
    • Resolution: Fixed
    • None
    • Our product teams collect and evaluate feedback from a number of different sources. To learn more about how we use customer feedback in the planning process, check out our new feature policy.

    Description

      NOTE: This suggestion is for JIRA Cloud. Using JIRA Server? See the corresponding suggestion.

      The pool-test-on-borrow parameter should be set to false by default on the JIRA Configuration Tool and on the JIRA Setup Wizard.
      As highlighted on JRA-38750, the default value for this parameter on Apache DBCP is true.

      Impact:
      Every time a DB connection is borrowed from the pool the validation query will be executed, unless this parameter is explicitly set to false.
      For customers running large instances this might impact their database performance as they might have hundreds of requests to the pool per second, and the validation query will be executed before every one of them.

      • <pool-test-on-borrow>false</pool-test-on-borrow>

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              dconrad Danilo Conrad
              Votes:
              4 Vote for this issue
              Watchers:
              11 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: