sql:execute

The sql:execute instruction allows arbitrary SQL statements to be executed. There are two attributes (and no content). The connection attribute is an XPath expression whose value is the SQL connection created using sql:connection. The statement attribute is an attribute value template whose effective value is the SQL statement to be executed. No result is returned.

The statements COMMIT WORK and ROLLBACK WORK (spelt exactly like that) are recognized specially, and cause calls on the JDBC connection.commit() and connection.rollback() methods respectively.