Hi folks,

I want to execute several update queries, which values originate from an csv-file, within one transaction. Some of the queries might break a constraint of the table, for example trying to insert an value being unique in another row of the table. 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