com.dpslink.base.tool

Class CopyDatabase

java.lang.Object

com.dpslink.base.tool.CopyDatabase

All Implemented Interfaces:

java.io.Serializable

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

A command line class that copies table data from one database to another.

Requires "src" and "dst" JDBC pool names to be defined in properties, where "src" is the copy-from database and "dst" is the copy-to database.

Example (copying from an i5 database to a local Derby database):

 JDBCPoolManager.drivers=com.ibm.as400.access.AS400JDBCDriver|org.apache.derby.jdbc.EmbeddedDriver
 JDBCPoolManager.pools=src|dst
 JDBCPoolManager.src.initconns=1
 JDBCPoolManager.src.maxconns=5
 JDBCPoolManager.src.schema=FLASHDB
 JDBCPoolManager.src.sqlname=
 JDBCPoolManager.src.url=jdbc:as400://dps.dpslink.com/{0};naming=sql;errors=full
 JDBCPoolManager.src.userid=myuserid
 JDBCPoolManager.src.userpwd=mypassword
 JDBCPoolManager.src.waitsecs=5
 JDBCPoolManager.dst.initconns=1
 JDBCPoolManager.dst.maxconns=5
 JDBCPoolManager.dst.schema=DPSFLASH
 JDBCPoolManager.dst.sqlname=flashdb.
 JDBCPoolManager.dst.url=jdbc:derby:e:/webprojects/ecomm/database/{0};create=true
 JDBCPoolManager.dst.userid=
 JDBCPoolManager.dst.userpwd=
 JDBCPoolManager.dst.waitsecs=5
 

See Also:

Serialized Form

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
private class	CopyDatabase.CopyObjectController A bogus JDBC object controller used to assist with copying table data.

Field Summary

Fields

Modifier and Type	Field and Description
private static long	serialVersionUID The class' serialization version id.

Constructor Summary

Constructors

Modifier	Constructor and Description
private	CopyDatabase() Constructs a new database copier.

Method Summary

Modifier and Type	Method and Description
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

Constructor Detail

CopyDatabase

private CopyDatabase()

Constructs a new database copier. Controls copy processing.

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 (none are required).