334 questions
-1
votes
1
answer
95
views
try catch block inside withTransaction breaks transaction
const session = client.startSession();
await session.withTransaction(async () => {
for (const transaction of purchase_detail) {
try {
await IOS_COL.insertOne(...
1
vote
1
answer
63
views
In a MongoDB transaction, are index entries updated immediately when an indexed field is modified?
I'm working with MongoDB transactions (Node.js, replica set). Inside a transaction, I update a document in a way that changes the value of a field that is covered by an index. Later in the same ...
0
votes
0
answers
63
views
@Transactional not rolling back in Spring Boot after RuntimeException
I am learning Spring Boot thoroughly and the last thing I am trying to learn is transaction management.
But this is part of what makes learning Spring so frustrating, nothing just works, everything ...
- 288
1
vote
1
answer
118
views
Does using a transaction for read queries provide benefits under Read Committed Isolation Level in PostgreSQL?
I'm using Prisma with PostgreSQL. As I read about the transaction isolations in PostgreSQL, I wondered if I am using transactions without any benefits or if I understood the subject correctly.
async ...
0
votes
1
answer
69
views
How do you achieve isolation in ACID transactions?
what is a concrete implementation I can use for isolating transactions? For example, for atomicity, I can lump multiple statements underneath a BEGIN TRAN and then call COMMIT somewhere down the line. ...
- 330
2
votes
0
answers
245
views
MongoDB ACID transactions vs RDMBS - Performance
I am looking for some comparison between Mongo DB with ACID support vs RDBMS. I would like to see if Mongo DB with ACID can be a replacement for RDBMS for most of the scenarios. With earlier Mongo DB ...
- 91
0
votes
1
answer
392
views
Is Azure SQL database designed with read replicas ACID compliant
I am currently preparing for the interview and trying to figure out what is ACID compliant and what is not.
As I understand Azure SQL database with 1 write/read and multiple read replicas will be ACID ...
- 104
0
votes
0
answers
47
views
@Transactional is not working when it tagged on the method created using functional interfaces
I created a method in my service implementation & annotated by Transactional class. but @Transactional is no effective when then method is created as functional interfaces such as BiFunction, ...
1
vote
0
answers
224
views
What are the properties of a non ACID table in Apache Hive?
As of now, ACID properties in Apache Hive are only supported for the ORC file format. I have data in Parquet files (lets say they're very large). I want to figure out the pros and cons of leaving the ...
-1
votes
1
answer
239
views
Should event sourcing database provide ACID properties
Not sure which term to use "Database" or "Event store" but I'm talking about where we store our events. I wonder if Event store should have ACID properties, especially the ...
- 906
1
vote
1
answer
625
views
Spring Data Elasticsearch, ACID query and partial update
I am facing a problem with Spring Data and Elasticsearch. I need to do a query and partial add or update to an entity and in the end figure out if its completed.
The model is a sample as below
public ...
- 835
0
votes
1
answer
820
views
External consistency in Google spanner
I was reading https://cloud.google.com/blog/products/databases/strict-serializability-and-external-consistency-in-spanner and it says below "While this consistency guarantee says nothing about ...
- 1,370
1
vote
0
answers
80
views
Are `AFTER UPDATE` triggers `FOR EACH ROW` atomic?
I'd like to insert a row inside a "history" table whenever the original row gets modified (updated). I'd like to use original row's ID as a FOREIGN KEY for the history table. But this ID ...
- 2,144
0
votes
1
answer
488
views
Can database transaction help block read until read from another transaction is finished?
In my code I have a situation similar to this:
using(var transaction = DbContext.Database.BeginTransaction(IsolationLevel.Serializable)
{
var record = DbContext.SomeTable.FirstOrDefault(t => t....
- 21
1
vote
1
answer
144
views
How bucketing works for Hive Acid Tables?
In Hive, I understand how bucketing works for External Tables and Non Acid Managed tables.Based on the column that is specified inside clustered-by clause in the corresponding DDL statement, bucket is ...
- 583