Triggers capabilities to abort transactions

Use this forum to request new features or suggest modifications to existing features

Triggers capabilities to abort transactions

Postby perencia » Sun Sep 01, 2013 11:23 am


as i saw in the source code, there's no possibility for a trigger to rollback and abort the transaction, am i correct ?

I wouldn't mind to implement that and submit a patch but I suppose that is a feature that requires some thought... are there any plans to support it ?

By the way, great work :)
Posts: 1
Joined: Sun Sep 01, 2013 11:15 am

Re: Triggers capabilities to abort transactions

Postby qxorm » Mon Sep 02, 2013 7:50 am


In a trigger, you have the parameter : qx::dao::detail::IxDao_Helper * dao.
This parameter is useful for 2 things :
1- get the current connection (if you want to commit/rollback this is important) : dao->database() ;
2- and if an error occured in the trigger, you can write : dao->updateError(myError) (and this error will be returned to the caller).

Then, when you want to use transactions (commit/rollback), there is the class qx::QxSession :
- more details about this class in the FAQ here : ;
- and the class documentation : ... ssion.html

Another possibility could be to throw an exception in your trigger using the class : qx::dao::sql_error.
Site Admin
Posts: 477
Joined: Mon Apr 12, 2010 7:45 am

Return to QxOrm - Feature request

Who is online

Users browsing this forum: No registered users and 1 guest