Upgrade H2 Version 2.0.202 From 1.4.200 - Database - Stack Overflow

Just browsing Stack Overflow? Help us improve your experience. Sign up for research

1. 1. Home
   2. Questions
   3. Tags
   4. Users
   5. Companies
   6. Labs
   7. Jobs
   8. Discussions
   9. Collectives

   10. Communities for your favorite technologies. Explore all Collectives

2. Teams

   Ask questions, find answers and collaborate at work with Stack Overflow for Teams.

   Try Teams for free Explore Teams
3. Teams

4. Ask questions, find answers and collaborate at work with Stack Overflow for Teams. Explore Teams

Collectives™ on Stack Overflow

Find centralized, trusted content and collaborate around the technologies you use most.

Learn more about Collectives

Teams

Q&A for work

Connect and share knowledge within a single location that is structured and easy to search.

Learn more about Teams

Get early access and see previews of new features.

Learn more about Labs Upgrade H2 version 2.0.202 from 1.4.200 Ask Question Asked 2 years, 10 months ago Modified 2 years, 10 months ago Viewed 9k times 8

1. Hi, we are trying to upgrade 2.0.202 from 1.4.200. We are getting an error related to running our tests. While persisting data we are getting below error. Any suggestions?

Caused by: org.h2.jdbc.JdbcSQLIntegrityConstraintViolationException: NULL not allowed for column "***"; SQL statement:

• database
• hibernate
• spring-data-jpa
• h2
• spring-jdbc

Share Improve this question Follow asked Jan 23, 2022 at 2:10 sabitri gartaulasabitri gartaula 8311 silver badge55 bronze badges Add a comment |

1 Answer 1

Sorted by: Reset to default Highest score (default) Trending (recent votes count more) Date modified (newest first) Date created (oldest first) 10

You cannot use H2 2.0.202 with Hibernate ORM 5.6, because H2Dialect in Hibernate ORM produces invalid SQL for H2, H2 2.x is more restrictive and doesn't accept it by default.

H2 2.0.204 and later versions (current version is 2.1.210) have a LEGACY compatibility mode, it can be enabled by appending ;MODE=LEGACY to JDBC URL. This mode provides some limited compatibility with old versions of H2.

This trick shouldn't be required for Hibernate ORM 6.0 when it will be released.

Edited

Changes for H2 2.x.y were backported to Hibernate ORM 5.6.5.

Share Improve this answer Follow edited Jan 31, 2022 at 1:05 answered Jan 23, 2022 at 7:23 Evgenij RyazanovEvgenij Ryazanov 8,12822 gold badges1414 silver badges2222 bronze badges Add a comment |

Your Answer

Reminder: Answers generated by artificial intelligence tools are not allowed on Stack Overflow. Learn more

Thanks for contributing an answer to Stack Overflow!

• Please be sure to answer the question. Provide details and share your research!

But avoid …

• Asking for help, clarification, or responding to other answers.
• Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

Draft saved Draft discarded

Sign up or log in

Sign up using Google Sign up using Email and Password Submit

Post as a guest

Name Email

Required, but never shown

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged

• database
• hibernate
• spring-data-jpa
• h2
• spring-jdbc

or ask your own question.

• The Overflow Blog
• Your docs are your infrastructure
• Featured on Meta
• More network sites to see advertising test [updated with phase 2]
• We’re (finally!) going to the cloud!
• Call for testers for an early access release of a Stack Overflow extension...

Related

7 Updating hibernate version manually 0 update hibernate JPA 4 HHH000431: Unable to determine H2 database version, certain features may not work 0 hbm2ddl update is giving error in spring boot 2 Spring boot jpa with H2 database 0 Spring boot 1.4.1 to 1.4.2 upgrade 0 Spring Server with H2 Database SchemaUpdate HHH000299 4 Problems with integration tests after upgrading H2 database from 1.4.200 to 2.0.204 1 Exceptions after updating from H2 in memory db version 1.4.X to 2.1.x 1 New H2 version breaks liquibase

Hot Network Questions

• Why hot refers to being closer and cold refers to moving away in the hotter/colder game?
• Wouldn't the ban of TikTok violate freedom of speech?
• Why Adam and Eve were created naked?
• Weapon Mastery and Weapon Cantrips
• How can I solve my equation with the best numerical precision?
• Trump's tariff plan
• What would T-Rex cavalry be used for?
• If scent means a pleasant smell, why do we say "lovely scent" or "sweet scent"?
• How to attribute authorship to personal non-academic friend who made significant contributions
• Do market-makers often act as a taker in other markets or assets while hedging?
• How do I go about rebranding a fully deleted project that used to have a GNU General Public License v3.0 but is now fully inaccessible
• Non-Schengen flight without any passport control, any repercussion on a non-EU traveller
• Why is it safe to soak an electric motor in isopropyl alcohol but not distilled water?
• Can one publication contribute to two separate grants?
• Standard SMD chip resistor with higher power in the same package
• The British used to (still?) classify their guns by weight in pounds rather than caliber. Was that a constant across shell types?
• Is it possible to add arbitrary amounts of quantum resistance cheaply?
• Group cohomology valued in a bimodule
• Perfect eden - Whence conflict?
• Angular orientation of exact solution of the Hydrogen Schrödinger Equation
• A novel about Earth crossing a toxic cloud of cosmic size
• "Elegant" conditions on two quadratics (with positive real roots) to ensure that the larger root of one is less than the smaller root of the other
• Meaning of "I love my love with an S—" in Richard Burton's "Arabian Nights"
• How to show "— "character

more hot questions Question feed Subscribe to RSS Question feed

To subscribe to this RSS feed, copy and paste this URL into your RSS reader.

default