Skip to Content
0
Former Member
Sep 07, 2009 at 01:42 PM

Commit after issuing many INSERT statements with JDBC adapter

20 Views

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?

BR,

Tony.