Package de.akquinet.jbosscc.guttenbase.tools

Class SplitByRangeTableCopyTool

java.lang.Object

de.akquinet.jbosscc.guttenbase.tools.AbstractTableCopyTool

de.akquinet.jbosscc.guttenbase.tools.SplitByRangeTableCopyTool

public class SplitByRangeTableCopyTool
extends AbstractTableCopyTool

Sometimes the amount of data exceeds any buffer. In these cases we need to split the data by some given range, usually the primary key. I.e., the data is read in chunks where these chunks are split using the ID column range of values. Copy all tables from one connection to the other splitting the input with the given column. If the number range is populated sparsely the copying may take much longer than the DefaultTableCopyTool.

© 2012-2034 akquinet tech@spree

Field Summary

Fields inherited from class de.akquinet.jbosscc.guttenbase.tools.AbstractTableCopyTool

_connectorRepository, _progressIndicator

Constructor Summary

Constructors

Constructor	Description
SplitByRangeTableCopyTool(ConnectorRepository connectorRepository)

Method Summary

Modifier and Type	Method	Description
protected void	copyTable(String sourceConnectorId, Connection sourceConnection, SourceDatabaseConfiguration sourceDatabaseConfiguration, TableMetaData sourceTableMetaData, String sourceTableName, String targetConnectorId, Connection targetConnection, TargetDatabaseConfiguration targetDatabaseConfiguration, TableMetaData targetTableMetaData, String targetTableName, int numberOfRowsPerBatch, boolean useMultipleValuesClauses)	Copy data with multiple VALUES-tuples per batch statement.

Methods inherited from class de.akquinet.jbosscc.guttenbase.tools.AbstractTableCopyTool

copyTables

Methods inherited from class java.lang.Object

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

Constructor Detail

SplitByRangeTableCopyTool

public SplitByRangeTableCopyTool(ConnectorRepository connectorRepository)

Method Detail

copyTable

protected void copyTable(String sourceConnectorId,
                         Connection sourceConnection,
                         SourceDatabaseConfiguration sourceDatabaseConfiguration,
                         TableMetaData sourceTableMetaData,
                         String sourceTableName,
                         String targetConnectorId,
                         Connection targetConnection,
                         TargetDatabaseConfiguration targetDatabaseConfiguration,
                         TableMetaData targetTableMetaData,
                         String targetTableName,
                         int numberOfRowsPerBatch,
                         boolean useMultipleValuesClauses)
                  throws SQLException

Copy data with multiple VALUES-tuples per batch statement.

Specified by:

copyTable in class AbstractTableCopyTool

Throws:

SQLException