GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

How to disable implicit commit

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • How to disable implicit commit

    Is there any way to disable implicit COMMIT in case of statements like START TRANSACTION, CREATE TABLE etc?

    http://dev.mysql.com/doc/refman/5.1/...it-commit.html

    It would be very useful for catching hidden application bugs - I never want to commit a transaction if I haven't run COMMIT statement.

    And another question, is there any session status variable, which indicates an open transaction?

    Thank you, Vojtech

  • #2
    No, and no. The second one is odd, because the protocol and the session actually know that there's an open transaction -- it just isn't exposed to the user.

    Comment


    • #3
      Thats really odd ( Thank you Baron, I'll try to simulate it in our acpplication database layer.

      Comment

      Working...
      X