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

Commit after issuing many INSERT statements with JDBC adapter


I would like to be able to issue many INSERT statements with the JDBC adapter using the format

   <dbTableName action=u201DINSERTu201D>

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?