# Multiple commits using db.transactions?

**URL:** <https://forum.inductiveautomation.com/t/multiple-commits-using-db-transactions/8231>\
**Category:** Ignition\
**Created:** [March 28, 2014, 3:46pm UTC](https://forum.inductiveautomation.com/t/multiple-commits-using-db-transactions/8231 "2014-03-28T15:46:24Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![drewdin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/drewdin/32/3363_2.png) [@drewdin](https://forum.inductiveautomation.com/u/drewdin)\
**Post date:** [March 28, 2014, 3:46pm UTC](https://forum.inductiveautomation.com/t/multiple-commits-using-db-transactions/8231/1 "2014-03-28T15:46:24Z")

</div>

Is it possible to have multiple commits for a single transaction? For instance:

txID = system.db.beginTransaction(timeout=5000)

Insert statement here  
system.db.commitTransaction(txID)

Second insert statement here  
system.db.commitTransaction(txID)

system.db.closeTransaction(txID)

Thanks

---

<div class="post-metadata">

**Author:** ![drewdin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/drewdin/32/3363_2.png) [@drewdin](https://forum.inductiveautomation.com/u/drewdin)\
**Post date:** [April 2, 2014, 4:51pm UTC](https://forum.inductiveautomation.com/t/multiple-commits-using-db-transactions/8231/2 "2014-04-02T16:51:20Z")

</div>

nothing…

---

<div class="post-metadata">

**Author:** ![nmudge](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nmudge/32/3394_2.png) [@nmudge](https://forum.inductiveautomation.com/u/nmudge)\
**Post date:** [April 2, 2014, 5:42pm UTC](https://forum.inductiveautomation.com/t/multiple-commits-using-db-transactions/8231/3 "2014-04-02T17:42:00Z")

</div>

You could try it and find out.

---

<div class="post-metadata">

**Author:** ![drewdin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/drewdin/32/3363_2.png) [@drewdin](https://forum.inductiveautomation.com/u/drewdin)\
**Post date:** [April 2, 2014, 6:40pm UTC](https://forum.inductiveautomation.com/t/multiple-commits-using-db-transactions/8231/4 "2014-04-02T18:40:55Z")

</div>

good point, i was thinking the same thing after the post…

---

<div class="post-metadata">

**Author:** ![mori.luca](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mori.luca/32/13424_2.png) [@mori.luca](https://forum.inductiveautomation.com/u/mori.luca)\
**Post date:** [June 15, 2020, 4:32pm UTC](https://forum.inductiveautomation.com/t/multiple-commits-using-db-transactions/8231/5 "2020-06-15T16:32:15Z")

</div>

Best topic ever