{"title":"DB Transaction End","nodeType":"ScopeEnd","id":"*30popOQ2-uN49px4","factoryName":"org.knime.database.node.transaction.end.DBTransactionEndNodeFactory","factoryId":"org.knime.database.node.transaction.end.DBTransactionEndNodeFactory","path":["DB","Transaction"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>This node ends the <a href=\"https://en.wikipedia.org/wiki/Database_transaction\" rel=\"ugc nofollow noopener noreferrer\">transaction</a> of the input database connection.</p>\n                        \n            <p>The node ends the transaction with a <a href=\"https://en.wikipedia.org/wiki/Commit_%28data_management%29\" rel=\"ugc nofollow noopener noreferrer\">commit</a> that makes all changes visible to other users if its body executed successfully. Otherwise the node ends the transaction with a <a href=\"https://en.wikipedia.org/wiki/Rollback_%28data_management%29\" rel=\"ugc nofollow noopener noreferrer\">rollback</a> returning the database to the state at the beginning of the transaction.</p>\n                    \n        \n        ","shortDescription":"Ends a database transaction.","keywords":["database","db"],"deprecated":false,"streamable":false,"tags":["DB","Transaction"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAACXBIWXMAAAsSAAALEgHS3X78AAAAj0lEQVQ4jc2T0QmFMAxFT+T9u4IjOJojPTdwBTdwBN1AJ8ij8AqtNhLsj4H8NJebcJKiqu4EOuALrEB4UPkXXCEiO9Cm2sxARC5uqip39cbd3ojMIHSLWZZz1E7QAyOwpV2LGSmnNWA4a80tRGAFiDMwAQvnLTgNqhi8HaLzEm2IT075Y4mNCBCzz1QHEfgBR5W7jppJz74AAAAASUVORK5CYII=","views":[],"inPorts":[{"objectClass":"org.knime.database.port.DBSessionPortObject","color":"cc005b","dataType":"DB Session","optional":false,"name":"Transactional DB Connection","description":"Transactional DB Connection."},{"objectClass":"org.knime.database.port.DBSessionPortObject","color":"cc005b","dataType":"DB Session","optional":false,"name":"Original transactional DB Connection","description":"Output DB Connection of the DB Transaction Start node."}],"outPorts":[{"objectClass":"org.knime.database.port.DBSessionPortObject","color":"cc005b","dataType":"DB Session","optional":false,"name":"DB Connection","description":"None-transactional DB Connection."},{"objectClass":"org.knime.core.node.port.flowvariable.FlowVariablePortObject","color":"ff4b4b","dataType":"Flow Variable","optional":false,"name":"Successful transaction","description":"Flow variable connection only active for successful (committed) transactions."},{"objectClass":"org.knime.core.node.port.flowvariable.FlowVariablePortObject","color":"ff4b4b","dataType":"Flow Variable","optional":false,"name":"Failed transaction","description":"Flow variable connection only active for failed (rollback) transactions including failure (if any)."}],"dynInPorts":[],"dynOutPorts":[],"additionalSiteInformation":{"url":"https://update.knime.com/analytics-platform/5.12","trusted":true,"enabledByDefault":true,"name":"KNIME Analytics Platform 5.12 Update Site","version":"5.12.0"},"dialog":[],"links":[],"kudos":[],"kudosCount":0,"bundleInformation":{"bundleVersion":"5.12.0.v202606171318","bundleName":"KNIME database nodes","bundleSymbolicName":"org.knime.database.nodes","bundleVendor":"KNIME AG, Zurich, Switzerland","featureSymbolicName":"org.knime.features.database","featureName":"KNIME Database","featureVersion":"5.12.0.v202606171318","featureVendor":"KNIME AG, Zurich, Switzerland","extensionId":"*0mIkLShcIfCXS7Y-"},"frequentSuccessors":[]}