com.northconcepts.datapipeline.jdbc.insert

Class MultiRowPreparedStatementInsert

java.lang.Object

com.northconcepts.datapipeline.core.DataObject

com.northconcepts.datapipeline.jdbc.insert.MultiRowPreparedStatementInsert

All Implemented Interfaces:

IInsert, Cloneable

public class MultiRowPreparedStatementInsert
extends DataObject
implements IInsert

Sample Generated SQL:
INSERT INTO tableName (col1, col2, col3) VALUES
(?, ?, ?),
(?, ?, ?),
(?, ?, ?),...

Field Summary

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

id, log, name, TIMESTAMP_FORMAT

Constructor Summary

Constructors

Constructor and Description
MultiRowPreparedStatementInsert()

Method Summary

Modifier and Type	Method and Description
void	addBatch()
DataException	addExceptionProperties(DataException exception) Adds this object's current state to a DataException.
protected String	buildSql(JdbcWriter writer, Record record, int rowCount)
MultiRowPreparedStatementInsert	clone()
void	close()
void	executeBatch()
void	executeUpdate()
boolean	isBatchSupported()
boolean	isDebug() Indicates if the generated SQL should be logged (default false).
void	prepare(JdbcWriter writer, Record record)
MultiRowPreparedStatementInsert	setDebug(boolean debug) Set to true to log generated SQL (default false).
void	setValues(JdbcWriter writer, Record record)

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

MultiRowPreparedStatementInsert

public MultiRowPreparedStatementInsert()

Method Detail

isDebug

public boolean isDebug()

Description copied from interface: IInsert

Indicates if the generated SQL should be logged (default false).

Specified by:

isDebug in interface IInsert

setDebug

public MultiRowPreparedStatementInsert setDebug(boolean debug)

Description copied from interface: IInsert

Set to true to log generated SQL (default false).

Specified by:

setDebug in interface IInsert

buildSql

protected String buildSql(JdbcWriter writer,
                          Record record,
                          int rowCount)
                   throws Throwable

Throws:

Throwable

prepare

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

Specified by:

prepare in interface IInsert

Throws:

Throwable

setValues

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

Specified by:

setValues in interface IInsert

Throws:

Throwable

executeUpdate

public void executeUpdate()
                   throws Throwable

Specified by:

executeUpdate in interface IInsert

Throws:

Throwable

isBatchSupported

public boolean isBatchSupported()

Specified by:

isBatchSupported in interface IInsert

addBatch

public void addBatch()
              throws Throwable

Specified by:

addBatch in interface IInsert

Throws:

Throwable

executeBatch

public void executeBatch()
                  throws Throwable

Specified by:

executeBatch in interface IInsert

Throws:

Throwable

close

public void close()
           throws Throwable

Specified by:

close in interface IInsert

Throws:

Throwable

clone

public MultiRowPreparedStatementInsert clone()

Specified by:

clone in interface IInsert

Overrides:

clone in class Object

addExceptionProperties

public DataException addExceptionProperties(DataException exception)

Description copied from class: DataObject

Adds this object's current state to a DataException. Since this method is called whenever an exception is thrown, subclasses should override it to add their specific information.

Specified by:

addExceptionProperties in interface IInsert

Overrides:

addExceptionProperties in class DataObject