In my application DAOs I'm trying to use SimpleJdbcTemplate and HSQLDB in file mode, with no transaction. I'm afraid autocommit doesn't work because changes to the database are not reflected on disk, although autocommit should be enabled by default (http://hsqldb.org/doc/guide/ch09.htm...commit-section). In the database log file I can see the following:
where autocommit is disabled during the update... strange ? I have also set "SET WRITE_DELAY 0" in the .script file but it didn't change anything.
/*C9*/SET SCHEMA PUBLIC
CONNECT USER SA
SET AUTOCOMMIT FALSE
DELETE FROM CLIENTS WHERE CLI_ID=1
INSERT INTO CLIENTS VALUES(1,'TEST',NULL,'IT')
SET AUTOCOMMIT TRUE
I'd like to know what is going on... How to safely enable autocommit using SimpleJdbcTemplate ? Is it something that have to be set outside the application, in the database configuration, or by the application (in a portable manner) ?