Most voted "transactions" questions
Tag referring to database transactions that is characterized by a sequence of operations in a database management system that are treated as a single, indivisible (atomic) block during a failure recovery and also provide isolation between concurrent accesses in the same data mass.
Learn more…63 questions
Sort by count of
-
40
votes5
answers10782
viewsWhat is a Mysql Transaction for?
I was studying some examples of Mysql with PHP and came across as following code snippet: try { $db->beginTransaction(); $db->query('query 1'); $db->query('query 2'); $db->query('query…
-
37
votes3
answers2737
viewsHow to integrate microservices?
The idea of microservices is good. But I don’t really understand how to solve certain problems. Maybe the problem is how it is "sold". I don’t see much to say when to use it or when to avoid it. It…
database software-architecture transactions microservices acidasked 6 years, 10 months ago Maniero 444,682 -
9
votes3
answers1225
viewsMysql Transaction When? How? Why?
I’ve been reading the question What is a Mysql Transaction for? and I was left with many doubts on this subject. When we should use transactions? Why should we use transactions? How we should use…
-
8
votes2
answers2458
viewsWhat is the purpose of Transactionscope blocks?
I have a code with several blocks TransactionScope and I didn’t quite understand its purpose. ModeloColDataContext dm = DataContextFactory.GetContext(usuario); { if (documento > 0) { using…
-
7
votes2
answers961
viewsTransactionscopeoption what is the difference between the options?
I was doing some research on the options for Transactionscope and found the following settings: Required A transaction is required for scope. If it already exists, it uses an environment…
-
6
votes1
answer502
viewsManage transactions in Java EE @Transactional
I’m having trouble trying to "inherit" the transaction from Java EE of my layer of service to the layer of repository. My intention is for the transaction to target my service function. Enabling me…
-
5
votes1
answer275
viewsMysql Transactions written in the same table
On seeing this answer I was left with this doubt: If we have 2 transactions to be treated at the same time, in the first (A) we are writing in table x, in the second (B) if we try to write in table…
-
5
votes1
answer12035
viewsOperation of the Spring Framework @Transactional
1 - The Spring documentation describes the use of @Transactional Spring in the business rule classes(ProdutosService for example) there is some special reason to use this annotation in these classes…
-
4
votes1
answer396
viewsXA transaction does not commit changes in procedures (intermittent)
I have an EJB Stateles that monitors files that fall into a folder. When a file arrives it is handled, a receiving event is recorded in a central database and the file is inserted into a target…
-
4
votes1
answer54
viewsTransactions does not work in structure creations/modifications?
I was looking on the internet if there was any way to run Transactions for operations of the type ALTER TABLE or CREATE TABLE in the Mysql. This is because in one of our systems, we used Migrations…
-
4
votes1
answer1556
viewsDifference between Transaction.Commit and Transaction.Commitretaining
Using Firedac technology, I want to know exactly the difference between Commit and CommitRetaining. I read in the official documentation of Firedac that Commitretaining keeps the transaction open.…
-
3
votes1
answer151
viewsIterations within Transactionscope
I have an Asp.Net MVC project with Entity Framework 5.0 in . Net Framework 4.0. What are the losses caused by a TransactionScope very long? I have the following code snippet: using(TransactionScope…
-
3
votes1
answer220
viewsCompetition problem in java web application
Good evening, everyone, See the following code: Controller @WebServlet("/testConcurrency") public class TestConcurrency extends HttpServlet { private static final long serialVersionUID =…
-
3
votes1
answer49
viewsstring transformation in R
I wonder if I can turn an observation of a variable, which has a string shape, into uppercase letters. for example: #como esta: x=c("Casa branca","Barco Azul","casa preta") > x [1] "Casa branca"…
-
3
votes1
answer399
viewsAlternative to the Transactionscope
I’m using Entity Framework (version 4.4) in a project Aspnet MVC with .NET Framework a little old (version 4.0) and SQL Server. I do not have access to the server where the application is hosted,…
-
3
votes2
answers616
viewsRollback() JPA + Hibernate
I have a problem with persisting several information in the same transaction, in case something goes wrong a part of the information is recorded in the bank and the rollback() is not executed.…
-
2
votes1
answer512
viewsClose a Mysql connection without committing or rollback to c# Asp.net
I would like to know what happens in the following scenario: In a program Asp.net with c# was opened a MySqlConnection, soon after a MySqlTransaction, was held a insert in the open transaction,…
-
2
votes1
answer505
viewsBegin transaction is blocking my entire database
I got a problem, I got a problem script php that reads large XML files. Before I start inserting this data I make a Begin transaction and in the end the commit, but throughout the process that can…
-
2
votes1
answer382
viewsBegintransaction vs Transactionscope
I was analyzing that answer and the doubt arose: What’s the difference between BeginTransaction and the TransactionScope? Are there specific situations for each one? What are their advantages and…
-
2
votes1
answer14523
viewsError The multi-part Identifier "..." could not be bound
I am trying to make the following select and it returns me the error The multi-part Identifier "..." could not be bound in Importacontratoaux.Contratoid select AreaReclamacao.Descricao from…
-
2
votes1
answer580
viewsSpring @Scheduled with internal transaction triggering Propagation error
I am trying to run a service that is based on running by cron with annotation @Scheduled, but every time a database transaction needs to be opened within the annotated method with @Scheduled receive…
-
2
votes3
answers438
viewsClose in Transaction with Ibernate
Hello, I need some help. I’m trying to make a transaction on Ibernate. The problem is that by giving a close, the data are modified in the database, but this occurs WARN: WARN…
-
2
votes1
answer235
viewsTransaction control between two different applications
I am working on an application that is divided into two modules, each one in a language (.NET and Java). Application A (.NET) will manipulate the records of a table while application B (Java) will…
-
2
votes1
answer774
viewsTransaction with multiple queries
I was visualizing that question, and to try to answer I decided to perform some tests where I could see the following problem: When conducting multiple queries to the Database via Entity Framework…
-
2
votes1
answer468
viewsTransactionscope - Rollback problem
I need the Transactionscope do Rollback case any of these foreach error. I added a Exception manually between 2º and 3º foreach to test whether the rollback, but the information saved in the bank of…
-
2
votes1
answer52
viewsI’m trying to make a rollback of my Querys only to give me a mistake in Executescalar
The code works perfectly without the btw rollback. SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["dbconnection"].ConnectionString); con.Open(); SqlTransaction tran =…
-
1
votes1
answer1387
viewsInsert into two tables in Android Sqlite
How do I add data to two tables on Android in a single transaction? I have two tables Client and Address, is last with a foreign key referencing the client table, and must be registered in a single…
-
1
votes1
answer262
viewsUnable to locate current JTA Transaction
The project is divided into the following modules: test-persistence; test-services; web test; I use Glassfish 4 as an application server and it has a connection pool configured for connections to…
-
1
votes0
answers85
viewsTransactions on SQL Server, how do they work?
I’m having a hard time understanding this content in college and finding good materials to understand, could someone explain to me in a better way how transactions are specified and defined the…
-
1
votes1
answer384
viewsBatch Insert using Pdo and transaction
Good morning guys I’m a little new in the world ai php mysql and I’m in need of a help I am inserting data in my bd in 6 tables, data comes from txt files some files have 5000 lines with 163 records…
-
1
votes1
answer257
viewsHow to support transactions with Junit and Demoiselle 2.4.2
I have an application whose unit tests are fully operational except for write operations in the database. No data is recorded. When forcing a flush, I received the message indicating that no…
-
1
votes2
answers2645
viewsMultiple transactions with Firedac?
I would like to work with multiple simultaneous transactions on Firedac, making decisions (rollbacks and commits) different for each one. Is it possible? Currently, I work as follows: try…
-
1
votes1
answer93
viewsTransactionscope with multiple Storedprocedures
I’m thinking of implementing TransactionScope in my code, however, all bank access is made by StoredProcedures. The TransactionScope can give rollback in multiple actions carried out in…
-
1
votes1
answer51
viewsHow to make database transaction in Webforms?
I got a stock in a file .aspx that runs multiple Inserts in the bank. I need that if something fails, the operation is canceled, since one record will depend on the other. I usually use a…
-
1
votes1
answer33
viewsSearch for data not committed
I was doing some tests with respect to transactions and I saw that if I perform a search of the data registered and not committed they are returned. In Entity Framework this doesn’t happen, and so I…
-
1
votes1
answer659
viewsHow to control the transaction between two different databases in Delphi?
I have two databases and need to ensure the persistence of the data in both in a given process. Connection components are those of the Interbase Express package. I did so: database :=…
-
1
votes1
answer86
viewsMulti Sql Begin, database data protection
In my application I use BEGIN;, COMMIT;, ROLLBACK;, Try, Catch: Example: try{ $this->execute('BEGIN;'); // CODIGO COM VALIDAÇÕES $this->execute('COMMIT;'); }catch(Exception $e){…
-
1
votes1
answer43
viewsAlternatives to using transactions on Myisam
I have an application that is in a hosting that does not support me the storage mechanism Innodb, therefore, I am at the mercy of the use of Myisam. There is a secure alternative to using…
-
1
votes1
answer117
viewsTransaction in Postgress on Nodejs
I’m looking to encapsulate my SQL execution in the Postgress database. My initial wish is to call a method to execute a specific query and another method to execute a transaction of various queries.…
-
1
votes1
answer286
viewsCakephp 3 - How to do rollback
In cakephp 2 in birds transactional with $data_source->begin(); ,$data_source->commit();, or $data_source->rollback();. So when I needed to insert into more than one table, and the data was…
-
1
votes0
answers645
viewsHow to control transactions in Node.js?
I’m starting in Node.js and looked a lot about transaction control, but I haven’t found anything like what I’m used to in Java. First I’ll clarify what I mean by transaction control: Imagine a…
-
1
votes1
answer1942
viewsTRANSACTION - How to correct a shipping error?
I think you can understand what I’m trying to do there: This method will make a foreach for each item in my movement list, and send each as a parameter to the method that will save them in the BD. I…
-
1
votes2
answers364
viewsControl of Rest application transactions in spring
I was studying a little bit on the note @Transactional (version made by Spring), and I came up with a doubt. According to a published in Devmedia, to "more correct form" to use is to write down in…
-
1
votes0
answers70
viewsElastic transactions with MS SQL Server
Considering the following code snippet: using (var scope = new TransactionScope()) { using (var conn1 = new SqlConnection(connStrDb1)) { conn1.Open(); SqlCommand cmd1 = conn1.CreateCommand();…
-
1
votes2
answers85
viewsJPA Hibernate with Postgres - 2 transactions
I started using Hibernate 1 month ago. I am developing a simple application from bank to college. I have an account class, which has the Withdraw Value method : public boolean SacarValor(long…
-
1
votes1
answer277
viewscommit with the @Transactional annotation in Spring
Good afternoon! I am new to Java and Spring and I am in need of help in the code below. I need every iteration of for to be performed the commit, but it is only being performed at the end of the…
-
1
votes1
answer1627
viewsChange Slide Bootstrap Transition
I need to decrease slide transition time Bootstrapp, how can I do while the files js and css are being pulled from the site? <div id="carouselExampleControls" class="carousel slide"…
-
0
votes2
answers11150
viewsHow to Mount a Transaction with Commit and Rollback on Oracle?
I’m trying to mount a transaction on Oracle, but I don’t know how to perform a Rollback in case there’s an error in one of the querys. I searched some websites, but I couldn’t find anything clear…
-
0
votes0
answers122
viewsTransaction with Laravel
DB::connection('gtsql')->beginTransaction(); $seriefat = DB::connection('gtsql')->table('se_seriefat') ->where('c_codserie', 'FO')->first(); echo $seriefat->c_numultdoc; sleep(15);…
-
0
votes0
answers130
viewsDoctrine ORM: How to register several times in the same table using beginTransaction()
How do I register in the same database table using beginTransaction(). Example: Registering various details of a product $entityManager->getConnection()->beginTransaction(); try { ... //…