ACID and database transactions?
What is the relationship between ACID and database transaction? Does ACID give database transaction or is it the same thing? Could someone enlighten this topic. ...
transactions
how to implement ws-at transactions in appfabric applications
in the following forum post, a microsoft person indicated that there is no ws-at transaction support exposed in AppFabric but that something abut WS-AT transactions can become involved with an AppFabric call by using the WCF transactionScope options: http://social.msdn.microsoft.com/Forums/en-US/dublin/thread/1a34bff2-1ce3-4e28-8c3b-96...
Over 3.000 transactions in CakePHP. How?
We are doing an import of Magento-products into a CakePHP environment over SOAP. We have like 3.000 products and of course we want to keep the database clean of duplicate entrys. We use InnoDB as product-databse in CakePHP. We had different approaches: We set the validate var on the product model and want the product-id to be unique....
Problem with insert using asp.net, mysql and transactions
I'm using asp.net and MySql to insert data into a table using transaction. I loop through a list of items and inserts them to the table. This code runs quite often and the problem I am having is that sometimes when I insert data one of my parameters is null when inserted into the database but it shouldn't be null. I have started logging...
nhibernate and nested transactions
I know that nhibernate doesnt support nested transactions. Let's say that I got something like this: UserService.BeginTransaction (on current session) UserService.Save UserService->FeedService FeedService.BeginTransaction (on current session) FeedService.Save FeedService.Commit (on the returned transaction in #3.1) UserService->Add...
Identity columns for multitenant database schemas
I'm creating a multitenant app where some of the tables need to have sequentially assigned integer values. The ordering is done independently for each tenant. As a concrete example, consider a Student table with a RegNumber column. RegNumber has to be assigned sequentially, but the sequence is local to each tenant. The solution I'm thin...
How does SqlConnection manages IsolationLevel?
This MSDN article states that: An isolation level has connection-wide scope, and once set for a connection with the SET TRANSACTION ISOLATION LEVEL statement, it remains in effect until the connection is closed or another isolation level is set. When a connection is closed and returned to the pool, the isolation level...
Getting NHibernate session to see uncommited, external ADO.NET changes within TransactionScope
I have some code that does something like this: public void DoDatabaseWork() { _repositoryIDontControl.SaveSomeStuff(objectThatNeedsStuff.Stuff); using (var session = ... ) { session.Save(objectThatNeedsStuff); } } The crux here is that within my NHibernate mapped data model I have an object that references anothe...
Why doesn't my (spring)HibernateTransactionManager work in wicket?
I tried to shorten this to what I think is relevant, I hope it's sufficient and not overwhelming. Please help! I'm converting a small wicket+databinder+hibernate web application to use wicket+spring+hibernate. I have a DAO service class, with a hibernate SessionFactory injected by Spring. I am able to do read-only operations using the s...
Aborting a change to a node from a module
I'm building a module for Drupal 6 (what it does isn't wildly important; I've spent a long time looking for other solutions to this problem and rolling my own is definitely the simplest), and I've run into something of a conceptual road-block. Much like the uploadpath module, I'm creating a directory based on (via a replacement pattern)...
Transactions on iSeries using .NET provider
Hello guys, i have multiple inserts to do so i want to do them in a transaction by calling a stored procedure on the iseries. I can't get it to work, it auto commits every insert i do so i figured i would try to do a transaction with just a simple file first and then go from there. The file is productest/cepf05 and when i first did the ...
MySQL transactions: multiple concurrent transactions and data integrity
I'm using transactions for managing data across several MySQL InnoDB tables in a reasonably complex web application. Briefly, a given transaction works as follows: Data is read from a row in a "user_point_totals" table Various machinations calculate what the user's new point total should be A new entry is created in the "user_point_to...
Exception escapes from workflow despite TryCatch activity
I have a workflow inside a Windows Service that is a loop that performs work periodically. The work is done inside a TryCatch activity. The Try property is a TransactionScope activity that wraps some custom activities that read and update a database. When the transaction fails, I would expect any exception that caused this to be caught b...
Concurrent Database transactions
My requirement is to fetch a unique ID from the database for processing on the application server(clustered application).For this , I have a table with single cell, holding a value X. This value will be incremented everytime it is fetched. BEGIN TRAN UPDATE ID_TABLE SET VALUE = VALUE + 1 SELECT VALUE FROM ID_TABLE END TRAN ...
how the Transaction concept is implemented in EJB
I wan to know how the transaction is internally implemented in EJB. I want to know the logic they use to create a transaction. if you could point out some articles that would be helpful ...
system requirement for oracle large transaction (say 100GB)
I am using oracle database. If have a large transaction to make (700 tables, million rows , data size will be around 100G) what are the parameters to be fined tuned? The oracle server has disk space of 250G, 32G RAM. (Is this a question for superuser/serverfault? Please move) ...
Java Google Appengine sharded counters without transactions
I'm going through the Sharded Counters example in Java: http://code.google.com/appengine/articles/sharding_counters.html I have a question about the implementation of the increment method. In python it explicitly wraps the get() and increment in a transaction. In the Java example it just retrieves it and sets it. I'm not sure I fully ...
Isolated ADO.NET connection and transaction within a transactionscope
Background: I have an ASP.NET MVC application that wraps controller actions in a TransactionScope using an Action Filter. Further downstream (in my infrastructure layer); I'd like to open up a new ADO.NET connection (to the same db as my outer TransactionScope, if that is relevent) and have it participate in its own transaction - withou...
Is there any performance risk in having transactions wrap every datastore event in App Engine - reads and writes?
According to the App Engine docs, you wrap a datstore event in a transaction like this: import javax.jdo.Transaction; import ClubMembers; // not shown // ... // PersistenceManager pm = ...; Transaction tx = pm.currentTransaction(); try { tx.begin(); ClubMembers members = pm.getObjec...
How to use transactions (begin transaction, commit transaction)?
I have seen transaction usage in some cases but never really understood in which situations they should be used. How and when transactions should be used (begin transaction statement)? I have read that Microsoft do not suggest to use transaction statements (commit, rollback) inside a trigger and stored procedure. ...