transaction-isolation
What are the conditions for encountering a serialization failure in PostgreSQL?
The PostgreSQL manual page on the Serializable Isolation Level states: [Like] the Repeatable Read level, applications using this level must be prepared to retry transactions due to serialization fai[详细]
2023-04-11 15:09 分类:问答Best way to retry a transaction with Seam & Hibernate
I\'ve got a Seam web application working with Seam & Hibernate (JDBC to SQLServer). It\'s working well, but under heavy load (stress test with JMeter), I have some LockAcquisitionException or Opt[详细]
2023-03-19 01:56 分类:问答Does MySQL/InnoDB implement true serializable isolation?
It is not entirely clear from MySQL documentation whethe开发者_C百科r the InnoDB engine implements true serializable isolation1 or snapshot isolation, which is often confusingly called \"serializable\[详细]
2023-03-11 20:39 分类:问答Practical uses of Seralization Isolation level?
Under what scenarios we use SERIALIZABLE Isolation level? I have seen some answers on website that says, when you want transaction to be completely isolated, we usually go for this.[详细]
2023-02-27 15:17 分类:问答Is Database Connection same as Session?
I\'m bit confused about relationship between a Database Open Session Connection pooling To elaborate, I\'开发者_运维百科m using JDBC with Oracle 9i DB and I\'m also using a Connection Pool to poo[详细]
2023-02-27 11:43 分类:问答SQL Server Insert query for a forum
Considering a forum table and many users simultaneously inserting messages into it, how safe is this transaction?[详细]
2023-01-29 00:37 分类:问答How do I use a transaction when reading data with Entity Framework 4?
I\'m trying to utilize the SNAPSHOT transaction isolation level in Microsoft SQL Server 2008 R2 with the Entity Framework 4.0. However, this doesn\'t seem to be as easy as I first thought.[详细]
2023-01-24 15:37 分类:问答how to lock a DB table or a range of rows for writing?
I have a simple table with a primary key. Most of the read operations fetch one row by the exact value of the key.[详细]
2023-01-24 08:14 分类:问答Nhibernate : generates insert then update statements, in multithreaded environment leads to deadlock issues
I\'ve experienced the following scenario when using NHibernate with SQL Server 2005. I have a business process which involves the following steps:[详细]
2023-01-17 23:54 分类:问答how to sort Gridview rows by a unbound Template column
i want开发者_开发技巧 to sort my Gridview rows by a template column that is not bound to any database field. This template coulmn just has a label whose text i set in code depending on a value in a di[详细]
2022-12-23 22:25 分类:问答