com.dpslink.base.tool

Class MakeDerbyImportsExports

java.lang.Object

com.dpslink.base.tool.MakeDerbyImportsExports

All Implemented Interfaces:

java.io.Serializable

public class MakeDerbyImportsExports
extends java.lang.Object
implements java.io.Serializable

A command line class that creates derby import and export script files for the tables in a database. The scripts can then be processed using the org.apache.derby.tools.ij command line tool.

The export script will export the data in each table to a CSV file. A separate file is created for each table.

The import script will import the CSV data into the appropriate table in the database. The import script assumes the database tables are void of any data, meaning the script does not attempt to clear any tables prior to doing the imports. The import script also assumes that the CSV data contains the same number of columns as defined in the respective table.

See Also:

Serialized Form

Field Summary

Fields

Modifier and Type	Field and Description
private static java.lang.String	EXPORT The template for table export statements.
private static java.lang.String	IMPORT The template for table import statements.
private static long	serialVersionUID The class' serialization version id.

Constructor Summary

Constructors

Constructor and Description
MakeDerbyImportsExports(java.lang.String poolname) The default constructor for the class.

Method Summary

Modifier and Type	Method and Description
private static void	cmdLineError() Handles command line parameter errors.
static void	main(java.lang.String[] args) Main entry point for when the class is started from a command line.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

serialVersionUID

private static final long serialVersionUID

The class' serialization version id.

See Also:

Constant Field Values

IMPORT

private static final java.lang.String IMPORT

The template for table import statements.

See Also:

Constant Field Values

EXPORT

private static final java.lang.String EXPORT

The template for table export statements.

See Also:

Constant Field Values

Constructor Detail

MakeDerbyImportsExports

public MakeDerbyImportsExports(java.lang.String poolname)

The default constructor for the class.

Method Detail

main

public static void main(java.lang.String[] args)

Main entry point for when the class is started from a command line.

Parameters:

args - (String[]) A String array of startup parameters for the class.

cmdLineError

private static void cmdLineError()

Handles command line parameter errors. Displays a message and aborts.