com.northconcepts.datapipeline.jdbc.insert.MySqlPreparedStatementInsert

public class MySqlPreparedStatementInsert extends PreparedStatementInsert

Sample Generated SQL:
INSERT IGNORE 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

Description

MySqlPreparedStatementInsert()
Method Summary

Modifier and Type

Method

Description

MySqlPreparedStatementInsert

clone()

Returns a new, unprepared copy with the same settings; JdbcMultiWriter uses one for each connection.

boolean

isIgnoreOnError()

Indicates if INSERT IGNORE is generated instead of a plain INSERT (default is false).

void

prepare(JdbcWriter writer, Record record)

Called once, with the first record written, to generate the SQL and create the statement(s).

MySqlPreparedStatementInsert

setIgnoreOnError(boolean ignoreOnError)

Indicates if INSERT IGNORE is generated instead of a plain INSERT (default is false).

Methods inherited from class com.northconcepts.datapipeline.jdbc.insert.PreparedStatementInsert
addBatch, addExceptionProperties, close, executeBatch, executeUpdate, isBatchSupported, isDebug, setDebug, setInsertStatement, setValues

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 Details
- MySqlPreparedStatementInsert
  
  public MySqlPreparedStatementInsert()
Method Details
- isIgnoreOnError
  
  public boolean isIgnoreOnError()
  
  Indicates if INSERT IGNORE is generated instead of a plain INSERT (default is false).
- setIgnoreOnError
  
  public MySqlPreparedStatementInsert setIgnoreOnError(boolean ignoreOnError)
  
  Indicates if INSERT IGNORE is generated instead of a plain INSERT (default is false).
- prepare
  
  public void prepare(JdbcWriter writer, Record record) throws Throwable
  
  Description copied from interface: IInsert
  
  Called once, with the first record written, to generate the SQL and create the statement(s).
  
  Specified by:
  
  prepare in interface IInsert
  
  Overrides:
  
  prepare in class PreparedStatementInsert
  
  Throws:
  
  Throwable
- clone
  
  public MySqlPreparedStatementInsert clone()
  
  Description copied from interface: IInsert
  
  Returns a new, unprepared copy with the same settings; JdbcMultiWriter uses one for each connection.
  
  Specified by:
  
  clone in interface IInsert
  
  Overrides:
  
  clone in class PreparedStatementInsert

Class MySqlPreparedStatementInsert

Field Summary