I would like to be able to issue many INSERT statements with the JDBC adapter using the format
<StatementName2> <dbTableName action=u201DINSERTu201D> <table>realDbTableName</table> <access> <col1>val1</col1> <col2>val2</col2> </access> </dbTableName> </StatementName2>
Then commit all of the records at the same time.
IS it possible to do this, either using the format above, or using the action = "SQL_DML" form instead?
What do I have to do to explicitly force the commit? Can I explicitly use the COMMIT command in the SQL_DML form? And if I can use the action = "INSERT" form, how can I then control the commit so it is done after many records have been inserted?