on 09-07-2009 2:42 PM
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.
If you have all these Insert statements with multiple <access> tags, then it would create a single Commit for all the access tags.
Regards,
Prateek
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I think you can use the database auto commit in advance mode of Communication Channel configuration.
Regards,
venu V
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
You can have multiple INSERT blocks in the same payload.
It is executed as single LUW. If all is success COMMIT is executed else ROLLBACK for entire thing occurs.
Try it, it should work.
Regards,
Vikas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
94 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.