auto commit

Hi All, I am using ODBC interface to access MySQL database. All DML oparations like insert, update and delete are performed using ODBC API's ( C program and ODBC API's). We start the transaction in the following order. 1.create savepoint a 2. do dml operation 3. commit if dml is

Re: auto commit

/en-us/odbc/htm/o dbcsqlsetconnectattr.asp Rhino - Original Message - From: [EMAIL PROTECTED] To: mysql@lists.mysql.com Cc: [EMAIL PROTECTED] Sent: Friday, December 31, 2004 8:01 AM Subject: auto commit Hi All, I am using ODBC interface to access MySQL database. All DML oparations

Re: set auto commit

On Thu, Sep 11, 2003 at 02:30:59PM +1000, Daniel Rossi wrote: when is it a good time to do the set auto commit=0 , while doing the update or insert query or sometime before that in the application ? Whenever you need explicit transactions. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux

set auto commit

when is it a good time to do the set auto commit=0 , while doing the update or insert query or sometime before that in the application ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Auto Commit

At 1:47 -0500 3/22/03, Serge Paquin wrote: Hello, A few months ago I asked to have the ability to turn off autocommit at a server level. I was told by a mySQL rep that this would not be added to the 3.23 tree but would be added to the 4 tree. Well since 4 has been declared stable I have

Auto Commit

Hello, A few months ago I asked to have the ability to turn off autocommit at a server level. I was told by a mySQL rep that this would not be added to the 3.23 tree but would be added to the 4 tree. Well since 4 has been declared stable I have upgraded. Now I am trying to find out

re: mysql auto-commit

On Sunday 09 March 2003 11:17, Kian Kok Lim wrote: Do you have a version of mysql that supports transaction, with auto-commit (rollback and commit) feature? From your manuals, it appears that there is a BDB version. How/Where can I access it? Transactions work on InnoDB and BDB tables. You

mysql auto-commit

Dear Sir, Do you have a version of mysql that supports transaction, with auto-commit (rollback and commit) feature? From your manuals, it appears that there is a BDB version. How/Where can I access it? Thanks. Lim Kian Kok. Singapore. __ Do You

JDBC Driver Bug, does not appear to support auto commit off-selections not detected in while loop if new insertions

My code works fine with autcommit on..however it does not support autocommit off. This is quite a big bug, or I have missed something out. Please let me know as I it would be of great interest to me if I was mistaken or correct and you will consider fixing it. If I switch off auto commit

Re: JDBC Driver Bug, does not appear to support auto commit off-selectionsnot detected in while loop if new insertions

and you will consider fixing it. If I switch off auto commit and select rows from a database table in a loop when I enter new values to the table it will not find them unless I specifically commit after every select statement. Surely this is select for update( with InnoDB) ? not just an ordinary

RE: turn off auto commit in MYSQL

-Original Message- From: Peter Brawley [mailto:peter.brawley;artfulsoftware.com] Sent: Wednesday, November 13, 2002 6:04 PM To: Devi Annisetty Subject: Re: turn off auto commit in MYSQL SET @@autocommit=0 or BEGIN - Hi, I am newbie to MYSQL and ODBC I have to update more than 2 tables

RE: turn off auto commit in MYSQL

is there any configuration that turn on auto commit persistently ... i mean for each client connections? (in my.cnf [client] or something else) Thanks in advance. Natale Babbo --- Devi Annisetty [EMAIL PROTECTED] ha scritto: Hi Peter, Thank you very much I got one more question Do I need

Re: turn off auto commit in MYSQL

is there any configuration that turn on auto commit persistently ... i mean for each client connections? (in my.cnf [client] or something else) The default is ON. Turning it off is how a client begins a transaction. If you want to prevent users from using transactions, you can use MyISAM

turn off auto commit in MYSQL

Hi, I am newbie to MYSQL and ODBC I have to update more than 2 tables simultanously currently my application uses ADOBC connection object. How can turn off the autocommit option and set manaul commit. what places I need to change inorder to work manual commit Thanks in Advance for your time

set auto commit problem

Hi, I'm tring to make connection.setAutoCommit(false) with org.gjt.mm.mysql.Driver driver, I recieve an exception that says : cannot disable AUTOCOMMIT . Is it the driver, should I use different driver, and suggestion ? Thanks a lot einav. Einav Lavi-Pdut software engineer [EMAIL PROTECTED]