Hi folks,
I want to execute several update queries within one transaction. Some of the queries might break a constraint of the table, for example trying to insert an unique value in the table, that already exists. The problem is, if one of the queries failes, the whole transaction failes (atomicity). Is there a way to let the failing queries fail without the other queries being affected by that?
I want to find a way where I dont need to instantiate a new Session for each of the 2000 queries which shall be executed.
Thank you for help,
Felix
|