Uploaded image for project: 'SonarQube'
  1. SonarQube
  2. SONAR-5605

MySQL: configure driver to use server side cursor and not client side cursor

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Won't Fix
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

      For the time being only the fetch size is programmatically defined which means that client side cursors are used and when dealing with large amount of data this can lead to an OutOfMemoryException.

      The following parameter should be added to the MySQL JDBC url to activate server side cursors :

      • useCursorFetch=true

      reference

      • useCursorFetch=true

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              julien.lancelot Julien Lancelot
              Reporter:
              stephane.gamard St├ęphane Gamard (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Due:
                Created:
                Updated:
                Resolved: