Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-7121

DROP UNIQUE KEY not working

    XMLWordPrintableJSON

    Details

    • Urgency:
      Normal

      Description

      I try to drop the FOREIGN KEY, PRIMARY KEY and UNIQUE KEY constraints before the INSERT. To do this, I use the DatabaseMetaData class from JDBC. When dropping the UNIQUE KEY I get the following error message:

      java.sql.SQLSyntaxErrorException: ALTER TABLE failed. There is no constraint 'KXN_SCHEMA.SQL00000166-6f554487-017a-f4fd-c9dc-000016e126' on table '"KXN_SCHEMA". "COUNTRY_STATE"'.

      Details about the error and the database environment can be found in the attached PDF document.

       

        Attachments

        1. IssueApacheDerby.pdf
          64 kB
          Walter Weinmann

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              wwe Walter Weinmann
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: