Announcement Announcement Module
Collapse
No announcement yet.
SimpleJdbcTemplate and autocommit Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • SimpleJdbcTemplate and autocommit

    Hello,

    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:

    Code:
    /*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
    DISCONNECT
    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.

    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) ?

    Thanks.
Working...
X