| java.lang.Object com.salmonllc.sql.DataPipe
DataPipe | public class DataPipe (Code) | | This class is can be used to pipe data from one database to another assuming that the identical tables exist in both databases
|
Constructor Summary | |
public | DataPipe(String application, String source, String dest, Vector tables) Constructs a new DataPipe
Parameters: application - The application that this is running under Parameters: source - The profile name for the source database Parameters: dest - The profile name for the destination database Parameters: tables - A vector of tables to pipe over. | public | DataPipe(String application, String source, String dest) |
_continueOnError | boolean _continueOnError(Code) | | |
_source_dest_application | String _source_dest_application(Code) | | |
_updateTablesWithData | boolean _updateTablesWithData(Code) | | |
DataPipe | public DataPipe(String application, String source, String dest, Vector tables)(Code) | | Constructs a new DataPipe
Parameters: application - The application that this is running under Parameters: source - The profile name for the source database Parameters: dest - The profile name for the destination database Parameters: tables - A vector of tables to pipe over. Leave null for all tables |
DataPipe | public DataPipe(String application, String source, String dest)(Code) | | Constructs a new DataPipe that will pipe all data from one db to another
Parameters: application - The application that this is running under Parameters: source - The profile name for the source database Parameters: dest - The profile name for the destination database |
pipeData | public void pipeData() throws Exception(Code) | | Copies the data for the specifiec tables from one database to another
throws: Exception - |
setContinueOnError | public void setContinueOnError(boolean continueOnError)(Code) | | Set to true to continue processing even if there is an error
|
setMaxRows | public void setMaxRows(int maxRows)(Code) | | Sets the maximum number of rows any one table will pipe over or -1 for unlimited
|
setUpdateTablesWithData | public void setUpdateTablesWithData(boolean updateTablesWithData)(Code) | | Set to true if you want the pipe to empty the table before copying the data to it.
Set to false to skip tables that already have data in them
Parameters: updateTablesWithData - |
|
|