Database connection reset

Hello,

I am using a simple workflow to connect to DB2 server and pull some data. I iterate through the process.

Basically I am usiing this workflow: https://tech.knime.org/files/database_table_loop.zip

After each loop the connection to server stays open. It changes to idle, but it is still open. Is there a way to close it?

 

Thank you,

Justas

Hello Justas,

no KNIME caches the connection due to performance reasons and closes it only when it is shutdown. We will change this behavior with the next KNIME release in summer so that the connection is closed when the corresponding connector node is resetted.

Bye

Tobias