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

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.6.1.0
• Fix Version/s: 10.6.1.0
• Component/s: Tools
• Bug behavior facts: Regression
• Assignee: Richard N. Hillegas
• Reporter: Knut Anders Hatlen
• Created: 12/Mar/10 14:51
• Updated: 12/Jan/11 18:54
• Resolved: 12/Mar/10 23:51

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.

Issue Links

• is part of: DERBY-712 Support for sequences
• relates to: DERBY-651 Re-enable the storing of java objects in the database