com.northconcepts.datapipeline.jdbc.insert

Class OracleMultiRowInsertAllStatementInsert

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.OracleMultiRowInsertAllStatementInsert

All Implemented Interfaces:

IInsert, Cloneable

public class OracleMultiRowInsertAllStatementInsert
extends OracleMultiRowStatementInsert

Sample Generated SQL:
OracleMultiRowInsertAllStatementInsert INSERT ALL
INTO tableName (col1, col2, col3) VALUES ('val1', 'val2', 'val3')
INTO tableName (col1, col2, col3) VALUES ('val1', 'val2', 'val3')
INTO tableName (col1, col2, col3) VALUES ('val1', 'val2', 'val3')
...
SELECT 1 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
OracleMultiRowInsertAllStatementInsert()

Method Summary

Modifier and Type	Method and Description
OracleMultiRowInsertAllStatementInsert	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

OracleMultiRowInsertAllStatementInsert

public OracleMultiRowInsertAllStatementInsert()

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 OracleMultiRowInsertAllStatementInsert clone()

Specified by:

clone in interface IInsert

Overrides:

clone in class MultiRowStatementInsert