RE: transaction support
Hi Chris, My apologies, I didn't correctly explain what I was looking for. I mean more of a solution to creating a client program. I'm thinking of php-gtk but not sure how well this works under windows, especially for printing reports. Thanks, Bryan On Sat, 17 Jan 2004, Chris Nolan wrote: Hmm...have you looked at Rekall? www.total-rekall.co.uk Also, you might want to check out OpenOffice.org's database interface features Regards, Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: transaction support
I wanted to thank everyone for their responses and information regarding this. I apologize, I thought I had already replied. Anyhow, I proved my point to our software guy, enough that he is willing to look into it further. Although I have a feeling he isn't going to want to do it (but at least he sees what MySQL can do) so I'll probably be trying to do it myself. So if anyone knows of a way to get a full interface under windows (that can print nice invoices) and has a direct brain-input for learning, let me know :) Thanks again, Bryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: transaction support
Hmm...have you looked at Rekall? www.total-rekall.co.uk Also, you might want to check out OpenOffice.org's database interface features Regards, Chris On Sat, 2004-01-17 at 11:12, Bryan Koschmann - GKT wrote: I wanted to thank everyone for their responses and information regarding this. I apologize, I thought I had already replied. Anyhow, I proved my point to our software guy, enough that he is willing to look into it further. Although I have a feeling he isn't going to want to do it (but at least he sees what MySQL can do) so I'll probably be trying to do it myself. So if anyone knows of a way to get a full interface under windows (that can print nice invoices) and has a direct brain-input for learning, let me know :) Thanks again, Bryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: transaction support
Direct your developer to www.vbmysql.com. This site is dedicated to supporting developers who want to use MySQL with VB. We will be happy to help him with anything he runs into while writing your system for you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: transaction support
Morten Gulbrandsen wrote: http://www.google.com/groups?hl=enlr=ie=UTF-8oe=UTF-8q=MySQL+toy+marston Subject: Re: Can MySQL table handle 3 million+ entries? Newsgroups: comp.lang.php Date: 2003-04-11 15:20:10 PST MySQL is NOT a toy database - it is far superior to many I have used in my long career. The lack of constraints is NOT a weakness. It is eminently possible to create reliable applications without the need for database constraints - I should know because I have designed and built many applications that did not use database constraints (mainly because they were not available). Developers only rely on database constraints to circumvent their sloppy code. Anything that can be done within the database can also be done within application code. As an application developer, I don't trust employees (including myself) to enter the data correctly and hence don't let it pass unchecked but validate it in the application layer. I belief that is a rather common mindset amongst application developers, which matches best practice recommendations: http://www-106.ibm.com/developerworks/library/l-sp2.html As a database administrator, why should I trust application developers (including myself) to validate the data correctly and let the data pass unchecked? Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: transaction support
At 09:37 PM 1/5/2004, Bryan Koschmann - GKT wrote: Hi, I'm trying to get a software designer to write us some software using MySQL as the database server (he currently requires MS SQL). It is all windows based software (written in VB). So far his arguments against it are this (not my words): -No explicit transactional support -MySQL is still buggy -MyODBC is buggy and not used in production environments -Only way to connect using ODBC is third party drivers that cost over half as much as MS SQL This is just for our current software, the new software he is bidding on says he would use .NET so that supposedely causes other problems. Now, I know there are a few discrepancies there but I just don't know enough to argue it. I * need* to use MySQL as the server because of cost reasons. I *WANT* to use MySQL because I don't care for MS choose not to run their products. If you can give me any information to help me argue this I would really appreciate it. Thanks, Bryan I have previously used Borland's Delphi for various programs I needed to write in the M$ environment. This program was very solid and had very good ODBC support. While it has been awhile since I used it (version 2.0, they are now at or beyond 6.0) I have had many individuals claim that the Borland programming languages/compilers are the best and most stable compilers running under M$ Windows. Borland has various Visual programming languages available. you might want to suggest your programming try one of Borland's programs over the MS programs, if you really don't care to use M$ products. When I am forced to use M$ platform, I use every means at my disposal to use non-M$ products to accomplish the job. I use Apache for Web Servers, Perl for Web Scripting, ColdFusion for dynamic web sites accessing various DBs, Bind for DNS, MySQL for all new DBs, etc. For those of us that prefer to not use M$, but are forced to use the OS, I always try my best to make sure I can at least program in something other than MS. Whenever I am forced to program using a M$ compiler, I always add a line to all agreements, that code broken is not the fault of the programmer, but rather the fault of M$ and their constant change in procedures, compilers, and bugs. I have never heard and programmer who uses M$ C Compiler ever say they have had there program work right and stay working after each and every patch, or upgrade of the M$ compiler and operating system. Most programmers who use M$ C compiler constantly complain they must write code that works around a bug in the compiler or OS, only to have to rewrite the code after M$ tries to fix their bug. Patrick J. Shoaf, Systems Engineer mailto:[EMAIL PROTECTED][EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: transaction support
Bryan Koschmann - GKT wrote: Hi, I'm trying to get a software designer to write us some software using MySQL as the database server (he currently requires MS SQL). It is all windows based software (written in VB). So far his arguments against it are this (not my words): -No explicit transactional support InnoDB tables have transaction support. -MySQL is still buggy No it's not. That's a bit of a nebulous claim. -MyODBC is buggy and not used in production environments Not for us. We've been using it in a production environment for 4 years with no issues. -Only way to connect using ODBC is third party drivers that cost over half as much as MS SQL Absolute bulldust. The drivers are free, and not 3rd party drivers, but developed by MySQL, alongside the server product. It sounds like you have a stubbord software developer on your hands who doesn't want to use anything other than M$ toys. I suggest you get another software developer, or at least threaten to. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: transaction support
Bryan, Although this doesn't answer your initial request...why are you wanting to 'argue' with this guy over the database to use. If he won't code for the application to use MySQL (which isn't all that hard in VB regardless of what he says) then get another coder...as simple as that. There's a plethora of coding contractor sites out there any of which probably have a good base of coders with the skills you need capable of coding your software using VB and MySQL. Craig -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: transaction support
On Jan 5, 2004, at 9:37 PM, Bryan Koschmann - GKT wrote: -No explicit transactional support Wrong. InnoDB tables support transactions. -MySQL is still buggy Care to have him specify what bugs he is referring to? I've been using MySQL for 2 years now, and use Microsoft SQL Server for about 3 years before that. I ran into some MSSQL bugs, but have yet to run into anything more than documentation bugs in MySQL. -MyODBC is buggy and not used in production environments There are some problems with MyODBC when used with some Microsoft products. The cynic in me feels that Microsoft deliberately creates these bugs, since I've used the exact same ODBC drivers with non-Microsoft products without a problem. I've used the MyODBC drivers in productions apps with Microsoft Visual FoxPro as the front end for over a year now, and have yet to have a problem. -Only way to connect using ODBC is third party drivers that cost over half as much as MS SQL See above. This is a total crock. Overall, sounds more like he is comfortable with Microsoft SQL Server, and is fabricating these arguments as excuses he can use to stay in his comfort zone. As a consultant myself, I would be very suspicious of anyone who tailors a solutions to his needs instead of yours. I'd not only consider using MySQL, I'd consider looking for a different developer. ___/ / __/ / / Ed Leafe Linux Love: unzip;strip;touch;finger;mount;fsck;more;yes;umount;sleep -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: transaction support
On Mon, 5 Jan 2004, Craig Vincent wrote: Although this doesn't answer your initial request...why are you wanting to 'argue' with this guy over the database to use. If he won't code for the application to use MySQL (which isn't all that hard in VB regardless of what he says) then get another coder...as simple as that. There's a plethora of coding contractor sites out there any of which probably have a good base of coders with the skills you need capable of coding your software using VB and MySQL. Craig (and others) It's a good question and implied by Daniel as well. I should have stated the reason in the beginning. The coder is not only an old employee but a good friend as well, and basically writes the software in exchange for discounts on computer parts. While he is set on M$ stuff, he has always been open to MySQL to a point. The problem is he is perfectly comfortable with M$ products and just doesn't see the need to look at MySQL. Here is the explanation I just received when asking for the difference between transaction support: - MySQL uses single-action implicit and explicit transactions, but they do not automatically roll back on failure. SQL Server user single action implicit and batch explicit transactions as well as supporting transaction nesting (transactions inside of parent transactions) and on failure the entire batch and any parent / peer transactions are rolled back. EXAMPLE (bank transfer): [SqlServer] 1: BEGIN TRANSACTION 2: WITHDRAW $50 from account 32146. 3: DEPOSIT $50 into account 12345. 4: LOG transfer (date/time/teller/etc...) for auditing. 5: COMMIT TRANSACTION if this failed at step 3 due to an error, every change would be undone including the withdrawal and everything would be ok. The transaction could be retried later. [MySQL] 1: START TRANSACTION 2: WITHDRAW $50 from account 32146. 3: DEPOSIT $50 into account 12345. 4: LOG transfer (date/time/teller/etc...) for auditing. 5: COMMIT TRANSACTION if this failed at step 3 the transaction would be hung and even if rolled back by server admin the money would still be gone from account 32146 --- Is this actually correct, or is it correct but there is a different way to do this with MySQL? Thanks, Bryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: transaction support
Well, I think this statement does it all, http://www.google.com/groups?hl=enlr=ie=UTF-8oe=UTF-8q=MySQL+toy+marston Subject: Re: Can MySQL table handle 3 million+ entries? Newsgroups: comp.lang.php Date: 2003-04-11 15:20:10 PST MySQL is NOT a toy database - it is far superior to many I have used in my long career. The lack of constraints is NOT a weakness. It is eminently possible to create reliable applications without the need for database constraints - I should know because I have designed and built many applications that did not use database constraints (mainly because they were not available). Developers only rely on database constraints to circumvent their sloppy code. Anything that can be done within the database can also be done within application code. I have seen what happens when poor programmers try to shift logic from their code into the database - they get it wrong and then blame the database for their incompetence. I am used to designing and building applications without relying on database 'features', so I write my code accordingly. It also means that the logic is maintained in one place and not it bits and pieces here and there. Tony Marston http://www.tonymarston.co.uk/php-mysql/index.html some advantage does MySQL have, Rock stable, fast, good support, I got much respone from a comparison about what other developers feel here, http://groups.google.com/groups?q=mysql+gulbrandsen+rdbmshl=enlr=ie=UTF-8oe=UTF-8selm=60ca69db.0308210016.822e230%40posting.google.comrnum=1 Yours sincerely Morten Gulbrandsen - Original Message - From: Bryan Koschmann - GKT [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 3:37 AM Subject: transaction support Hi, I'm trying to get a software designer to write us some software using MySQL as the database server (he currently requires MS SQL). It is all windows based software (written in VB). So far his arguments against it are this (not my words): -No explicit transactional support -MySQL is still buggy -MyODBC is buggy and not used in production environments -Only way to connect using ODBC is third party drivers that cost over half as much as MS SQL This is just for our current software, the new software he is bidding on says he would use .NET so that supposedely causes other problems. Now, I know there are a few discrepancies there but I just don't know enough to argue it. I * need* to use MySQL as the server because of cost reasons. I *WANT* to use MySQL because I don't care for MS choose not to run their products. If you can give me any information to help me argue this I would really appreciate it. Thanks, Bryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: transaction support
Bryan Koschmann - GKT [EMAIL PROTECTED] [2004:01:05:18:58:12-0800] scribed: snip / Here is the explanation I just received when asking for the difference between transaction support: - MySQL uses single-action implicit and explicit transactions, but they do not automatically roll back on failure. SQL Server user single action implicit and batch explicit transactions as well as supporting transaction nesting (transactions inside of parent transactions) and on failure the entire batch and any parent / peer transactions are rolled back. http://www.mysql.com/doc/en/InnoDB.html http://www.mysql.com/doc/en/InnoDB_Deadlock_detection.html http://www.mysql.com/doc/en/Error_handling.html hth -- Best Regards, mds mds resource 877.596.8237 - Dare to fix things before they break . . . - Our capacity for understanding is inversely proportional to how much we think we know. The more I know, the more I know I don't know . . . -- pgp0.pgp Description: PGP signature
Re: transaction support
Bryan Koschmann - GKT wrote: [MySQL] 1: START TRANSACTION 2: WITHDRAW $50 from account 32146. 3: DEPOSIT $50 into account 12345. 4: LOG transfer (date/time/teller/etc...) for auditing. 5: COMMIT TRANSACTION if this failed at step 3 the transaction would be hung and even if rolled back by server admin the money would still be gone from account 32146 It depends why step 3 failed. Have a look at http://www.innodb.com/ibman.php#Error_handling If you want to rollback the transaction to the beginning on any error, you simply use an 'on error' statement in VB to trap the error, and send a rollback command when the error is detected. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: transaction support
Hi, I have been using MySQL since 3.2x and now 4.0.1x in Windows NT and Windows 2000 IIS / .asp environment including MyODBC for more than 4 years now, and never lost any data. Setup problems have been solved by reading and following instruction in the manual, or asking in the support / newsgroups. So, you can have a pricewise cheap database (remember to contribute to the company), with free worldwide support, or a expensive SQL server with only payable support - if you contribute the same amount to MySQL as to MS, you might probably (almost) get your personal supportline. Best regards Peter Copenhagen denmark - Original Message - From: Bryan Koschmann - GKT [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 3:37 AM Subject: transaction support Hi, I'm trying to get a software designer to write us some software using MySQL as the database server (he currently requires MS SQL). It is all windows based software (written in VB). So far his arguments against it are this (not my words): -No explicit transactional support -MySQL is still buggy -MyODBC is buggy and not used in production environments -Only way to connect using ODBC is third party drivers that cost over half as much as MS SQL This is just for our current software, the new software he is bidding on says he would use .NET so that supposedely causes other problems. Now, I know there are a few discrepancies there but I just don't know enough to argue it. I * need* to use MySQL as the server because of cost reasons. I *WANT* to use MySQL because I don't care for MS choose not to run their products. If you can give me any information to help me argue this I would really appreciate it. Thanks, Bryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: transaction support
Hi We have been running MySql since 1998 and have never had any data corruption We have servers running millions of queries a day and they are bullet proof. Hi, I'm trying to get a software designer to write us some software using MySQL as the database server (he currently requires MS SQL). It is all windows based software (written in VB). So far his arguments against it are this (not my words): -No explicit transactional support wrong http://www.mysql.com/doc/en/ANSI_diff_Transactions.html -MySQL is still buggy wrong MySql code audit showed it was 6 times less buggy than most commercial software http://www.reasoning.com/newsevents/pr/12_15_03.html just whisper the word 'slammer' in his ear and see what response you get :) -MyODBC is buggy and not used in production environments don't know - we use php, but I have used MyODBC occasionally without problems -Only way to connect using ODBC is third party drivers that cost over half as much as MS SQL wrong MyODBC is available under GPL http://www.mysql.com/products/myodbc/index.html unless you sell your software in which case licence fees may be due, but they are very reasonable. HTH Peter This is just for our current software, the new software he is bidding on says he would use .NET so that supposedely causes other problems. Now, I know there are a few discrepancies there but I just don't know enough to argue it. I * need* to use MySQL as the server because of cost reasons. I *WANT* to use MySQL because I don't care for MS choose not to run their products. If you can give me any information to help me argue this I would really appreciate it. Thanks, Bryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Transaction support
# [EMAIL PROTECTED] / 2003-06-24 15:15:33 +0530: Does MYSQL support transaction concept, which includes issues like commiting data , rollbacking etc??? Did you know MySQL has documentation? -- If you cc me or remove the list(s) completely I'll most likely ignore your message.see http://www.eyrie.org./~eagle/faqs/questions.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Transaction support
# [EMAIL PROTECTED] / 2003-06-24 12:29:33 +0200: # [EMAIL PROTECTED] / 2003-06-24 15:15:33 +0530: Does MYSQL support transaction concept, which includes issues like commiting data , rollbacking etc??? Did you know MySQL has documentation? # [EMAIL PROTECTED] / 2003-06-24 04:00:02 -0700: Roman Neuhauser wrote: # [EMAIL PROTECTED] / 2003-06-24 15:15:33 +0530: Does MYSQL support transaction concept, which includes issues like commiting data , rollbacking etc??? Did you know MySQL has documentation? Yes mysql supports transactions ... they only work on innodb bdb and gemini table types # [EMAIL PROTECTED] / 2003-06-24 19:07:46 +0800: Hello, Roman Neuhauser, Install Innodb,mysql really has transaction,u may use java code with it or run sql statment directly in mysql. === At 2003-06-24, 12:29:00 you wrote: === # [EMAIL PROTECTED] / 2003-06-24 15:15:33 +0530: Does MYSQL support transaction concept, which includes issues like commiting data , rollbacking etc??? Did you know MySQL has documentation? I have sent a followup to a post to this list, and received two off-the-list replies as if I had asked the original question instead of answering it. This is not the first time such thing has happened, and given this behavior is specific to this list I wonder whether MySQL attracts people with reading problems? -- If you cc me or remove the list(s) completely I'll most likely ignore your message.see http://www.eyrie.org./~eagle/faqs/questions.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Transaction support
Palaparthy [EMAIL PROTECTED] wrote: Does MYSQL support transaction concept, which includes issues like commiting data , rollbacking etc??? Yes. http://www.mysql.com/doc/en/ANSI_diff_Transactions.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Transaction Support with MyISAM
On Wed, Mar 26, 2003 at 09:03:35PM -0800, Nitin Nanivadekar wrote: Dear Friends, The last help I got was truly worth a zillion. Such a bargin! 1. How can i have commit/rollback functions using MyIsam database which is default database engine for MySql? i am using vb You cannot. MyISAM tables are not transactional. BDB and InnoDB are. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.8: up 51 days, processed 1,775,767,802 queries (396/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Transaction Support with MyISAM
Mr. Zawodny is right MyISAM natively does not support Transactions, but Transactions can be done with a set of myISAM tables and a lot of code specific to supporting transactions w/o a race condition. Basically it's a long a tedious process of writing code to support a ticket server (a unique id for every row in any table separated out into a different table or database), then use this to simulate a commit and rollback. If you go this route (don't: use INNODB) you'll have to worry about race conditions, bugs etc. -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 11:48 PM To: Nitin Nanivadekar Cc: [EMAIL PROTECTED] Subject: Re: Transaction Support with MyISAM On Wed, Mar 26, 2003 at 09:03:35PM -0800, Nitin Nanivadekar wrote: Dear Friends, The last help I got was truly worth a zillion. Such a bargin! 1. How can i have commit/rollback functions using MyIsam database which is default database engine for MySql? i am using vb You cannot. MyISAM tables are not transactional. BDB and InnoDB are. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.8: up 51 days, processed 1,775,767,802 queries (396/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Transaction Support in mysql13.23.54
hi, i have installed mysql3.23.54 on windows and have followed all instructions as required for using mysqld-max to have transaction support. i have created a table using TYPE=INNODB, but cannot use rollback on it. the error i get in my jsp is transactions not supported. please advice me on how i can use commit - rollback on mysql database tables. I am connecting to the mysql database thru my java web-app. thank you in advance. regards, nirmal (23 jan 03) Go to this page: http://www.innodb.com/howtouse.html and have a look under: How to create tables in the InnoDB format. Basically you will at least have to specify this line in C:\WINDOWS\my.ini and restart your mysql-max server: innodb_data_file_path=ibdata1:30M All the best, Pål Arne Hoff - 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 mysql13.23.54
Correct me if I am wrong, but I believe mysql 3.23.54 does not support transaction support, version 3.23.54 has row locking only. Transaction feature starts with version 4.0.x. Bob - Original Message - From: Nirmal Shah [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, January 22, 2003 7:56 PM Subject: Transaction Support in mysql13.23.54 hi, i have installed mysql3.23.54 on windows and have followed all instructions as required for using mysqld-max to have transaction support. i have created a table using TYPE=INNODB, but cannot use rollback on it. the error i get in my jsp is transactions not supported. please advice me on how i can use commit - rollback on mysql database tables. I am connecting to the mysql database thru my java web-app. thank you in advance. regards, nirmal (23 jan 03) __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - Before posting, please check: http://www.mysql.com/doc/ (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] - 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 mysql13.23.54
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wednesday 22 January 2003 08:56 pm, Nirmal Shah wrote: hi, i have installed mysql3.23.54 on windows and have followed all instructions as required for using mysqld-max to have transaction support. i have created a table using TYPE=INNODB, but cannot use rollback on it. the error i get in my jsp is transactions not supported. please advice me on how i can use commit - rollback on mysql database tables. You might check your connection to, I received a similar on a machine connecting through perl/DBI, and the problem was that the DBI package merely needed upgrading, mysql had been set up correctly. If your mysql really is set up right, you could verify this by trying to perform a transaction via command line. If it works there, it's your connection most likely. - -- - --Jayce^ -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQE+MCoIA10/0O8cAHgRAgRWAKC1sZxyOoV+He8dZSe+vHbmTwlyMgCfVqrs c6+peQEq9/gIBwOxASBfYDk= =Y/8s -END PGP SIGNATURE- - 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 mysql13.23.54
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Robert Tam wrote: Correct me if I am wrong, but I believe mysql 3.23.54 does not support transaction support, version 3.23.54 has row locking only. Transaction feature starts with version 4.0.x. Bob You're corrected :) 3.23.54 supports InnoDB which has transactions. The real question is, is what JDBC driver is giving the problems with 'No Transaction Support' It either must be a very old version of MM.MySQL or the JDBC-ODBC bridge. You should upgrade to MySQL Connector/J 3.0.x (Which is what MM.MySQL has become, now that I, the developer behind MM.MySQL am employed by MySQL AB). It supports transactions :) See http://www.mysql.com/products/connector-j/ -Mark - -- MySQL 2003 Users Conference - http://www.mysql.com/events/uc2003/ For technical support contracts, visit https://order.mysql.com/?ref=mmma __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mark Matthews [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.1.90 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE+MFZFtvXNTca6JD8RArklAKCnRX99M+OiVYm0gclzJj+b5xeAiQCgkU0D Gz1lK5Yw1qSxK7/V6pK/Mpw= =kUJ5 -END PGP SIGNATURE- - 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 mysql13.23.54
I had this problem with my new install on windows. In my case in turned out to be that the tables were not created as innoDB even though I had specified type=innoDB. I'm not sure why this happened but I fixed the problem by recreating the tables after I made sure that I have innoDB server running. I issued NET STOP MySQL to shut down the mysql server that was running and started mysqld-max-nt --console And then I recreated my tables with type=innoDB option and it worked. - Original Message - From: Jayce^ [EMAIL PROTECTED] To: Nirmal Shah [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, January 23, 2003 9:44 AM Subject: Re: Transaction Support in mysql13.23.54 -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wednesday 22 January 2003 08:56 pm, Nirmal Shah wrote: hi, i have installed mysql3.23.54 on windows and have followed all instructions as required for using mysqld-max to have transaction support. i have created a table using TYPE=INNODB, but cannot use rollback on it. the error i get in my jsp is transactions not supported. please advice me on how i can use commit - rollback on mysql database tables. You might check your connection to, I received a similar on a machine connecting through perl/DBI, and the problem was that the DBI package merely needed upgrading, mysql had been set up correctly. If your mysql really is set up right, you could verify this by trying to perform a transaction via command line. If it works there, it's your connection most likely. - -- - --Jayce^ -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQE+MCoIA10/0O8cAHgRAgRWAKC1sZxyOoV+He8dZSe+vHbmTwlyMgCfVqrs c6+peQEq9/gIBwOxASBfYDk= =Y/8s -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/doc/ (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] - 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
Re: Transaction Support
On Mon, Oct 22, 2001 at 11:14:58AM -0400, Victor wrote: Hello As I understand it, MySQL with InnoDB or BDB support can support transactions. Is there a doc on the shortcomings of these tables and which one is better? MySQL documentation has a shortcomings page for InnoDB (but couldn't find one for BDB) http://www.mysql.com/doc/I/n/InnoDB_restrictions.html Any suggestions with which type to go with? What have been the experience with either/both? How does the future look for both? The future looks very bright for InnoDB. It is faster and scales better than BDB, and it uses more granular locks. Both maintain log files to do rollbacks. Is this how PGSQL does this too? InnoDB uses a mult-versioning scheme, which is what PostreSQL does. So in that respect they're quite similar. How do these tables compare to dbs with native transaction support (like Oracle, MSSQL, and PostgreSQL) ? InnoDB was largely modeled after Oracle. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 46 days, processed 1,018,046,439 queries (253/sec. avg) - 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
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