[ 
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

Reply via email to