NewYour coding agent can read the release notes before it upgrades.Set up the MCP server →
Maven Central
Maven Central, #1043 by repository stars
H2 Database Engine
Latest stable
2.5.252
Last release 1 months ago
26 Sep 2026
Release timing varies
gaps range from 2 weeks to 1.1 years
Some releases are documented
notes for 24 of the last 60 stable releases
Nothing withdrawn
no release was ever pulled
20 years old
142 releases · first in 2006
Drag across the ruler to compare, or tap a release to open it.
Issue #4376 : Reading INFORMATION_SCHEMA.COLUMNS fails with a NPE while any materialized view exists
Your coding agent can read these notes before it upgrades. Set up the MCP server →
Issue #4345: Comment on View Column is not persisted and not exported to database dump (with SCRIPT TO)
<h2>Version 2.5.250 (2026-08-29)</h2> <ul> <li>Issue #4345: Comment on View Column is not persisted and not exported to database dump (with SCRIPT TO) </li> <li>PR #4363: Fixed: Server should be stopped every time db init fails </li> <li>PR #4374: Fixed: Data race causing spurious "Position 0" during chunk rewriting </li> <li>Issue #4353: Wrong composite index being chosen </li> <li>PR #4359: Fixed casting issue: skipped Index Condition Pushdown optimization for lossy conversions </li> <li>Issue #4352: Fix race between metatable generation and transaction closure </li> <li>Issue #4321: Fix SCRIPT tool COLUMNS option placement </li> <li>PR #4343: Stop on panic exception to prevent store corruption </li> <li>PR #4340: Eliminate concurrent access to MVStore.versions </li> <li>PR #4317: Fix case for ChunkNotFound. MVStore performance improvements. </li> <li>Issue #4302: org.h2.jdbc.JdbcSQLIntegrityConstraintViolationException: Check constraint invalid </li> <li>Issue #4293: Data Race in org.h2.mvstore.tx.TransactionStore.registerTransaction </li> <li>Issue #4299: READ_COMMITTED isolation level sometimes doesn't see uncommitted changes from the same transaction 2.4.240 </li> <li>Issue #4048: Assertion error in shrinkStoreIfPossible </li> <li>Issue #4304: DROP SCHEMA & DROP ALL OBJECTS is broken if a materialized view is present in the schema </li> <li>Issue #4297: fix race in VersionedBitSet </li> <li>Issue #4286: faulty assertion caused failure in SHUTDOWN COMPACT </li> </ul>
PR #4273 : SHUTDOWN COMPACT: parallel map copy (¼ cores default, override with h2.compactThreads)
Issue #4005 : Add optional version to RANDOM_UUID function and generator of version 7 in addition to existing version 4
PR #4007: Update pom.xml related to CVE-2024-1597
<h2>Version 2.3.230 (2024-07-15)</h2> <ul> <li>Issue #2752: Fix for "double mark" error at database backup opening </li> <li>Issue #4052: Allow 0 as a valid chunk id </li> <li>Issue #4012: Fix "Chunk not found" database corruption by ensure proper prologue/epilogue for every SQL statement in JDBC ";" - separated list </li> <li>Issue #3960: Fix NPE in page rewrite </li> <li>Issue #3909: Reduce resource consumption of too aggressive disk space housekeeping </li> <li>Issue #701: An available index is never used for ordering, when the requested order is DESC </li> <li>Issue #4036: NULLS NOT DISTINCT constraint changed after column dropped </li> <li>Issue #4033: Wrong array produced when using ARRAY_AGG() on UNNEST(ARRAY[CAST(? AS INT)]) expression in a PreparedStatement </li> <li>Issue #3909: Maintenance taking too much resources since 2.2.222 </li> <li>Issue #4010: org.h2.jdbc.JdbcConnection.getTypeMap() returns null </li> <li>PR #4007: Update pom.xml related to CVE-2024-1597 </li> <li>Issue #3907: MvStoreTool unable to Repair() or Rollback() [2.1.214] </li> <li>RP #3997: Server-side batch execution for prepared statements </li> <li>Issue #3106: Trailing commas in SELECT are accepted by the parser </li> <li>PR #3992: Add IPv6 support to H2 Console </li> <li>Issue #3966: Unable to insert null into a JSON column </li> <li>Issue #3554: Regression in 2.1.214 when joining 2 recursive CTE containing bind values </li> <li>PR #3989: Refactor CTE-related code and reduce recompilations </li> <li>Issue #3987: Allow empty <with column list> </li> <li>Issue #822: WITH clauses' column aliases are not maintained correctly when selecting from CTE from within a derived table </li> <li>Issue #910: Common Table Expressions (CTE) inside WITH should have their own identifier scope </li> <li>Issue #3981: Unexpected result when using trigonometric functions </li> <li>Issue #3983: INVISIBLE columns should be ignored in INSERT statement without explicit column list </li> <li>Issue #3960: NullPointerException when executing batch insert </li> <li>Issue #3972: Constraints of local temporary tables aren't listed in INFORMATION_SCHEMA </li> <li>PR #3973: Fix Tool.showUsage() for GUIConsole </li> <li>Issue #3968: Add possibility to get index size on disk </li> <li>Issue #3909: Maintenance taking too much resources since 2.2.222 </li> <li>Issue #3950: JdbcSQLIntegrityConstraintViolationException: Unique index or primary key violation </li> <li>PR #3947: Compound index search fix </li> <li>Issue #3940: Wrong estimation of a query execution cost with spatial index </li> <li>Issue #3931: MVStoreTool -dump throws a NullPointerException or returns binary data </li> <li>Issue #3910: Small error in the tutorial regarding full text search </li> <li>PR #3915: Improving search by compound indexes </li> <li>RP #3893: Fixed unit test is support en_GB locale </li> <li>Issue #2834: MERGE INTO fails with an error "Timeout trying to lock table" </li> <li>PR #3879: Require Java 11 </li> </ul>
Patch release to fix Issue #3883 Performance regression in 2.2.222
Patch release to fix Issue #3883 Performance regression in 2.2.222
Fixed race condition in MVStore causing database corruption "File corrupted in chunk ###"
<h2>Version 2.2.222 (2023-08-22)</h2> <ul> <li>Fixed race condition in MVStore causing database corruption "File corrupted in chunk ###" </li> <li>Issue #3868: INFORMATION_SCHEMA.SESSIONS.ISOLATION_LEVEL returns isolation level of the current session in all rows </li> <li>RP #3865: Add possibility to enable virtual worker threads in TCP, Web, and PG servers on Java 21+ </li> <li>PR #3864: Improve performance of TCP client driver when it is used from virtual threads </li> <li>Issue #2665: Parser shouldn't suggest compatibility syntax elements on parsing error </li> <li>Issue #3089: GREATEST and LEAST aren't fully compliant with the SQL Standard </li> <li>PR #3861: Improve SET EXCLUSIVE 2 and use stable time source for timeout exceptions </li> <li>PR #3859: Fix conversion of PK columns to identity columns </li> <li>Issue #3855: StackOverflowError when using TRACE_LEVEL_SYSTEM_OUT=4 </li> <li>PR #3854: Fix issues with newer JVMs </li> <li>PR #3851: Remove lift configuration </li> <li>PR #3847: Fix the NullPointerException caused by accessing 'user' after the session has been closed </li> <li>PR #3846: Make DB_CLOSE_ON_EXIT safer </li> <li>PR #3842: Adds support of quotedNulls in CSV handling </li> </ul>
PR #3834 : Increase database format version
Changes since 2.1.214 release:
Important bugs and regression fixes discovered after 2.1.212 release:
Important bugs and regression fixes discovered after 2.1.212 release: <ul> <li>Issue #3538: In Postgres compatibility mode the NUMERIC type w/o scale should not default to 0 </li> <li>Issue #3534: Subquery has incorrect empty parameters since 2.1.210 that breaks sameResultAsLast() </li> <li>Issue #3390: "ROW" cannot be set as a non keyword in 2.x </li> <li>Issue #3448: With linked table to postgreSQL, case-sensitive column names not respected in where part </li> <li>Issue #3434: JavaTableFunction is not closing underlying ResultSet when reading column list </li> <li>Issue #3468: Invalid DB format exception (for 1.x DB in 2.x h2) should have a specific SQLException vendorCode </li> <li>Issue #3528: Weird syntax error with HAVING clause in Oracle Mode </li> <li>Issue #3307: Fix SHUTDOWN DEFRAG for encrypted databases </li> <li>Issue #3515: Support for NEXTVAL property in DB2 mode </li> <li>Issue #3444: Conversion 'text' to 'integer' doesn't work anymore </li> <li>Issue #3493: org.h2.tools.DeleteDbFiles won't delete files under certain circumstances </li> <li>Issue #3486: FilePathDisk.newDirectoryStream() may fail on remote drive on Windows due to AccessDeniedException in Path.toRealPath() </li> <li>Issue #3484: LOB issue </li> </ul>
Numerous bugs and regression fixes discovered after 2.1.210 release:
Numerous bugs and regression fixes discovered after 2.1.210 release:
Two security vulnerabilities in H2 Console ( CVE-2022-23221 and possible DNS rebinding attack) are fixed.
Two security vulnerabilities in H2 Console (CVE-2022-23221 and possible DNS rebinding attack) are fixed.
Persistent databases created by H2 2.0.x don't need to be upgraded.
Persistent databases created by H2 1.4.200 and older versions require export into SQL script with that old version and creation of a new database with the new version and execution of this script in it.
Critical security issue with H2 console is fixed.
Critical security issue with H2 console is fixed.
Also important changes included:
Multilple regression fixes discovered after 2.0.202 release,
Multilple regression fixes discovered after 2.0.202 release,
There are no persistence changes between 2.0.202 and 2.0.204, so jar file swap is enough, if database had been upgraded to 2.0.202 already, otherwise please read the message below:
Between version 1.4.200 and version 2.0.202 there have been considerable changes, such that a simple update is not possible. The official way to upgrade is to do a BACKUP of your existing database USING YOUR CURRENT VERSION OF H2. Then create a fresh database USING THE NEW VERSION OF H2, then perform a SCRIPT to load your data.
Besides many dozens of fixed bugs, performance improvements, more adherence to a standard SQL syntax and type system, there are
Besides many dozens of fixed bugs, performance improvements, more adherence to a standard SQL syntax and type system, there are
Some new features:
MVStore changes:
Between version 1.4.200 and version 2.0.202 there have been considerable changes, such that a simple update is not possible. The official way to upgrade is to do a BACKUP of your existing database USING YOUR CURRENT VERSION OF H2. Then create a fresh database USING THE NEW VERSION OF H2, then perform a SCRIPT to load your data.
JSON data type; JSON_OBJECT, JSON_ARRAY, JSON_OBJECTAGG, and JSON_ARRAYAGG functions; JSON predicate
Some new features:
Incompatible changes:
Other changes:
Known issues:
See change log for the complete list of changes.
Nothing published for this version
Experimental implementation of all standard window functions.
Features
Experimental implementation of all standard window functions.
Hypothetical set and inverse distribution functions.
INTERVAL data type.
Geomety type and SRID constraints for GEOMETRY data type, M and ZM dimension systems support.
WITH TIES and PERCENT support in FETCH clause.
SELECT DISTINCT ON(expression, …).
java.sql.SQLXML support.
Standard systax for ARRAY values, some new functions.
Performance
MVStore engine is multi-threaded by default.
Performance and atomicity improvements in MVStore engine.
Large result sets are processed faster with MVStore engine.
Large OFFSET values are faster in some queries.
Other
TCP Server and H2 Console do not allow creation of new databases by default.
MVCC setting is removed, MVStore uses row-level locks and PageStore uses table-level locks unconditionally.
MVStore jar incudes TransactionStore too.
Lucene is upgraded to 5.5.5-7.6.0.
JTS library is not required any more for GEOMETRY data type.
h2.oldStyleOuterJoin setting and limited support for archaic (+) outer joins are removed.
See change log for a complete list of changes.
Nothing published for this version
Bugfixes and some new features
Bugfixes and some new features
Bugfixes and some new features
Bugfixes and some new features
Various bugfixes and new features
Various bugfixes and new features
Many bugfixes, and slightly increased concurrency.
Many bugfixes, and slightly increased concurrency.
Improved performance, new experimental data type "timestamp with timezone", improved SQL syntax.
Improved performance, new experimental data type "timestamp with timezone", improved SQL syntax.
Bugfixes and minor new features.
Bugfixes and minor new features.
MVStore: CLOB and BLOB cleanup
MVStore: CLOB and BLOB cleanup
Nothing published for this version
MVStore: protection against power failure and out of memory.
MVStore: protection against power failure and out of memory.
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
One column per quarter.