Search DaniWeb - transaction

Multiple MySQL connections + transactions 1 Month Ago by Dani … a MySQL connection in the middle of a transaction with a different connection? e.g. // …Open Connection 1 and connect to Database A // Start transaction with Connection 1 // Write some stuff with Connection 1…Write some stuff with Connection 2 // Close the transaction associated with Connection 1 This is probably the … Re: Multiple MySQL connections + transactions 1 Month Ago by Dani …()` function to switch databases in the middle of a transaction? This is what got me into trouble in the… first place, when I started a transaction, performed some writes, switched databases, and then wrote … and performed some more writes, and then committed the transaction. I discovered that all of the writes that were performed… Re: Multiple MySQL connections + transactions 1 Month Ago by Salem … be explicit about which DB you really want at each transaction. Re: Multiple MySQL connections + transactions 1 Month Ago by Reverend Jim … based so you would have to manually roll back a transaction on A if the commit on B fails. Re: Multiple MySQL connections + transactions 1 Month Ago by Dani I am already using multiple MySQL connections throughout the project, as well as select_db() in some other places. My question specifically revolved around if anyone can explain why select_db() implicitly committed the transaction, and then when done again to return back to the initial database, it did a rollback instead of commit. Re: Multiple MySQL connections + transactions 1 Month Ago by toneewa …'re not suppose to switch databases with a connection mid-transaction. It's by design to rollback because it considers it… Buggy career talk :-P 1 Month Ago by Dani … is not realizing that you can’t use a MySQL transaction from within a persistent connection. Here’s [when I learned… Re: What makes a technical E-commerce web standout? 2 Months Ago by simplixi … on delivery, which are popular in the region. - Ensure secure transaction processes to build customer trust. **6. Logistics and Delivery:** - Develop… Re: Multiple MySQL connections + transactions 1 Month Ago by Reverend Jim In that case I can't suggest anything. I've never had to update multiple databases for any of the systems I set up. Re: Multiple MySQL connections + transactions 1 Month Ago by Dani > If the databases are on the same server and use InnoDB, you can use fully qualified table names, and write to multiple databases on a single connection. That's what I ultimately started doing instead! Thank you so much for a definitive answer to my question. Re: Buggy career talk :-P 1 Month Ago by Reverend Jim The most challenging bug was one I introduced myself. While making a miniscule code change I decided to improve the readability of the following line by inserting a space. In today's code that would not be a problem, however, most of our code (AGC/SCADA) was written in FORTRAN. Those of you who made your bones in the punch card era, or know a … Re: Buggy career talk :-P 1 Month Ago by pritaeas The one with the most impact was a Firebird library update, which appeared low to no impact. After deploying at a customer, the library soon showed a complete disregard for database transactions. This mangled the client's database completely and caused us to retrace all changes by hand to undo the damage done. Several weeks worth of misery... … Re: Buggy career talk :-P 1 Month Ago by Salem This https://en.wikipedia.org/wiki/Peterson%27s_algorithm Plus two different kinds of processors. Plus an error rate of less than once a week. After many months, the cause was eventually captured on a bus analyser. After which, the solution was obvious after a bit of RTFM. Turned out that one of the processors had the then awesome new … Re: Transaction table design 11 Years Ago by kau14 …having cl_id = 1 has paid some amount for transaction id =1 then credit should shown in front of…for that client against that particulat transaction then need debit entry for that transaction having transaction id =1. like wise …same client can make many transaction, will have diffrent transaction id's have to retrive all data eaisly… Transaction id is Not getting 17 Years Ago by rajeevkshr Hi all, I am using paypal for payment gate way integration .After successfull transaction i have to capture that transaction id.For sandbox account it was working fine.But for live transaction i am not getting that transaction id.Anybody can help me for doing this? With regards, Rajeev Re: Transaction table design 11 Years Ago by ryanjayson … Address, Contact, (Personal Info of the client/Etc) TRANSACTION TABLE Columns TransactionID(PK), ClientID(FK), TransactionType, TransactionDate, (…Fields that are related to transaction/Etc) Relationship of the tables are one:many, … transaction problem 15 Years Ago by Xessa … database. The problem is when i close the window the transaction continues to work. What can i do in my JSP… Java code to prevent this? Does that mean that my transaction is wrong? When the result data is not big, the… Transaction log file 13 Years Ago by Tank50 … in new server.Issue is after 4 days I saw transaction logs file size is more that 16GB in new server… .In old server transaction log file size is 250Mb.why transaction log file is more 16GB in new… Transaction table design 11 Years Ago by kau14 Hi, I need data table desgin for transaction table. I want transaction history for particular client having unique client_id but many having many transaction id's. transactions relate to credit, debit, transactor name and date. Regards Kaustubh Transaction Rollback logic ? 16 Years Ago by veledrom … goes wrong half way through i want to cancel whole transaction. For example; everything went ok for first 3 products and… this possible? I am trying to understand the logic behind transaction is made in a loop. Thanks Transaction management in DBMS 14 Years Ago by sumatistars What is a transaction and how transaction is managed in DBMS? Re: Transaction Rollback logic ? 16 Years Ago by dickersonka wrap your code with something like this [code] SET AUTOCOMMIT=0; START TRANSACTION; -- do your work here -- if failed do this ROLLBACK; -- if successful do this COMMIT; [/code] Re: Transaction Rollback logic ? 16 Years Ago by dickersonka … or rollback based upon them [code] SET AUTOCOMMIT=0; START TRANSACTION; BEGIN DECLARE addVar INT; INSERT INTO Table1 (col1, col2) VALUES… Re: Transaction management in DBMS 14 Years Ago by sumatistars how can transaction can be closed and then changes occur ? Transaction Where Its Works More Efficiently 18 Years Ago by windows_mss Hi programmer's, [B]Using Transactions in Windows application is more effective or using transaction in Web Application is More effective ?[/B] Thanks in Advance Transaction with Multiple database 13 Years Ago by ssreevidya.m Hi, I Need to implement transaction with two databases. I used LINQ for one database and … transaction management system 11 Years Ago by sirlordbanas I'm a final year student and I am now creating my project with the topic transaction management system of non banking institution, case study of noble dream micro finance. my proposal has be accepted but I don't know how to start the whole project from. so please I need your advice thank you Re: E-commerce Transaction 13 Years Ago by Ydeveloper Transaction is the part of ecommerce, where all transactions were carried over using an electronic platform. It works on a system which is built on an electronic platform. Re: transaction in .net 15 Years Ago by vinnijain …[URL="http://www.vbdotnetheaven.com/UploadFile/rahul4_saxena/Transaction09112007074327AM/Transaction.aspx"]http://www.vbdotnetheaven.com/UploadFile/rahul4_saxena/Transaction09112007074327AM…/Transaction.aspx[/URL] [URL="http://www.codersource.net… Re: transaction in .net 15 Years Ago by avirag … tranaction in .net[/QUOTE] Well for reading more about .net transaction you can refer following links also: [url]http://msdn.microsoft…