20 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 … |
|
DaniWeb was written in Codeigniter, and when posting to the forums, we use database transactions that look like this: $this->db->trans_start(); ... insert into the posts table ... ... update the member's post count ... ... update the tags table ... etc $this->db->trans_complete(); On occassion, the error log will show for … |
|
I need help with implementing MySQL transactions with PHP. Specifically, I'm confused between the flags `WITH CONSISTENT SNAPSHOT`, `READ WRITE`, and `READ ONLY`, what their differences are, and how they relate to table locking. I already read the MySQL reference manual but I'm still confused. |
|
It could be a dumb question, and tried to search for it and found nothing. I been using mysql for years(not that to long) but i never had tried mysql transactions. Now my question is, what would happen if i issue an insert or delete statement from multiple clients using … |
|
I've posted a bug report here: http://tracker.firebirdsql.org/browse/DNET-540 If someone using Firebird and C# could verify this for me, or shed some light on (other) possible issues, that would be much appreciated. The code works as expected with 2.5.1, but does not with 2.5.2. Note: the sample is built on .NET … |
|
Hi Guys I have a problem while an error and rollback Please check this example if i have an error at **CreateClassPayment()** method, it will go and execute rollback function but it doesn't rollback the transaction at **CreateAttendent()** but will not go for next transactions also **formSMSContents() and UPDATESMSPORTAL()**,can any … |
|
When I try to migrate from SQL Server 2000 to SQL Server 2008 R2 Express, when I run the application program there is an error message transaction aborted by the trigger, whereas before when I was using SQL Server 2000 does not exist error. after there was a note on … |
|
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 … |
|
Okay so I received a request from a client who wanted me to make him an HTML website, but something new. All the pages would be in the same index.html file, and every page would slide horizontally. What he wants is: www.goldmansachs.com As you can see, the main document has … |
|
I have a transaction, there is a method calling in the tran. which makes insertion into a table, after that when i select the row that i have inserted, i find no result how can i solve this problem without changing this structure or what else can i do? Thanks … |
|
i am using the below code for creating the connection to database. connectionURL = "jdbc:oracle:thin:@//testdsfsdfgs:1521/TEST"; conn = DriverManager.getConnection(connectionURL, userName,Password); i want to set the transaction time out. How can i do that. Please some one help. Thanks in advance |
|
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 |
|
try { mysql_query("INSERT xyz"); mysql_query("INSERT xyz"); mysql_query("INSERT xyz"); commit() } catch (Exception $e) { rollback() } I would like so that if any of the queries within the try { } fails, to go to the exception and rollback the transaction, and commit otherwise. What kind of things will it … |
|
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 … |
|
Hello yall, I'm starting to work with Paypal (just signed up for x.com and sandbox). I was looking at the DoDirectPayment API for credit card transactions. One of the required fields kinda took me by surprise. Here it is. [CODE] IPADDRESS (Required) IP address of the buyer's browser. Note: PayPal … |
|
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 … |
|
I was reading through the SIP documentation and was confused on a few things. I can't figure out what code to implement to open a transaction between a server and client. What IP address and port and what encoding should I use (for a video server). Thanks for any help. |
|
Hi All, In my development of an online application, I have to generage the serial no for the available number from the serial number table in sql server. Multiple users will hit the table to generate the serial numbers. So the serial number should not be repeated. I have to … |
The End.