Uploaded image for project: 'EJBCA'
  1. EJBCA
  2. ECA-4294

Use JDBC to detect index presence

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: EJBCA 6.7.0
    • Component/s: PKI core
    • Labels:
      None

      Description

      JDBC can report meta data about the database if the driver supports it.

      Check if the commonly used drivers can successfully report presence of indexes and constraints.

      If so, replace our current conflicting INSERT check for unique index on certificate data with a meta data query.

        Attachments

          Issue Links

          is related to

          Bug - A problem which impairs or prevents the functions of the product. ECA-5268 Internal database constraint test audit logs certificate storage

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed
          relates

          Improvement - An improvement or enhancement to an existing feature or task. ECA-7843 EJBCA startup does full table analysis on Oracle causing timeout issue during startup

          • Major - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. ECA-7477 Documentation: database indexes

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. ECA-4358 Descriptive name for test for issuerDN, serial number uniqeness in database

          • Cosmetic - Cosmetic problem like misspelt words or misaligned text.
          • Closed

            Activity

              People

              Assignee:
              johan Johan Eklund
              Reporter:
              johan Johan Eklund
              Verified by:
              Mike Agrenius Kushner
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: