[transaction] Forum Topics

Hey Gang! OK today I am having trouble with my transaction processing application implemented in python/MySQL. Here is some "working" testing code. import psycopg2 from psycopg2 import Error import binascii from binascii import unhexlify import mysql.connector as mysql sql='''CREATE PROCEDURE testprocedure(OUT tacos INT) BEGIN show tables; SET tacos := 1 …

I was consistently receiving MySQL "Packets out of order" error messages when attempting to connect to MySQL, mostly on my AJAX pages, but I couldn't attribute it to anything or reproduce it in any way. I did notice, however, that when switching MySQL persistent connections from on to off, the …

hi I had a question in an exam that asked for the code of a trigger that cancels a transaction if a query result doesn't meet a condition in oracle database. is it possible? I am googleing but I can't find an answer thanks

hello ! how are you all , hope all of you are in great state of health and peace , well i have some questions , 1- WHAT IS MSSQL TRANSACTIONS . 2- where we use it. 3- Advantages /Disadvantages 4- Any imp information or point which you think it …

Hi, I'm using SQL Enterprise Library (Microsoft.Practices.EnterpriseLibrary.Data.Sql) objects and I'm considering using a DbTransaction to execute multiple DbCommand(s) for inserts/updates in one transaction. Let's say these queries take a few minutes to execute, I do not want it to prevent another process from queries the same tables. Considering I do …

I've made a program of basic bank transaction. I'm having a hard time figuring out how will that cin >> newb; and cin >> currentb; work out...the program works if you remove the formulas..also i'd like to add if (withdraw <=10000) the program will stop the user from withdrawing but …