com.northconcepts.datapipeline.jdbc.insert

Class OracleMultiRowSelectUnionAllStatementInsert

java.lang.Object

com.northconcepts.datapipeline.core.DataObject

com.northconcepts.datapipeline.jdbc.insert.MultiRowStatementInsert

com.northconcepts.datapipeline.jdbc.insert.OracleMultiRowStatementInsert

com.northconcepts.datapipeline.jdbc.insert.OracleMultiRowSelectUnionAllStatementInsert

All Implemented Interfaces:

IInsert, Cloneable

public class OracleMultiRowSelectUnionAllStatementInsert
extends OracleMultiRowStatementInsert

Sample Generated SQL:
INSERT INTO tableName (col1, col2, col3)
SELECT 'val1', 'val2', 'val3' FROM dual UNION ALL
SELECT 'val1', 'val2', 'val3' FROM dual UNION ALL
...
SELECT 'val1', 'val2', 'val3' FROM dual

Field Summary

Fields inherited from class com.northconcepts.datapipeline.jdbc.insert.MultiRowStatementInsert

DATE_FORMAT, DATE_TIME_FORMAT, TIME_FORMAT

Fields inherited from class com.northconcepts.datapipeline.core.DataObject

id, log, name, TIMESTAMP_FORMAT

Constructor Summary

Constructors

Constructor and Description
OracleMultiRowSelectUnionAllStatementInsert()

Method Summary

Modifier and Type	Method and Description
OracleMultiRowSelectUnionAllStatementInsert	clone()
void	executeUpdate()
void	prepare(JdbcWriter writer, Record record)
void	setValues(JdbcWriter writer, Record record)

Methods inherited from class com.northconcepts.datapipeline.jdbc.insert.MultiRowStatementInsert

addBatch, addExceptionProperties, close, executeBatch, getBigDecimalLiteral, getBigIntegerLiteral, getBooleanLiteral, getByteLiteral, getBytesLiteral, getDateLiteral, getDateTimeLiteral, getDoubleLiteral, getFloatLiteral, getInsertSql, getInsertSqlPrefix, getInsertStatement, getIntLiteral, getLongLiteral, getRecordsPendingInsert, getShortLiteral, getSqlValueLiteral, getStringLiteral, getTimeLiteral, isBatchSupported, isDebug, setDebug, setInsertSqlPrefix, setInsertStatement, setRecordsPendingInsert

Methods inherited from class com.northconcepts.datapipeline.core.DataObject

exception, exception, exception, getId, getName, resetID, toString

Methods inherited from class java.lang.Object

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

Constructor Detail

OracleMultiRowSelectUnionAllStatementInsert

public OracleMultiRowSelectUnionAllStatementInsert()

Method Detail

prepare

public void prepare(JdbcWriter writer,
                    Record record)
             throws Throwable

Specified by:

prepare in interface IInsert

Overrides:

prepare in class MultiRowStatementInsert

Throws:

Throwable

setValues

public void setValues(JdbcWriter writer,
                      Record record)
               throws Throwable

Specified by:

setValues in interface IInsert

Overrides:

setValues in class MultiRowStatementInsert

Throws:

Throwable

executeUpdate

public void executeUpdate()
                   throws Throwable

Specified by:

executeUpdate in interface IInsert

Overrides:

executeUpdate in class MultiRowStatementInsert

Throws:

Throwable

clone

public OracleMultiRowSelectUnionAllStatementInsert clone()

Specified by:

clone in interface IInsert

Overrides:

clone in class MultiRowStatementInsert