Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Date: Fri, 27 Jan 2012 17:34:15 +0000 (UTC)
From: "Steve Ferguson (Issue Comment Edited) (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Message-ID: 
 <2043796124.1003.1327685655086.JavaMail.tomcat@hel.zones.apache.org>
In-Reply-To: 
 <1378737677.70747.1303326425757.JavaMail.tomcat@hel.zones.apache.org>
Subject: [jira] [Issue Comment Edited] (DERBY-5201) Create tools for reading
 the contents of the seg0 directory
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


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

Steve Ferguson edited comment on DERBY-5201 at 1/27/12 5:33 PM:
----------------------------------------------------------------

Thanks very much for this. 2 pieces of feedback.

 If I provide a data signature, and a row contains a column with a null value, and Exception is thrown and the program exits. I put a try catch ignore Throwable block around  dvd.readExternalFromArray( is ); to circumvent this. 

I think it would nice if a data signature is present to add an XML element to output the name of the column in addition to its index. 

I also found this link helpful in conjunction with the tool to query out my ddl to pass into the tool as a data signature for tables with lots of columns. 

http://wiki.apache.org/db-derby/ListTableColumns
                
      was (Author: sferguson):
    Thanks very much for this. 2 pieces of feedback.

 If I provide a data signature, and a row contains a column with a null value, and Exception is thrown and the program exists. I put a try catch ignore Throwable block around  dvd.readExternalFromArray( is ); to circumvent this. 

I think it would nice if a data signature is present to add an XML element to output the name of the column in addition to its index. 

I also found this link helpful in conjunction with the tool to query out my ddl to pass into the tool as a data signature for tables with lots of columns. 

http://wiki.apache.org/db-derby/ListTableColumns
                  
> Create tools for reading the contents of the seg0 directory
> -----------------------------------------------------------
>
>                 Key: DERBY-5201
>                 URL: https://issues.apache.org/jira/browse/DERBY-5201
>             Project: Derby
>          Issue Type: Task
>          Components: Tools
>    Affects Versions: 10.9.0.0
>            Reporter: Rick Hillegas
>         Attachments: DataFileReader.java, DataFileReader.java
>
>
> It would be nice to have tools which read Derby data files (the files in the seg0 directory) without disturbing their contents.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira