# system.db.closeTransaction error (caused by: transaction closed)

**URL:** <https://forum.inductiveautomation.com/t/system-db-closetransaction-error-caused-by-transaction-closed/73603>\
**Category:** Ignition\
**Tags:** ignition81, database, perspective\
**Created:** [May 11, 2023, 4:43pm UTC](https://forum.inductiveautomation.com/t/system-db-closetransaction-error-caused-by-transaction-closed/73603 "2023-05-11T16:43:09Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [May 11, 2023, 5:29pm UTC](https://forum.inductiveautomation.com/t/system-db-closetransaction-error-caused-by-transaction-closed/73603/4 "2023-05-11T17:29:28Z")

</div>

> [@\[IGN-3829\] Error executing system.db.commitTransaction](https://forum.inductiveautomation.com/t/ign-3829-error-executing-system-db-committransaction/49595):
>
> When I use a named query transaction, but do not actually run any queries against it I receive an error. If I do the same thing using system.db.beginTransaction I do not get an error. Any ideas on how to get around this? txId = system.db.beginNamedQueryTransaction("myDatabaseConnection") system.db.commitTransaction(txId) system.db.closeTransaction(txId) Java Traceback: Traceback (most recent call last): File "\<input\>", line 28, in \<module\> at com.inductiveautomation.ignition.common.scrip…

---

_[View the full topic](https://forum.inductiveautomation.com/t/system-db-closetransaction-error-caused-by-transaction-closed/73603)._