pStmt.addBatch();
}
pStmt.executeBatch();
This scenario will insert three records into table on loop one time.
On the side it will failed on pStmt.addBatch() over one time.
Here is the error from SQL side:
ERROR[30025] The ATOMIC and NOT ATOMIC clauses can be used only in a rowset INSERT statement.
JDBC_TYPE4: ?,?,?,? ),(?,?, ?,?),(? ,?,?,?) ' on below loop over one time;
Batch operation failed by statement of 'insert into table values(
The procedure: ?,?,?,? ),(?,?, ?,?),(? ,?,?,?) ";
pStmt. setString( 1, "QA");
pStmt. setInt( 2, prm);
pStmt. setInt( 3, points);
pStmt. setString( 4, DEPT);
PreparedStatement pStmt = null;
insert = "insert into table values(
for (int j = 0; j < 1; j++) {
}
pStmt.executeBa
This scenario will insert three records into table on loop one time.
On the side it will failed on pStmt.addBatch() over one time.
Here is the error from SQL side:
ERROR[30025] The ATOMIC and NOT ATOMIC clauses can be used only in a rowset INSERT statement.