Common SQL sets autocommit to 0 when it opens a MySQL connection.
autocommit
LispWorks User Guide and Reference Manual - 21 Dec 2011