@Test public void testUpdateNoTransaction() throws SQLException { String ddlQuery = "create table testUpdateNoTransaction(id int primary key, value varchar(50))"; Connection connection = sql2o.createQuery(ddlQuery).executeUpdate(); assertTrue(connection.getJdbcConnection().isClosed()); String insQuery = "insert into testUpdateNoTransaction(id, value) values (:id, :value)"; sql2o .createQuery(insQuery) .addParameter("id", 1) .addParameter("value", "test1") .executeUpdate() .createQuery(insQuery) .addParameter("id", 2) .addParameter("value", "val2") .executeUpdate(); assertTrue(connection.getJdbcConnection().isClosed()); }