Regarding the use of knime transactions

I tried using Java Snippet nodes with PostgreSQL The connection node implements manual control of transaction commits, because I want to do two or more insert operations, or I can implement multiple insert operations from a single transaction through a node, and I would appreciate it if someone could help me out

Hi @18173042615 and welcome to the forum.

I’m not an expert with advanced database operations, but maybe the DB SQL Executor would be a way forward?

Dear ScottF, I appreciate your advice and I will try it

I was just reminded that we also have the DB Transaction nodes, which you may also find useful here:

1 Like