Is there a way to list open transactions on SQL Server 2000 …
Does anyone know of any way to list open transactions on SQL Server 2000 database? I am aware that I can query the view sys.dm_tran_session_transactions on SQL 2005 (and later) …
java - Could not commit JPA transaction: Transaction marked as ...
Could not commit JPA transaction: Transaction marked as rollbackOnly This exception occurs when you invoke nested methods/services also marked as @Transactional.
The transaction log for the database is full - Stack Overflow
I have a long running process that holds open a transaction for the full duration. I have no control over the way this is executed. Because a transaction is held open for the full duration, whe...
Getting "Lock wait timeout exceeded; try restarting transaction" …
mysql> update customer set account_import_id = 1; ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction I'm not using a transaction, so why would I be getting this …
sql server - How to use SqlTransaction in C# - Stack Overflow
There is an Update query in progress, the Transaction is started at a higher level on the connection. In order to ensure that all server data is in a valid state for the Update, I need to …
How to check that there is transaction that is not yet committed in …
Does anyone know the command to check if there is an un-committed transaction in SQL Server 2005?
sql server - SQL Transaction was deadlocked - Stack Overflow
Sometimes I get this kind of exception on not very busy SQL server: Transaction (Process ID 57) was deadlocked on lock resources with another process and has been chosen as the …
What does a transaction around a single statement do?
BEGIN TRANSACTION / COMMIT "extends" this locking functionality to the work done by multiple statements, but it adds nothing to single statements. However, the database …
Row was updated or deleted by another transaction (or unsaved …
optimistic locking consists in detecting that another transaction has updated/deleted the same row, and throwing the exception you're getting in this case. If you have a version field, you're …
c# - Transactions in .net - Stack Overflow
The alternative is an ambient transaction; new in .NET 2.0, the TransactionScope object (System.Transactions.dll) allows use over a range of operations (suitable providers will …