public class CopyRegisters
extends java.lang.Object
Modifier and Type | Field and Description |
---|---|
static int |
FETCH_SIZE |
Constructor and Description |
---|
CopyRegisters() |
CopyRegisters(java.lang.String schema,
java.lang.String catalog) |
Modifier and Type | Method and Description |
---|---|
int |
append(java.sql.Connection oOrigin,
java.sql.Connection oTarget,
java.lang.String sOriginTable,
java.lang.String sTargetTable,
java.lang.String sWhere)
Append registers from origin table to target table.
|
java.lang.Object |
cast(java.lang.Object oOrigin,
int iOriginType,
int iTargetType) |
int |
insert(java.sql.Connection oOrigin,
java.sql.Connection oTarget,
java.lang.String sOriginTable,
java.lang.String sTargetTable,
java.lang.String sWhere)
Insert registers from origin table to target table.
|
int |
replace(java.sql.Connection oOrigin,
java.sql.Connection oTarget,
java.lang.String sOriginTable,
java.lang.String sTargetTable,
java.lang.String sWhere)
Replace registers from origin table to target table.
|
public CopyRegisters()
public CopyRegisters(java.lang.String schema, java.lang.String catalog)
public java.lang.Object cast(java.lang.Object oOrigin, int iOriginType, int iTargetType)
public int insert(java.sql.Connection oOrigin, java.sql.Connection oTarget, java.lang.String sOriginTable, java.lang.String sTargetTable, java.lang.String sWhere) throws java.sql.SQLException
Insert registers from origin table to target table.
oOrigin
- JDBC Origin ConnectionoTarget
- JDBC Target ConnectionsOriginTable
- Origin Table NamesTargetTable
- Target Table NamesWhere
- SQL filter clause to be applied at origin fron retrieving only a register subsetjava.sql.SQLException
- A duplicated primary key exception is thrown if any inserted register already exists at target tablepublic int replace(java.sql.Connection oOrigin, java.sql.Connection oTarget, java.lang.String sOriginTable, java.lang.String sTargetTable, java.lang.String sWhere) throws java.sql.SQLException
Replace registers from origin table to target table.
Registers not already present at target table will not be inserted from origin table
oOrigin
- JDBC Origin ConnectionoTarget
- JDBC Target ConnectionsOriginTable
- Origin Table NamesTargetTable
- Target Table NamesWhere
- SQL filter clause to be applied at origin fron retrieving only a register subsetjava.sql.SQLException
public int append(java.sql.Connection oOrigin, java.sql.Connection oTarget, java.lang.String sOriginTable, java.lang.String sTargetTable, java.lang.String sWhere) throws java.sql.SQLException
Append registers from origin table to target table.
Registers not present at target table will be inserted from origin table and those present will be updated
oOrigin
- JDBC Origin ConnectionoTarget
- JDBC Target ConnectionsOriginTable
- Origin Table NamesTargetTable
- Target Table NamesWhere
- SQL filter clause to be applied at origin fron retrieving only a register subsetjava.sql.SQLException