autocommit

Transactions, when should be discarded and rolledback

I'm trying to debug an application (under PostgreSQL) and came across the following error: "current transaction is aborted, commands ignored". As far as I can understand a "transaction" is just a notion related to the underlying database connection. If the connection has an auto commit "false", you can execute queries through the same ...

How to make Subversion (or any program) perform periodic commits?

I want to configure my computer so that say every half an hour it automatically commits the program I am working on. I am using a svn repository so even if it was just a script that ran 'svn ci' every 30 min that would be okay. The problem is that I don't know how to do that. Could somebody please tell me, or direct me to something, tha...

SQLite error: cannot commit transaction - SQL statements in progress using Java Code

Hi All, I am facing an SQLite error though I am not using any explicit AutoCommit true or false. can anyone provide any input on this error. What are the situation where you will get this error. Thanks in advance. Regards, Manasi Save ...

How do you set autocommit in an SQL Server session?

How do you set autocommit in an SQL Server session? ...

java:not able to set auto commit mode with value false in java 1.4 api?

sql server 200 java 1.4 jboss 3 HI am getting exception message "You cannot set autocommit during a managed transaction" code is below try { try { connection = getConnection(); } catch (Exception e) { throw new ConnectionException(e.getMessage()); } for(int i=0;i<recordIds.size();i++) { String cu...

How do I turn off autocommit for a MySQL client?

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 seems to talk about using init_connect on the database, i.e. a global setting for all client connections. Is there a way to set autocommit=0 jus...

Subversion timed commit

I've got a folder under version control; the contents aren't source, but they are binaries that are modified frequently and would generally get committed once a day. Problem is, the consumers of those files can't grasp the concept for source control, they don't realistically have access to the folder in question and 'they can't be bothe...

What does Postgres do when BEGIN is run on a connection in autocommit mode?

I'm trying to better understand the concept of 'autocommit' when working with a Postgres (psycopg) connection. Let's say I have a fresh connection, set its isolation level to ISOLATION_LEVEL_AUTOCOMMIT, then run this SQL directly, without using the cursor begin/rollback methods (as an exercise; not saying I actually want to do this): I...

Problem with autocommit in ANT SQL task

I have an SQL script and want to apply it witn ANT task. This script clears out schema, creates new tables and views. The ANT defined task as follows: <sql driver="com.mysql.jdbc.Driver" url="jdbc:mysql://host:3306/smth" userid="smth" password="smth" expandProperties="false" autocommit="true" ...

Atomikos rollback doesn't clear JPA persistence context?

I have a Spring/JPA/Hibernate application and am trying to get it to pass my Junit integration tests against H2 and MySQL. Currently I am using Atomikos for transactions and C3P0 for connection pooling. Despite my best efforts my DAO integration one of the tests is failing with org.hibernate.NonUniqueObjectException. In the failing ...

Large Objects may not be used in auto-commit mode

Hello, 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 on EntityManager), but when the object is loaded from the database I get the following exception: org.postgresql.util.PSQLException: ...

Disable autocommit during hundreds of MySQL UPDATE statements in Django program

In a Django program, how to explicitly disable auto transaction management before hundreds of UPDATEs and enable it after the UPDATEs finish? I looked into http://docs.djangoproject.com/en/dev/topics/db/transactions/ but didn't find any clue. I tried to put the following code at the beginning settings.DISABLE_TRANSACTION_MANAGEMENT = ...

JSF, postback and database alteration

Hi, I'm using JSF, Google App Engine, and OpenSessionInView (using Filter and ThreadLocal). My bean has a private field List<A> allElements; The property getAllElements() retrieves from the database the data, the first time, i.e. when allElements == null. In the page, I have a dataTable binded with {#MyBean.allElements}. Finally, the...

DBI database handle with AutoCommit set to 0 not returning proper data with SELECT?

This is a tricky one to explain (and very weird), so bear with me. I will explain the problem, and the fix for it, but I would like to see if anyone can explain why it works the way it works :) I have a web application that uses mod_perl. It uses MySQL database, and I am writing data to a database on regular basis. It is modular, so it ...