Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <1715583214.235661268428167287.JavaMail.jira@brutus.apache.org>
Date: Fri, 12 Mar 2010 21:09:27 +0000 (UTC)
From: "Knut Anders Hatlen (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Commented: (DERBY-4580) Cannot use dblook on soft-upgraded
 database: Table/View 'SYS.SYSSEQUENCES' does not exist.
In-Reply-To: <433138754.227881268405487171.JavaMail.jira@brutus.apache.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


    [ https://issues.apache.org/jira/browse/DERBY-4580?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12844683#action_12844683 ] 

Knut Anders Hatlen commented on DERBY-4580:
-------------------------------------------

Thanks for fixing this so quickly, Rick. I've verified that the patch works, and I can now successfully look at an old database. +1 to commit.

> Cannot use dblook on soft-upgraded database: Table/View 'SYS.SYSSEQUENCES' does not exist.
> ------------------------------------------------------------------------------------------
>
>                 Key: DERBY-4580
>                 URL: https://issues.apache.org/jira/browse/DERBY-4580
>             Project: Derby
>          Issue Type: Bug
>          Components: Tools
>    Affects Versions: 10.6.0.0
>            Reporter: Knut Anders Hatlen
>            Assignee: Rick Hillegas
>         Attachments: dblook.log, derby-4580-01-aa-dblookSequencesSoftUpgrade.diff
>
>
> 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.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.