On using Terracotta as a persistence solution.
Would it be a good idea to use Terracotta as a persistence solution (replacing a database)? I'm specifically wondering about data integrity issues and support for transactional systems. ...
transactions
Multiple database transactions on a single connection
I have a multi-threaded program whereas each thread, at the start of execution, acquires a single connection from a MySql connection pool class. The thread then uses a number of database table wrapper classes to do its business logic by passing its database connection to the wrapper classes. The operations on these wrapper classes are no...
NHibernate Transactions Best Practices
I have been reading about Nhibernate for a while and have been trying to use it for a site I'm implementing. I read the article by Billy McCafferty on NHibernate best practices but I did not see any indication on where is the best place to handle transactions. I thought of putting that code in the Data Access Object (DAO) but then I'm ...
SQL Server UNDO
I am a part time developer (full time student) and the company I am working for uses SQL Server 2005. The thing I find strange about SQL Server that if you do a script that involves inserting, updating etc there isn't any real way to undo it except for a rollback or using transactions. You might say what's wrong with those 2 options? We...
What is the best default transaction isolation level for an ERP, if any?
Short background: We are just starting to migrate/reimplement an ERP system to Java with Hibernate, targeting a concurrent user count of 50-100 users using the system. We use MS SQL Server as database server, which is good enough for this loads. Now, the old system doesn't use any transactions at all and relies for critical parts (e.g. ...
Fail to read uncommitted data from same session in MySql/.net connector
I've been banging my head against the wall with this one, may be someone can shed some light as of to what may be causing this behavior. I have an asp.net (2.0) app that as some point does: using(TransactionScope scope = new TransactionScope(...)) { //... do a bunch of some queries InsertOrder(); InsertOrderDetails(); // do some m...
How to Save Record to Relational Tables With Linq To Sql
I have three tables like that: Articles IdArticle Title Content Tags IdTag TagName ContentTag IdContentTag Idtag IdContent When user in my site write an article with adding tags and submit, I want to save it to tables above. In traditional ways, I used to use transaction and I could do it. But How can I do it by using linq to sql? ...
How Do I Follow A T-SQL Transaction?
Are there any programs that will allow you to follow a sql transaction through to it's end? For instance, say I've inherited a rather complex sql database with a data dictionary. The data dictionary is pretty good, but not as good as say, SQL Doc. I've taken a look at Red Gate's Dependency Tracker and, while that does a very good job ...
Can different connections of the same sqlite's database begin transactions concurrently?
I met with a strange problem about sqlite3. I obtained different connections of the same database file using open() method. connection 1 begins a transaction, and connection 2 begins another transaction, which is to update several records of a table. Then connection 1 commit the transaction, followed by connection 2 commit its transactio...
in sqlite3, can a select succeed within a transaction of insert?
I begin a transaction, which is to insert several records into a table. Can I select the latest inserted record out of the database before the transaction commit? ...
Pessimistic lock in T-SQL
If i SELECT a row for updating in MS SQL Server, and want to have it locked till i either update or cancel, which option is better :- 1) Use a query hint like UPDLOCK 2) Use REPEATABLE READ isolation level for the transaction 3) any other option. Thanks, Chak. ...
How can I enlist an ODBC connection in an XA 2PC transaction?
Our application uses ODBC to communicate with a database (Both DB2 and Oracle, if it makes a difference), and delegates business logic to Java by way of JNI (So it uses Java and C). What I'd like to know is what tools / software / libraries are needed to allow the business logic (Java/JDBC) and the application framework (C/ODBC) to part...
SQLTransaction and T-SQL transactions
I am using .NET 2.0 and SQL Server 2005. For historical reasons, the app code is using SQLTransaction but some of the stored procedures are also using T-SQL begin/commit/rollback tran statements. The idea is that the DBTransaction can span many stored procedures, which each individual sproc controls what's happening in its scope - in eff...
SELECT FOR UPDATE for locked queries
I'm using MySql 5.x and in my environment, I have a table with the name CALLS. Table CALLS has a column status which takes an enum {inprogress, completed}. I want reads/updates of the table to be row-locked, so: SET TRANSACTION ISOLATION LEVEL SERIALIZABLE; SET AUTOCOMMIT = 0; SELECT amount from CALLS where callId=1213 FOR UPDATE; COM...
NHibernate Transactions in Open View per Session - suggested practices?
Cleaning up some transactional logic and wondered how other people were handling it. Ayende's recommendation seems to be to handle transactions at the service boundary. This is a ASP.NET web app though, so it hasn't got a clear cut service boundary, at least not right now. What do people do? Create a single transaction per request i...
Multiple Connections With Same Connection String Under A Single Transaction, Elevated Transaction?
When using ado.net, and creating multiple connections to a MS SQL Server database within a single transaction (using System.Transactions.TransactionScope), does System.Transactions elevate the transaction from the lightweight transaction manager to the distributed transaction coordinator (kernel transaction coordinator on Vista), even if...
Strategies to Avoid Transaction Escalation in System.Transactions
So, based on the answer to my previous question, transactions do get elevated from the LTM to the DTC if multiple connections are opened during a transaction, even if the connections all have the same connection string. So, my next question is, what strategies could one employ to avoid this "feature?" It seems to me that, based on resou...
Strange SQL2005 problem. "SqlConnection does not support parallel transactions"
Hi. I have a problem that seems like its a result of a deadlock-situation. Whe are now searching for the root of the problem but meantime we wanted to restart the server and get the customer going. And now everytime we start the program it just says "SqlConnection does not support parallel transactions". We have not changed anything i...
HibernateTransactionManager(Spring) with multiple Session Factories
I have a DAO implementation that uses a HibernateTransactionManager for transaction management and the application has 2 session factories. I am getting an exception at the transactionManager.commit() line below. Does performing Hibernate operations within a transaction manager related to a different session factory cause problems? Tran...
SQLite 3 C API Transactions
I am using SQLite3 for iPhone development and I'm attempting to wrap a few insert statements into a transaction. Currently I have the below code which is working properly however after reading another question on SO I realized it would be better to have these in one transaction rather than one each. I couldn't find the C API call to begi...