autocommit Questions
11
Solved
I have a Spring application which uses Hibernate on a PostgreSQL database. I'm trying to store files in a table of the database. It seems it stores the row with the file (I just use persist method ...
Burwell asked 2/7, 2010 at 7:59
3
Solved
I'm using postgres 9.5. How can I check if auto commit is on or off? I tried SHOW AUTOCOMMIT where I got ERROR: unrecognized configuration parameter "autocommit" then I did a \set autocom...
Anastassia asked 23/12, 2016 at 9:3
2
Solved
I'm just wondering as per the title if this can be done? For example, if I was to do something like this:
$this->db->autocommit(false);
But then afterwards I wanted to set it back to it's ...
Forgo asked 13/11, 2014 at 16:3
8
Solved
I have a web app that has been written with the assumption that autocommit is turned on on the database, so I don't want to make any changes there. However all the documentation I can find only see...
Scheer asked 17/2, 2010 at 12:21
2
Solved
I need to use a transaction in my project on MySQL. But I'm not sure if I have to use mysql_query("SET AUTOCOMMIT=0"); or not.
I know I have 2 options:
BEGIN
START TRANSACTION
Also I have heard...
Unchain asked 7/7, 2012 at 14:36
4
Solved
I am reading this one:
Automatic Commit The easiest way to commit offsets is to allow the
consumer to do it for you. If you configure enable.auto.commit=true,
then every five seconds the consu...
Berrios asked 3/10, 2017 at 14:1
3
How do you set autocommit off in psql 8.4 at a global level? is there a configuration attribute that i can change that will introduce this behaviour for all dbs on a cluster to start db sessions wi...
Vaasta asked 12/12, 2012 at 9:57
3
Solved
I've just set up a new PostgreSQL 9.5.2, and it seems that all my transactions are auto committed.
Running the following SQL:
CREATE TABLE test (id NUMERIC PRIMARY KEY);
INSERT INTO test (id) VAL...
Melodramatize asked 4/5, 2016 at 13:38
2
In the MySQL docs there is a statement I don't understand:
The correct way to use LOCK TABLES and UNLOCK TABLES with transactional tables, such as InnoDB tables, is to begin a transaction with S...
Nazarite asked 26/5, 2018 at 6:2
5
I read somewhere that to save data to an SQLite database in Python, a commit() call is required. Yet I have never needed to do this. Why?
Epicycle asked 15/1, 2011 at 12:36
3
Solved
The rollback of my transaction doesn't work.
How do I set autocommit to false (or 0) in the php script using PDO (I have InnoDB 5.7.18) ?
Here is my code:
global $bdd; //defined with PDO
try ...
Bloater asked 21/7, 2017 at 10:5
8
Solved
I'd like to connect to a MySQL server with Oracle SQL Developer, but with autocommit disabled. By default, all MySQL connections have autocommit enabled, which is rather odd.
The global setting in...
Tube asked 24/7, 2013 at 6:32
2
Hi Is their a way to set autocommit to false in spring jdbctemplate.
The thing is instead of transaction (where their is rollback option), I want to have query committed at end of transaction.
...
Nitrogen asked 24/5, 2012 at 22:49
4
Solved
In Hibernate API, there is a property hibernate.connection.autocommit which can be set to true.
But in the API, they have mentioned that it is not recommended to set it like so:
Enables autoco...
Lonlona asked 16/4, 2014 at 5:38
1
Solved
I keep seeing this log when I use connections in Hikari pool.
[com.zaxxer.hikari.pool.PoolElf] : HikariPool-0 - Reset (autoCommit) on connection com.mysql.jdbc.JDBC4Connection@1c9b0314
[com.zaxxe...
Teter asked 17/12, 2016 at 19:25
2
I have noticed that START TRANSACTION automatically COMMIT the previous queries. Because of this and the fact that I have several stored procedure called before the end of the whole transaction, I ...
Mason asked 7/6, 2015 at 7:39
4
I have a lot of virtualhosted websites that are currently being updated via chrooted SFTP. Updates are done by clients (Typically using Dreamweaver and CuteFTP/Filezilla) and staff at my company (t...
Engrossing asked 3/4, 2013 at 3:53
3
Solved
I did a big mistake that I updated a table without 'where' clause in MySQL :'(
It is auto-committed.
Is there any way to rollback from it?
Precis asked 24/12, 2012 at 2:1
1
Solved
I'm using PostgreSQL 9.3 and I have some stored procedures created which contains several statements. I'm calling this stored procedures in a Java application with the help of a prepared statement....
Dreary asked 16/10, 2014 at 13:48
2
Solved
I have the main thread that spawns thread #2 which uses the same hibernate Session in the main thread. Thread #2 just does a "select 1" every few min to keep the db connection alive because of a lo...
Virile asked 10/3, 2011 at 16:4
1
Solved
I'm working with JDBC to connect to Oracle. I tested connection.setAutoCommit(false) vs connection.setAutoCommit(true) and the results were as expected.
While by default connection is supposed to...
Ill asked 13/6, 2012 at 18:42
1
Solved
If I create a preparedstatement using a JDBC connection which has "autocommit off", do I need to call commit() to make the transaction permanent or only the prepare call is enough? Note that I only...
Manson asked 30/5, 2012 at 10:58
1
Solved
I use pg_connect, and pg_query in a project.
But I'm really not sure that is pg_connect using AutoCommit mode or not?
It is important question, because I need to write some block under transaction...
Eloquence asked 14/3, 2012 at 15:5
4
Solved
How do you set autocommit in an SQL Server session?
Grishilde asked 7/7, 2009 at 3:31
3
Solved
Would it add overhead to put a DB transactions around every single service method in our application?
We currently only use DB transactions where it's an explicit/obvious necessity. I have recentl...
Slipcover asked 14/2, 2012 at 3:58
1 Next >
© 2022 - 2024 — McMap. All rights reserved.