Groups

H2 Database

1–30 of 6730

This is the mailing list of the H2 database engine.

0 selected

11/25/25

Proposal: Security Assessment from Team Atlanta (DARPA AIxCC)

Hi H2 Database developers, We ([LeeSinLiang](https://github.com/LeeSinLiang), and [Cen Zhang](https:/

unread,

Proposal: Security Assessment from Team Atlanta (DARPA AIxCC)

Hi H2 Database developers, We ([LeeSinLiang](https://github.com/LeeSinLiang), and [Cen Zhang](https:/

11/25/25

Pascal Matthäus

11/12/25

License statement GH PR 4305

Regarding my PR on https://github.com/h2database/pull/4305 I wrote the code, it's mine, and I

unread,

License statement GH PR 4305

Regarding my PR on https://github.com/h2database/pull/4305 I wrote the code, it's mine, and I

11/12/25

Volodymyr Lishchynskyi, Evgenij Ryazanov3

10/25/25

Invalid query is successfuly executed by H2 with DB2 mode.

Gotcha. Thanks for a quick response. сб, 25 жовт. 2025 р., 03:43 користувач Evgenij Ryazanov <

unread,

Invalid query is successfuly executed by H2 with DB2 mode.

Gotcha. Thanks for a quick response. сб, 25 жовт. 2025 р., 03:43 користувач Evgenij Ryazanov <

10/25/25

10/14/25

Recursive CTEs and stop condition

Another way to do it using Arrays (this is a more general solution which does not need values to be

unread,

Recursive CTEs and stop condition

Another way to do it using Arrays (this is a more general solution which does not need values to be

10/14/25

Andrei Tokar, … rpra...@gmail.com4

9/29/25

H2 Database Engine: New version 2.4.240 released

Hello, thanks for the new release. I know, backups are always recommended, but is it required to

unread,

H2 Database Engine: New version 2.4.240 released

Hello, thanks for the new release. I know, backups are always recommended, but is it required to

9/29/25

FAP, … marcolopes3

9/24/25

Feature not supported: autoServerMode

That was it! I got around this problem in 2025!!! READONLY database file (copied from MAC to Windows!

unread,

Feature not supported: autoServerMode

That was it! I got around this problem in 2025!!! READONLY database file (copied from MAC to Windows!

9/24/25

TINSAE TADESSE GUTEMA

9/20/25

Running H2 Database as a User Binary

The steps below provide a solution for running the H2 Database console from a ZIP installation while

unread,

Running H2 Database as a User Binary

The steps below provide a solution for running the H2 Database console from a ZIP installation while

9/20/25

Yury Shafran, Andreas Reichel2

9/18/25

H2 2.x CTE support

Greetings, since the re-implementation, the `WITH ...` belongs to the `SELECT` query only and

unread,

H2 2.x CTE support

Greetings, since the re-implementation, the `WITH ...` belongs to the `SELECT` query only and

9/18/25

Rinse Lemstra, Noel Grandin2

9/18/25

how to explore temporary data

On 9/17/2025 11:28 AM, Rinse Lemstra wrote: > during the day my databases can grow up to 20%.

unread,

how to explore temporary data

On 9/17/2025 11:28 AM, Rinse Lemstra wrote: > during the day my databases can grow up to 20%.

9/18/25

Rinse Lemstra, Noel Grandin2

9/11/25

Does this make sense?

Do you have some other object that is not a LINKED TABLE that has the name "CHAT_MESSAGE" ?

unread,

Does this make sense?

Do you have some other object that is not a LINKED TABLE that has the name "CHAT_MESSAGE" ?

9/11/25

Martin Changer, … Arthur Poiret9

9/11/25

ETA for next Release?

any updates or ETA for the next release? thanks, Le lundi 4 août 2025 à 20:41:20 UTC+2, Rinse Lemstra

unread,

ETA for next Release?

any updates or ETA for the next release? thanks, Le lundi 4 août 2025 à 20:41:20 UTC+2, Rinse Lemstra

9/11/25

9/3/25

License statement for PR #4273

Hi H2 team, I, naive924 , wrote the code in PR #4273 and it is mine. I am contributing it to H2 for

unread,

License statement for PR #4273

Hi H2 team, I, naive924 , wrote the code in PR #4273 and it is mine. I am contributing it to H2 for

9/3/25

8/30/25

Creating tables using jdbc

I have some code I'm porting to H2 that creates tables programmatically using a PreparedStatement

unread,

Creating tables using jdbc

I have some code I'm porting to H2 that creates tables programmatically using a PreparedStatement

8/30/25

seungyong Hong (isanghaessi)

8/21/25

License agreement for PR#4261

I wrote the code, it's mine, and I'm contributing it to H2 for distribution multiple-licensed

unread,

License agreement for PR#4261

I wrote the code, it's mine, and I'm contributing it to H2 for distribution multiple-licensed

8/21/25

8/5/25

LIMIT not working with Linked Tables?

Hi all, I'm using H2 2.2.224 and noticed that when querying a linked table like this: sql SELECT

unread,

LIMIT not working with Linked Tables?

Hi all, I'm using H2 2.2.224 and noticed that when querying a linked table like this: sql SELECT

8/5/25

Ruan Xin, Evgenij Ryazanov3

8/5/25

New h2 does not support continuously umber comparisons!

I now understand and agree with you, thanks for your reply! On Tue, Jul 22, 2025 at 8:12 AM Evgenij

unread,

New h2 does not support continuously umber comparisons!

I now understand and agree with you, thanks for your reply! On Tue, Jul 22, 2025 at 8:12 AM Evgenij

8/5/25

Rinse Lemstra, Andrei Tokar2

7/26/25

advice create momery local temporary table

Hello Rinse, Firs of all, I think that you are mistaken about GitHub Issue #4247. It has nothing to

unread,

advice create momery local temporary table

Hello Rinse, Firs of all, I think that you are mistaken about GitHub Issue #4247. It has nothing to

7/26/25

Rinse Lemstra, … Stephane BARBARAY4

7/22/25

Please help understanding the trace-file

The root cause looks very promising, nice job -- Stéphane BARBARAY Le 22 juil. 2025 à 12:30, Arthur

unread,

Please help understanding the trace-file

The root cause looks very promising, nice job -- Stéphane BARBARAY Le 22 juil. 2025 à 12:30, Arthur

7/22/25

Arjun Sahoo, … Michael Earl11

7/15/25

In-Memory H2 deleted rows not garbage collected.

Hello Arjun, Did you ever get this issue resolved? I am having the same issue with H2 in Spring Boot

unread,

In-Memory H2 deleted rows not garbage collected.

Hello Arjun, Did you ever get this issue resolved? I am having the same issue with H2 in Spring Boot

7/15/25

Michael Earl, … Andreas Reichel10

7/15/25

Database continues to grow and does not reclaim deleted space

On Tue, 2025-07-15 at 08:35 -0700, Michael Earl wrote: We have also used h2 in production for about

unread,

Database continues to grow and does not reclaim deleted space

On Tue, 2025-07-15 at 08:35 -0700, Michael Earl wrote: We have also used h2 in production for about

7/15/25

Thompson Hollis

7/7/25

Please help resolve the issue of H2 database file corruption caused by abnormal power outage

Due to abnormal power outage, the h2 database file was damaged, and the exception prompt is: java.

unread,

Please help resolve the issue of H2 database file corruption caused by abnormal power outage

Due to abnormal power outage, the h2 database file was damaged, and the exception prompt is: java.

7/7/25

6/24/25

Remove my email

Good morning, I've just noticed that I am part of this H2 Database group, which I have no idea

unread,

Remove my email

Good morning, I've just noticed that I am part of this H2 Database group, which I have no idea

6/24/25

Rinse Lemstra, Andrei Tokar2

5/24/25

is this still true ?

I believe so. Cache will be cleared, but it does not mean that you are going to loose any data, just

unread,

is this still true ?

I believe so. Cache will be cleared, but it does not mean that you are going to loose any data, just

5/24/25

Youssef AYYAR, Christian Buchegger3

5/22/25

Please I need help to connect to H2 database using Python.

OK, Thank you so much. On Thu, May 22, 2025 at 5:43 PM 'Christian Buchegger' via H2 Database

unread,

Please I need help to connect to H2 database using Python.

OK, Thank you so much. On Thu, May 22, 2025 at 5:43 PM 'Christian Buchegger' via H2 Database

5/22/25

Mike Goodwin, … Andrei Tokar4

5/5/25

H2 Architecture

You do not even have to build anything. It's published to Maven along with H2: https://

unread,

H2 Architecture

You do not even have to build anything. It's published to Maven along with H2: https://

5/5/25

Rinse Lemstra, … Bill4

4/23/25

Anyone have suggestions?

I use a cache size of H2_CACHE_SIZE = 1000000, could that be the reason. After I run a query over all

unread,

Anyone have suggestions?

I use a cache size of H2_CACHE_SIZE = 1000000, could that be the reason. After I run a query over all

4/23/25

Gino Marckx, Evgenij Ryazanov3

4/9/25

Is the database configurable to support constraints with same name for different tables?

Thanks for the info! I was able to fix it quickly by adding a migration to rename the constraints and

unread,

Is the database configurable to support constraints with same name for different tables?

Thanks for the info! I was able to fix it quickly by adding a migration to rename the constraints and

4/9/25

Doug Merrett, Andreas Reichel3

4/1/25

restore script and backup script - some form of sign of life

Thanks very much Andreas. On Wed, 2 Apr 2025 at 13:05, Andreas Reichel <andreas@manticore-projects

unread,

restore script and backup script - some form of sign of life

Thanks very much Andreas. On Wed, 2 Apr 2025 at 13:05, Andreas Reichel <andreas@manticore-projects

4/1/25

Roberto La Rosa, Evgenij Ryazanov2

3/26/25

pg server does not show pg_catalog once remote session connected ?

Hello! Since H2 2.0.202 connection through PostgreSQL protocol automatically enables MODE=PostgreSQL,

unread,

pg server does not show pg_catalog once remote session connected ?

Hello! Since H2 2.0.202 connection through PostgreSQL protocol automatically enables MODE=PostgreSQL,

3/26/25

3/26/25

The execution process of the SQL statement is visible in the logs, but the table cannot be found in the PUBLIC schema.

Problem description: I integrated H2 Database for unit testing in my current project. I can see the

unread,

The execution process of the SQL statement is visible in the logs, but the table cannot be found in the PUBLIC schema.

Problem description: I integrated H2 Database for unit testing in my current project. I can see the

3/26/25

Search

Clear search

Close search

Google apps

Main menu