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

Cannot use dblook on soft-upgraded database: Table/View 'SYS.SYSSEQUENCES' does not exist.

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 10.6.1.0
    • 10.6.1.0
    • Tools
    • None
    • Regression

    Description

      I tried to use dblook on trunk to dump the schema of a database created with Derby 10.5. dblook printed the following message:

      – Timestamp: 2010-03-12 15:45:50.836
      – Source database is: db
      – Connection URL is: jdbc:derby:db
      – appendLogs: false

      – Note: At least one unexpected error/warning message was
      – encountered during DDL generation. See dblook.log
      – to review the message(s).

      In dblook.log, I saw an exception with this message:

      java.sql.SQLSyntaxErrorException: Table/View 'SYS.SYSSEQUENCES' does not exist.

      Attachments

        1. derby-4580-01-aa-dblookSequencesSoftUpgrade.diff
          0.6 kB
          Richard N. Hillegas
        2. dblook.log
          3 kB
          Knut Anders Hatlen

        Issue Links

          is part of

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-712 Support for sequences

          • Major - Major loss of function.
          • Closed
          relates to

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-651 Re-enable the storing of java objects in the database

          • Major - Major loss of function.
          • Closed

          Activity

            People

              rhillegas Richard N. Hillegas
              knutanders Knut Anders Hatlen
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: