Stack Overflow
Stack Overflow

Questions tagged [autocommit]

204 questions
0
votes
1 answer

Ant SQL Transaction target, commit after x amount of statements?

Ant SQL Transaction target seems to have options to commit after done, or auto-commit after each statement. The target seems to not take in a property that would commit after x statements have been read. Does the Ant target behave correctly if I…
user1340582
  • 19,151
  • 35
  • 115
  • 171
0
votes
1 answer

Turning off Autocommit in Visual Fox Pro?

I begin my transactions in VFP9 with BEGIN TRANSACTION and end them with ROLLBACK but the changes persist anyway. I'm using a free table directory and I think maybe the issue might have something to do with buffering but I don't know how to apply…
leeand00
  • 25,510
  • 39
  • 140
  • 297
0
votes
2 answers

how to use commit to save all query and if any one query failed no data should be save

I have an employee form.In that i have used tabbed pane to get four different tabs.But problem is that if i save data on first tab only it get saved in database. and before saving data on other tabs i closed the overall form.so in database i have…
user1400604
  • 71
  • 2
  • 12
0
votes
4 answers

Disable AutoCommit using C# Mysql Connector after an unhandled exception

I'm currently developing a C# application with MySql as backend database. Unfortunately I found a wired behaviour I can't explain. I wanted to use transactions, to "combine" multiple queries to make sure only all commands or none are…
Chris
  • 612
  • 7
  • 16
0
votes
1 answer

Core Data: default state of autocommit

I'm wondering what is default state of autocommmit in iOS Core Data and if it's possible to change it. I couldn't find any mentions in official documentation. On SO I've found only this It's said, that native sqlite framework has low-level function…
heximal
  • 10,327
  • 5
  • 46
  • 69
-1
votes
1 answer

How set Autocommit gobal in the instance before running a procedure in Oracledb using Node.js

I was searching and i didn't seem to find an answer to this that would work i need to run a procedure that is already stored after finishing a insert function normally running with SQLDeveloper or Dbeaver you would just do set autocommit on execute…
Carlos Eduardo Teixeira
  • 21
  • 1
  • 1
  • 6
-1
votes
1 answer

Spring Boot + Mysql + TransactionManager

I want to manage the mysql transactions by my own using PlatformTransactionManager and @Transactional but it doesn't work.On other hand,when i work on oracle database it work effectively as per my requirement but in mysql unable to control…
Vishal Monga
  • 272
  • 2
  • 14
-2
votes
1 answer

grails autocommit firing update queries when the position of elements is changed in the list

I have scenario where i need to move an object to the begining of the array list. Right now i have something like this List a = [obj1, obj2, obj3, obj4, obj5, obj6, obj7] now to move obj4 to the begining of the list i am removing it from the list…
vijay tyagi
  • 2,226
  • 3
  • 20
  • 31
-4
votes
1 answer

PHP + MySQL/MariaDB + avoid race condition

I've developed a web application using Apache, MySQL and PHP. This web app allows multiple users' to login to the application. Then, through the application, they have access to the Database. Since race conditions may apply when two or more users…
Tassos Pan
  • 23
  • 5
1 2 3
…
13
14