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
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_FORMATFields inherited from class com.northconcepts.datapipeline.core.DataObject
id, log, name, TIMESTAMP_FORMAT -
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionclone()Returns a new, unprepared copy with the same settings;JdbcMultiWriteruses one for each connection.voidExecutes the statement with the values applied; called after each record when the writer is not batching.voidprepare(JdbcWriter writer, Record record) Called once, with the first record written, to generate the SQL and create the statement(s).voidsetValues(JdbcWriter writer, Record record) Applies the record's values to the pending statement; called for every record written.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
-
Constructor Details
-
OracleMultiRowSelectUnionAllStatementInsert
public OracleMultiRowSelectUnionAllStatementInsert()
-
-
Method Details
-
prepare
Description copied from interface:IInsertCalled once, with the first record written, to generate the SQL and create the statement(s).- Specified by:
preparein interfaceIInsert- Overrides:
preparein classMultiRowStatementInsert- Throws:
Throwable
-
setValues
Description copied from interface:IInsertApplies the record's values to the pending statement; called for every record written.- Specified by:
setValuesin interfaceIInsert- Overrides:
setValuesin classMultiRowStatementInsert- Throws:
Throwable
-
executeUpdate
Description copied from interface:IInsertExecutes the statement with the values applied; called after each record when the writer is not batching.- Specified by:
executeUpdatein interfaceIInsert- Overrides:
executeUpdatein classMultiRowStatementInsert- Throws:
Throwable
-
clone
Description copied from interface:IInsertReturns a new, unprepared copy with the same settings;JdbcMultiWriteruses one for each connection.- Specified by:
clonein interfaceIInsert- Overrides:
clonein classMultiRowStatementInsert
-