Package com.northconcepts.datapipeline.jdbc.insert
package com.northconcepts.datapipeline.jdbc.insert
Insert strategies for
JdbcWriter and JdbcMultiWriter.-
ClassDescriptionThe strategy used to write records to a database.Sample Generated SQL:
INSERT INTO tableName (col1, col2, col3) VALUES
(?, ?, ?),
(?, ?, ?),
(?, ?, ?),...Sample Generated SQL:
INSERT INTO tableName (col1, col2, col3) VALUES
(val1, val2, val3),
(val1, val2, val3),
(val1, val2, val3),..Sample Generated SQL:
INSERT IGNORE INTO tableName (col1, col2, col3) VALUES (?, ?, ?)Sample Generated SQL:
OracleMultiRowInsertAllStatementInsertINSERT 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 dualSample 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 dualBase class for the Oracle-specific multi-row insert strategies, which write the values into the SQL as literals.Sample Generated SQL:
INSERT INTO tableName (col1, col2, col3) VALUES (?, ?, ?)