Forum Topics Tagged [transaction]

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 a particular query within the transaction: *Query error: Deadlock found when trying to get lock; try restarting transaction - Invalid query* When that happens, the entire transaction is rolled back. However, this is not ideal because when someone attempts to make a post, we don't want it to completely fail …

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 transactions? does it would lock the table and prevent other client to perform there query? what would happen if other client issue a transaction query while the other client still have unfinished transaction? I appreciate for any help will come. P.S. most likely i will use insert using a file …

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 3.5 The connection string contains `Enlist=True`. The code is the following (a little different than the one posted in the bug report, but it acts the same): public partial class frmMain : Form { private TransactionScopeOption transactionScopeOption; private TransactionOptions transactionOptions; public frmMain() { InitializeComponent(); transactionScopeOption = TransactionScopeOption.Required; transactionOptions = new …

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 one tell me what is wrong with this code, each method has its own connection object also private void btnsave_Click(object sender, EventArgs e) { using (SqlConnection Contr = new SqlConnection(CS)) { SqlTransaction Trn; Contr.Open(); Trn = Contr.BeginTransaction(); try { CreateAttendent(txtstudentno.Text); CreateClassPayment(); formSMSContents(); ParamList P = new ParamList(); P.UPDATESMSPORTAL(txtsmstpnumber.Text.Trim(), txtsms.Text.Trim(), DateTime.Now, …

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 the trigger statement to update data that is not given block BEGIN TRANSACTION in SQL Server 2000 while it had no effect. Does the complexity of SQL server 2008 which made ​​it should not be violated? It points what should be considered when migrating from SQL server 2000 to sql …

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

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 4 pages, and they all slide horizontally. I tried to achieve this with the following code: **HTML** <div id="content"> <div class="pages"> <div id="page1"> <div class="header"></div> <!--divs inside would depend on the content --> </div> <div id="page2"> <div class="header"></div > <!--divs inside would depend on the content --> <div class="inner-content"></div> </div> …

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 in advance using (TransactionScope scope01 = new TransactionScope(option01, span01)) { InsertIntoTable(); // inserting a row into Foo table , insert into...executenonquery string smcd = "select * from Foo Where XCol=@XParm"; ExecuteQuery(scmd); // This Returns no result scope01.Complete(); }

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

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 is imp to know about MSSQL TRANSACTIONS . as i am not good in mssql so please use simple language :P , i have experience of working in mssql about 2 years , i know about , joins , pivot , functions , views , stored procedures ,but this mssql …

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 not want to open/close multiple connections and I do not want any "locks" on my database tables is this a good way to go ahead with this? Thanks

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 don't know how will i insert it in there since i've been receiving too much errors if i do so... and, if you don't mind, how will i post my code so you guys can check my crap program..lol~.. thanks~ :?:

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 lock the row as a user reads the table and release it only when the transaction commits or rollbacks. I am doing this as follows with no success. Please help me in the correct way. get the connection Set the auto commit of the connection as false. query the serial …