My project uses PostgreSQL for production and H2 database for tests. Some content is saved to database and afterwards it is retrieved, changed and saved again to new rows. In this method some of retrieved contents' IDs are set to null, and PostgreSQL autoincrements them again when contents are being saved for the second time. In my test case H2 database doesn't do the same - it autoincrements IDs when contents are being saved for the first time, but when I retrieve them and set the IDs to null and save them again, IDs stay null. They don't get autoincremented when being saved, and only when I try to map this new object to a DTO, I get this error: identifier of an instance of X was altered from 1 to null. The method is called from a controller that I'm mocking in a test, if that makes a difference.
H2 database doesn't autoincrement IDs after them being set to null, while PostgreSQL does
90 Views Asked by bluebird At
0
There are 0 best solutions below
Related Questions in POSTGRESQL
- Why does adding a JOIN completely modify the query planner behaviour?
- When dealing with databases, does adding a different table when we can use a simple hash a good thing?
- Aggregate and count in PostgreSQL
- Rails HABTM: Select everything a that a record 'has'
- Trigger using data from inserted row
- Select results where joined table contains records with an attribute, but without another
- DB candidate as CouchDB/Schema replacement
- How do I properly add data in SQLAlchemy?
- Postgres in Conda Environment (Ubuntu 14.04)
- How to customize the output of the Postgres Pseudo Encrypt function?
- Split a large query (2 days) into pieces to increase the speed in Postgres
- Why does pg_search prefix not work like I expect?
- extracting meta info from a table psql using information_schema
- How to query a table in the database and copy it's data into one one?
- Update a table using info from a second table and a condition from a third table in Postgresql
Related Questions in TESTING
- How does Robot's Telnet library work?
- Behat doesn't load extensions?
- Load additional CONFIG file with values
- rails controller test failing non-deterministicly wrt state leak (I think)
- Ordering tests using trial twisted
- Unexcepted failed Gavel/Dredd test
- How to use Jasmine and CucumberJS with Protractor
- Django login tests session problems
- How to mock specific RequireJs dependencies while unit testing
- Test case for WCF REST Service
- how to test this business logic
- Protractor - How to get first or last CHILD value
- Factory Not Registered in rspec but found in console
- Pick out certain lines from files
- Selenium stops running after click() function runs
Related Questions in INTEGRATION-TESTING
- TeamCity create arbitrary directory structure on agent
- Integration testing the entity framework - separate the seed method call only for PROD -
- Test case for WCF REST Service
- Spring MockRestServiceServer handling multiple requests to the same URI (auto-discovery)
- Rails 4 Integration Testing Arrays not present in json object inside controllers
- Is there a testing framework that works with threads in Python?
- Dealing with TargetWithLayout in XUNIT
- database restore for integration tests with phpunit
- How to initialize test class before context initialization while Spring testing?
- What should a controller integration test assert
- Maven and python integration test set up
- Amazon Kinesis + Integration Tests
- continuous integration - build separated projects or build all in one?
- How to deploy WildFly datasource with Arquillian?
- Stubbing method in ActionDispatch::IntegrationTest
Related Questions in H2
- CURRENT_TIMESTAMP in milliseconds in h2
- Upgrade H2 from sonarqube 4.5.1 to 5.1.1
- SQL switch from decode to case
- H2: executeBatch doesn't work
- H2 - The handle is invalid
- Changing H2 database admin user & password within Grails
- H2 database PageStore causing OutOfMemoryError
- Spring tests are closing embedded database multiple times
- Converting h2 database from h2.db to mv.db
- Desktop Database with Server without installation
- JDBC connection error using H2 database in spring-boot integration tests
- Keep the last 'x' results in a database
- SQL Keep (dense_rank last order by) to H2 database
- How to integrate Kettle with H2
- Lob returns null using play framework and Ebean and H2
Related Questions in CONTROLLER-TESTS
- Controller integration tests lose the session after follow_redirect
- wrong number of arguments error while testing comments controller using Rspec
- @SpringBootTest: @MockBean not injected when multiple test classes
- No qualifying bean of type 'org.springframework.boot.actuate.health.HealthEndpoint' in controller test
- mockMvc.perform is ignoring @pattern annotation on header field when testing controller method
- H2 database doesn't autoincrement IDs after them being set to null, while PostgreSQL does
- Moq; Unit Test - Method is always failing. ISetup is not working
- how moq one of the interfaces in controller test
- UrlGenerationError when testing controller usinf Rspec
- How to manipulate the application configs for controller tests?
- StatementInvalid: SQLite3::BusyException: database is locked
- Getting no route matches when simulating a session in rails minitest
- Rspec rails-controller-testing gem's assigns doesn't work
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 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?