Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-17189

Fix potential Oracle cursor leak

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 6.0, 7.2
    • Fix Version/s: 6.0-HF14, 7.3
    • Component/s: Core VCS, Directory

      Description

      When executing NXQL query:

      While the statement is properly closed, the resultset is not closed on JDBCMapper.query.

      According to the JDBC documentation everyting is ok

      "A ResultSet object is automatically closed when the Statement object that generated it is closed"

      But according to Oracle the only holdability supported by ResultSet is HOLD_CURSORS_OVER_COMMIT.

      The last behavior may be responsible of " ORA-01000 maximum open cursors exceeded" errors.

      Same problem on SQLDirectory.

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: