# \[Perspective\] NamedQueryTransaction Error

**URL:** <https://forum.inductiveautomation.com/t/perspective-namedquerytransaction-error/56836>\
**Category:** Ignition\
**Tags:** ignition81, scripting, database, perspective\
**Created:** [March 4, 2022, 1:25pm UTC](https://forum.inductiveautomation.com/t/perspective-namedquerytransaction-error/56836 "2022-03-04T13:25:10Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![bkarabinchak.psi](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bkarabinchak.psi/32/83567_2.png) [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\
**Post date:** [March 4, 2022, 2:00pm UTC](https://forum.inductiveautomation.com/t/perspective-namedquerytransaction-error/56836/3 "2022-03-04T14:00:48Z")

</div>

Recently had a similar issue, solution that worked for me is in this thread-

> [@\[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/perspective-namedquerytransaction-error/56836)._