I'm using dbsetup for my db tests. The problem is I can't manage to get data rolled back after each test using the aproach which have always worked which is annotating the test case (or method) with @Transactional annotation. I suppose this happens because dbsetup uses the DataSource itself so Spring can't get track of what's being done to the database. How to make this work?
Rollback changes in test after manual interaction with the datasource?
254 Views Asked by kboom At
1
There are 1 best solutions below
Related Questions in JAVA
- I need the BIRT.war that is compatible with Java 17 and Tomcat 10
- Creating global Class holder
- No method found for class java.lang.String in Kafka
- Issue edit a jtable with a pictures
- getting error when trying to launch kotlin jar file that use supabase "java.lang.NoClassDefFoundError"
- Does the && (logical AND) operator have a higher precedence than || (logical OR) operator in Java?
- Mixed color rendering in a JTable
- HTTPS configuration in Spring Boot, server returning timeout
- How to use Layout to create textfields which dont increase in size?
- Function for making the code wait in javafx
- How to create beans of the same class for multiple template parameters in Spring
- How could you print a specific String from an array with the values of an array from a double array on the same line, using iteration to print all?
- org.telegram.telegrambots.meta.exceptions.TelegramApiException: Bot token and username can't be empty
- Accessing Secret Variables in Classic Pipelines through Java app in Azure DevOps
- Postgres && statement Error in Mybatis Mapper?
Related Questions in SPRING
- HTTPS configuration in Spring Boot, server returning timeout
- Multi Tenancy in Spring - Partitioned Data Approach
- How to create beans of the same class for multiple template parameters in Spring
- org.telegram.telegrambots.meta.exceptions.TelegramApiException: Bot token and username can't be empty
- Springboot: How to get an entity optional property and check null?
- How do I propagate the current SecurityContext to my @RabbitListener in Spring Boot?
- Spring's XML based bean configuration for Object Mapper's Case Insensitive property
- Failed to configure a DataSource: 'url' attribute is not specified and no embedded datasource could be configured. I'm using Postgresql
- springboot class org.hibernate.mapping.Bag cannot be cast to class org.hibernate.mapping.SimpleValue
- Issue while deploying JDK 17 and Spring 6 application in Tomcat 10.1.20
- Spring JPA Data Auditing - How to design it?
- Springframework test: Async not started
- Error: Cannot invoke "jakarta.servlet.http.HttpSession.getAttribute(String)" because "session" is null
- How does spring-retry determine which methods to retry when @Retryable is placed at the class level?
- problem with edge server registration in Eureka
Related Questions in TRANSACTIONS
- How to design the file operation interface involving status and transactions?
- Internal events cannot be consumed in spring boot. Only when using Kafka Consume
- How do you categorize a pending transaction immediately after making a purchase and have it save?
- Spring JPA + Hibernate + Rest services + long time transactions
- How to Identify Specific Transaction Anomalies in a Given Schedule?
- When does shared and exclusive locks are acquired and released in a MySql transactions?
- How to write a reusable DB transaction wrapper?
- "No data" after sending tx Jupiter Swap Python
- Perform multiple Identity actions in a transaction
- Running a program on different computers with different users that access a central database simultaneously - VB.NET XAMPP/MySQL
- Proper way to implement transactional HOTP?
- Transactional role in Java Spring Boot
- Is there a way of increasing MAX_INTEGER in web3.js
- Single transaction, multiple service calls to Entity Framework updating database
- Saving to Reactive Redis and Postgres in a single transaction
Related Questions in ROLLBACK
- Rollback to Savepoint with H2 Database
- How to Revert Database Changes Made in a Session Without Using Transaction Management?
- Unwanted Rollback in Postgres - missing data after commit
- How to add the transaction and rollback for the query in the repository layer for the python api
- Rollback Mechanism For Third Party Services
- Wordpress - Azure AppService database "rollback"
- Ansible rollback on multiple hosts when one of the roles fail. How to pass variables between different plays?
- Liquibase - fix wrong rollback statement
- How to undo Git - All conflicts fixed but you are still merging
- Rollback migration in laravel
- Get Second Last commit SHA of a branch using GitHub Actions
- Rollback to 120.0.2210.144
- access airflow task arguments in the on_failure_callback function
- How to implement rollback of multi-statement transaction in SQLite?
- Rollback statement Oracle
Related Questions in DBSETUP
- Command 'db:setup' not recognized"
- Configuration DbSetup with Kotlin and Spring Boot
- Spring data doesn't increment after DBsetup
- @DataJpaTest autowire dataSource
- How to insert UUID into RAW(16) column
- DbSetup : multiple SQL Update
- DBSetup : SQL support
- Rollback changes in test after manual interaction with the datasource?
- DBSetup - How to do a select statement
- DbSetup simple example, SQLException occurs
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular # Hahtags
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
DbSetup is not tight to Spring in any way. It gets a JDBC connection from a DataSource and commits it when it's done.
The recommended way of using DbSetup is to clear and populate the tables before each test. Using a DbSetupTracker allows avoiding useless repopulations in case a test uses the same data as a previous test, and this previous test hasn't altered the data. This is described in the user guide.