The tag has no wiki summary.

learn more… | top users | synonyms

-2
votes
0answers
5 views

Random issue: Communication with the underlying transaction manager has failed [migrated]

I m getting a exception in WCF service when I try to send a post data which perform some Create/Update/Delete. What my WCF service do: It calls a SP to create record in DB, then publish a Event to ...
2
votes
0answers
99 views

Is there a theory for “transactional” sequences of failing and no-fail actions?

My question is about writing transaction-like functions that execute sequences of actions, some of which may fail. It is related to the general C++ principle "destructors can't throw," no-fail ...
1
vote
1answer
127 views

Eventual consistency in Banking systems

I keep hearing people say Banking systems like ATM use Eventual consistency model for data synchronization, but I am wondering if it is true. Definitely the amount you withdraw might be delayed ...
0
votes
1answer
181 views

What happens if computer crashes after giving commit command

If we are updating a field in SQL and ALTER the row also. After giving the COMMIT command, the system is crashed. What will happen to the commands given, whether it will UPDATE and ALTER the table ...
1
vote
1answer
189 views

Does a batch of operations violate REST principles?

Does it violate REST principles for a REST API to support a batch of operations (perhaps with transactional guarantees) that can be added to a queue via a POST? This design seems outside the scope of ...
2
votes
1answer
193 views

Transactional Memory vs Mutex and Locks

Just found out that Intel processors now have Transactional Memory support !!!! I learned about Transactional operations in my dB/OS class, it is a very simple concept: entire operation is executed or ...
1
vote
0answers
90 views

Alternatives to Pessimistic Locking in Cluster Applications

I am researching alternatives to database-level pessimistic locking to achieve transaction isolation in a cluster of Java applications going against the same database. Synchronizing concurrent access ...
1
vote
3answers
147 views

Offline data transaction processing capabilities in a context of poor internet connectivity

We have a core banking product developed with ASP.NET with C# using Microsoft SQL Server 2008 database. Product is hosted on a centralized server and works well at all locations (bank branches) where ...
0
votes
0answers
137 views

Safe caching (i.e. memoizing) with locks in Redis

I have an access token that needs to be used by several parts of our system. It expires after a certain amount of time, at which point any component in the system needs to be able to get a new one. ...
6
votes
1answer
423 views

Does SOA service composition actually work in practice?

One of the main SOA service design principles is Service Composability principle (https://en.wikipedia.org/wiki/Service_composability_principle). The idea is that by composing new services using ...
1
vote
3answers
274 views

Logging to database: Log first or action first?

Long story short, I'm working on a web-based frontend that interacts with a database, and one of the functions is that every action on a particular table gets logged to keep a full history of all ...
0
votes
2answers
76 views

Mingling DB transactions and logging from a design perspective

Say we have a view page where users perform actions in multiple steps, some of these actions would involve DB operations with transactions (the snippets are in pseudo-code like from): View 1: ...
1
vote
2answers
149 views

Is there a formula for this?

TL/DR: Any way to work out if known numbers between a known start and ending figure should be positive or negative numbers? I am developing an application in PHP which can import and read PDFs. The ...
5
votes
2answers
3k views

How to manage 2 DAO methods in a single transaction?

In an interview someone asked me : How do we manage 2 transactional/dao methods in a single transaction. Desired capabilities: If anyone of them fails we need to rollback both methods. Both of the ...
4
votes
2answers
439 views

Java Transaction Service without the application server

Is it possible to have a Java standalone application (no application server attached) that exposes some operations that a client can call and be the one to manage the transactions? I was thinking ...
3
votes
3answers
1k views

Transaction Design Pattern for MVC and location of responsibility?

I'm designing a pretty standard Spring MVC application, and I'm trying to figure out where the responsibility for transaction management should lie. I've been reading Java Transaction Design ...
1
vote
1answer
298 views

Implementing Bulk Update feature and its trade offs

The feature to implement is to allow a user to select items and apply data update in bulk. It is very similar to JIRA's ability to bulk update a list of selected issues. In my case: I iterate over ...
1
vote
2answers
97 views

How to handle file access transactions properly?

I'm looking for good practices or any advice regarding file access transaction mechanisms. We will have multiple instances of an application spread over a redundant network (cloud) watching a ...
0
votes
2answers
511 views

why are transaction monitors on decline? or are they?

http://www.itjobswatch.co.uk/jobs/uk/cics.do http://www.itjobswatch.co.uk/jobs/uk/tuxedo.do Look at the demand for programmers (% of job ads that the keyword appears), first graph under the table. ...
0
votes
3answers
858 views

What are the dangers of setting an unlimited database transaction life timeout?

We have a process that may last between a few seconds and a few minutes. As such, we may update just a few records or thousands of them. The process can be committed only when everything has been done ...
5
votes
3answers
439 views

Distributed transactions and queues, ruby, erlang

I have a problem that involves several machines, message queues, and transactions. So for example a user clicks on a web page, the click sends a message to another machine which adds a payment to the ...
1
vote
1answer
2k views

how could I draw the database transaction commit in the sequence diagram

How could I draw the database transaction commit in the sequence diagram? EDIT I want to draw in sequence diagram database transaction commit/rollback process
4
votes
1answer
542 views

Are rollback and roll-forward transactions equivalent for fault tolerance?

I've been reading about systems that employ transactions to provide fault-tolerance -- SQLite, for instance, implements a journal that allows the database to be rolled back to a known state in case of ...
4
votes
2answers
305 views

What methods were used for online payments before API's and Paypal, etc

What methods (in programming/web dev terms) were used to take payments online before such things as Paypal, Google Checkout and various gateways and API's. How were such transactions carried out?
1
vote
2answers
961 views

Best practice to save data in different databases using C# ADO.NET

I would like to know if you guys have any best practice when dealing with transaction between different databases vendors. For example, if you have a C# application that save customer data in two ...