Groups
Groups
Sign in
Groups
Groups
H2 Database
Conversations
About
Send feedback
Help
H2 Database
1–30 of 6730
This is the mailing list of the
H2 database engine
.
Mark all as read
Report group
0 selected
Cen Zhang
Nov 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:/
Nov 25
Pascal Matthäus
Nov 12
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
Nov 12
Volodymyr Lishchynskyi
,
Evgenij Ryazanov
3
Oct 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 <
Oct 25
Xavier Dury
2
Oct 14
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
Oct 14
Andrei Tokar
, …
rpra...@gmail.com
4
Sep 29
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
Sep 29
FAP
, …
marcolopes
3
Sep 24
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!
Sep 24
TINSAE TADESSE GUTEMA
Sep 20
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
Sep 20
Yury Shafran
,
Andreas Reichel
2
Sep 18
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
Sep 18
Rinse Lemstra
,
Noel Grandin
2
Sep 18
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%.
Sep 18
Rinse Lemstra
,
Noel Grandin
2
Sep 11
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" ?
Sep 11
Martin Changer
, …
Arthur Poiret
9
Sep 11
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
Sep 11
neive
Sep 3
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
Sep 3
Stephen Booth
Aug 30
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
Aug 30
seungyong Hong (isanghaessi)
Aug 21
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
Aug 21
neive
Aug 5
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
Aug 5
Ruan Xin
,
Evgenij Ryazanov
3
Aug 5
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
Aug 5
Rinse Lemstra
,
Andrei Tokar
2
Jul 26
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
Jul 26
Rinse Lemstra
, …
Stephane BARBARAY
4
Jul 22
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
Jul 22
Arjun Sahoo
, …
Michael Earl
11
Jul 15
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
Jul 15
Michael Earl
, …
Andreas Reichel
10
Jul 15
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
Jul 15
Thompson Hollis
Jul 7
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.
Jul 7
Joe (Udlooc)
Jun 24
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
Jun 24
Rinse Lemstra
,
Andrei Tokar
2
May 24
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
May 24
Youssef AYYAR
,
Christian Buchegger
3
May 22
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
May 22
Mike Goodwin
, …
Andrei Tokar
4
May 5
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://
May 5
Rinse Lemstra
, …
Bill
4
Apr 23
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
Apr 23
Gino Marckx
,
Evgenij Ryazanov
3
Apr 9
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
Apr 9
Doug Merrett
,
Andreas Reichel
3
Apr 1
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
Apr 1
Roberto La Rosa
,
Evgenij Ryazanov
2
Mar 26
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,
Mar 26
Wesley zen
Mar 26
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
Mar 26
