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:

  Usage:

    java TableSignatureReader connectionURL schemaName tableName

    where

      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: 10.9.1.0
>            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

Mime
View raw message