Package com.northconcepts.datapipeline.jdbc.insert

Insert strategies for JdbcWriter and JdbcMultiWriter.

See: Description

Interface Summary

Interface	Description
IInsert	The strategy used to write records to a database.

Class Summary

Class	Description
MultiRowPreparedStatementInsert	Sample Generated SQL: INSERT INTO tableName (col1, col2, col3) VALUES (?, ?, ?), (?, ?, ?), (?, ?, ?),...
MultiRowStatementInsert	Sample Generated SQL: INSERT INTO tableName (col1, col2, col3) VALUES (val1, val2, val3), (val1, val2, val3), (val1, val2, val3),..
MySqlPreparedStatementInsert	Sample Generated SQL: INSERT IGNORE INTO tableName (col1, col2, col3) VALUES (?, ?, ?)
OracleMultiRowInsertAllStatementInsert	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
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
OracleMultiRowStatementInsert
PreparedStatementInsert	Sample Generated SQL: INSERT INTO tableName (col1, col2, col3) VALUES (?, ?, ?)

Package com.northconcepts.datapipeline.jdbc.insert Description

Insert strategies for JdbcWriter and JdbcMultiWriter.