Can we set the index active when another transaction is in开发者_JS百科 progress. Will firebird wait till the other transaction completes its operation and the index will become inactive/active (this
in our current project we are using ADO.NET Entity Framework as data layer for the application. There are some tasks which require to run in a transaction because there\'s a lot of work to do in the d
I\'m using Struts + Hibernate + Spring for my project development. And here is my Spring Context XML file. When I called \"sessionFactory.getCurrentSession()\" in the beginning of userDao.getXXXX meth
What is the best-practice in dealing with开发者_C百科 MySQL Dead-Locks in PHP? Should I wrap all database calls in a try{}catch{} block and look for the DeadLock error code from the database? Do I the
I have some ad-hoc reporting users hitting some SQL Server views. Occasionally the read locks taken by these users for particularly lengthy queries caus开发者_开发问答es trouble elsewhere in the syste
I\'m trying to implement two-phase commit using PHP and MySQL, and coming up short. The main block I\'ve found is that I\'m unable to store the MySQL connection resource in a place where I can find i
I have some basic confusion about how transactions and msdtc work together. I have a basic server/client winforms app. The app uses transactionscope to encapsulate several sql commands that are execu
I am new to ADO.NET and learning it. I was wondering if Data Adapter in ADO.NET provides atomicity or ACID properties by itself when filling the Data Set and updating the Database, or do we have to us
I get following error randomly when executing code from debug mode. Cannot access a disposed object. Objec开发者_JAVA技巧t name: \'SqlDelegatedTransaction\'.
I have a situation where I have a tree of Entities, and a Session Bean. The Session Bean simply persists or merges the entities, and the method in question is marked as @TransactionAttribute(Transacti