Transaction Support in MySQL
Hi, I am using MySQL 3.23.40 on LINUX Redhat 7.1 version. My application is an OLTP application and depends heavily on transactions. Since MySQL doesn't support transactions for the stable releases, is there any work around to solve this problem. Could any one help how to cope up without transactons in mysql. The Help manual provided with the software doesn't help a great deal. Regards Aravind For Stock Quotes, Finance News, Insurance, Tax Planners, Mutual Funds... Visit http://in.finance.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Transaction Support in MySQL
Hi Arawind, Could any one help how to cope up without transactons in mysql. The Help manual provided with the software doesn't help a great deal. Oneway is to incorporte transaction processing functionalities in the middle layer application. eg. before commiting persistent objects used for backend database from mysql. Or if you are using php scripts, then modify the scripts for transaction functionalities before commiting the changes into mysql. -- Prabhu Regards Aravind For Stock Quotes, Finance News, Insurance, Tax Planners, Mutual Funds... Visit http://in.finance.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --- Beauty is bought by judgement of the eye. -- Shakespeare --- Prabhu SR. Sankhya Technologies Private Limited, Chennai-34. --- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Transaction Support in MySQL
What sort of support for transactions and table/record locking is there in MySQL right now? I had heard that only table locking was supported, and limited support for transactions. Aaron - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Transaction Support in MySQL
On Fri, 22 Jun 2001 15:17:18 -0700, Alberni-dot-Net Tech Mailing Lists [EMAIL PROTECTED] wrote: What sort of support for transactions and table/record locking is there in MySQL right now? I had heard that only table locking was supported, and limited support for transactions. we've had good success with MySQL w/Innobase for transaction usage. Mainly for development testing but so far so good,..we're happy with it. We use Perl w/DBI 1.18 and DBD::mysql Mike(mickalo)Blezien Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225) 686-2002 = - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Transaction support in MySQL?
I'm wondering if MySQL supports transaction? Since I have an application to use MySQL JDBC to perform several insert statements and then do a rollback, all data saved to the database without rolling back. -Eric - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Transaction support in MySQL?
http://www.mysql.com/documentation/mysql/bychapter/manual_Compatibility.html#Missing_Transactions http://www.mysql.com/documentation/mysql/bychapter/manual_Table_types.html#BDB -tcl. On Tue, 13 Feb 2001, Eric Kwong wrote: I'm wondering if MySQL supports transaction? Since I have an application to use MySQL JDBC to perform several insert statements and then do a rollback, all data saved to the database without rolling back. -Eric - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php