The "connection.rollback()" has execute,But data still updated. EG : <div clas

Hey <a class="user-mention notranslate" data-hovercard-type="user" data-hovercard-url=

<a class="user-mention notranslate" data-hovercard-type="user" data-hovercard-url="/us

sql2o can't rolback ? about sql2o HOT 3 OPEN

mailtous commented on July 26, 2024

sql2o can't rolback ?

from sql2o.

Comments (3)

mbraunerDE commented on July 26, 2024

Hey @mailtous ,

the connection.commit(); writes all data to database, only all changes until last commit can be rollbacked.

e.g.

    public void write() {
        try (Connection connection = sql2o.beginTransaction()) {
            Query q = connection.createQuery(" UPDATE `users` set name = 'alice' where id = 1");
            q.setAutoDeriveColumnNames(true);
            q.executeUpdate();
            // DO SAVE
            connection.commit();
            // TEST DATA  name is alice
            Query q = connection.createQuery(" UPDATE `users` set name = 'dirk' where id = 1");
            q.executeUpdate();
            // TEST DATA ROLLBACK, The "connection.rollback()" is executed, the name is alice, not dirk.
            connection.rollback();

        }
    }

from sql2o.

mailtous commented on July 26, 2024

@mbraunerDE
Thanks your answer~! BUT...

 public void write() {
        try (Connection connection = sql2o.beginTransaction()) {
            Query q1 = connection.createQuery(" UPDATE `users` set name = 'alice' where id = 1");
            q1.setAutoDeriveColumnNames(true);
            q1.executeUpdate();
            // DO SAVE
            connection.commit();
            // TEST DATA  name is alice

            Query q2 = connection.createQuery(" UPDATE `users` set name = 'dirk' where id = 1");
            q2.executeUpdate();

            // next row need add "connection.commit()", to real save "dirk"  to DB 
           connection.commit();

            // TEST DATA ROLLBACK, The "connection.rollback()" is executed, the name is alice, not dirk.
            connection.rollback();
        }
    }

** TEST TWO: **

 public void write() {
        try (Connection connection = sql2o.beginTransaction()) {
            Query q1 = connection.createQuery(" UPDATE `users` set name = 'alice' where id = 1");
            q1.setAutoDeriveColumnNames(true);
            q1.executeUpdate();
            // DO SAVE
            connection.commit();
            // TEST DATA  name is alice

            Query q2 = connection.createQuery(" UPDATE `users` set name = 'dirk' where id = 1");
            q2.executeUpdate();

            // q2 is executed but not commit, so  name of dirk is not save to DB. 
        }
    }