db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rick Hillegas (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DERBY-5201) Create tools for reading the contents of the seg0 directory
Date Mon, 01 Apr 2013 13:29:15 GMT

     [ https://issues.apache.org/jira/browse/DERBY-5201?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel

Rick Hillegas updated DERBY-5201:

    Attachment: TableSignatureReader.java

Attaching TableSignatureReader. This class prints out the signature of a table, suitable for
passing to DataFileReader. All JAVA_OBJECT types are reported as "serializable". Here's how
to use this program:


    java TableSignatureReader connectionURL schemaName tableName


      connectionURL    e.g. "jdbc:derby:db1"
      schemaName      case-sensitive schema name, e.g. APP
      tableName          case-sensitive table name, e.g. T1

Here's an example use...

  java TableSignatureReader "jdbc:derby:db1" SYS SYSALIASES

...which prints out the following result:

( "ALIASID" char( 36 ), "ALIAS" varchar( 128 ), "SCHEMAID" char( 36 ), "JAVACLASSNAME" long
varchar, "ALIASTYPE" char( 1 ), "NAMESPACE" char( 1 ), "SYSTEMALIAS" boolean, "ALIASINFO"
serializable, "SPECIFICNAME" varchar( 128 ) )

> 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:
>            Reporter: Rick Hillegas
>         Attachments: DataFileReader.java, DataFileReader.java, DataFileReader.java, TableSignatureReader.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
For more information on JIRA, see: http://www.atlassian.com/software/jira

View raw message