SQL Power Business Intelligence Productivity Tools
Company OverviewBusiness Intelligence Productivity ToolsQuick-Start Implementation ServicesDemos & TurotialsFrequently Asked Questions (FAQ)Open Source Community ResourcesSQL Power ForumImplementation & Technology PartnersGet SQL Power SoftwareContact Us

SQL Power Software Forum
SQL Power Software Forum
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing   [Groups] Back to home page  [Register] Register /  [Login] Login 
SQL Window - Commit and Rollback  XML
Forum Index » SQL Power Wabit Discussion
Author Message
[Post New]2009-09-14 18:39:39
    Subject: SQL Window - Commit and Rollback
[Up]
JBrown


Joined: 2009-08-10 11:08:07
Messages: 30
Offline
In Wabit when does a commit occur? Is it automatic? Am I able to rollback?

Probably not a required function in a BI tool but if someone was using the Wabit as a general query tool control of this would be useful.
[Post New]2009-09-14 18:46:23
    Subject: Re:SQL Window - Commit and Rollback
[Up]
Luc Boudreau


Joined: 2009-09-14 18:44:50
Messages: 15
Offline
+1 to that.
[Post New]2009-09-17 10:07:22
    Subject: Re:SQL Window - Commit and Rollback
[Up]
Thomas


Joined: 2008-12-08 10:14:11
Messages: 165
Offline
Hi JBrown,

Wabit is currently always in automatic commit mode. This means when you execute any statement in Wabit it will be committed once the statement finishes execution. We can add in the functionality to turn off auto commit which will let you roll back any commands you executed. I have created bug 2272 to track this issue.

Thomas
 
Forum Index » SQL Power Wabit Discussion
Go to:   
Powered by JForum 2.1.8 © JForum Team