Groups
Groups
Sign in
Groups
Groups
H2 Database
Conversations
About
Send feedback
Help
H2 Database
1–30 of 6721
This is the mailing list of the
H2 database engine
.
Mark all as read
Report group
0 selected
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
Martin Changer
, …
Rinse Lemstra
8
Aug 4
ETA for next Release?
I also support this question / request Op zondag 3 augustus 2025 om 22:12:00 UTC+2 schreef Arthur
unread,
ETA for next Release?
I also support this question / request Op zondag 3 augustus 2025 om 22:12:00 UTC+2 schreef Arthur
Aug 4
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
virimchi m
,
Evgenij Ryazanov
3
Mar 24
Possible defect: Java methods as stored procs run thrice when ran once
Thank you for pointing me to the documentation. I have spring Jdbc code that calls SQL server stored
unread,
Possible defect: Java methods as stored procs run thrice when ran once
Thank you for pointing me to the documentation. I have spring Jdbc code that calls SQL server stored
Mar 24
Paul Hrdina
, …
Andreas Reichel
6
Mar 21
Reasons for using proprietary testing infrastructure
Hi Thomas and Andreas, Thank you very much for your insights into the current state of H2 testing
unread,
Reasons for using proprietary testing infrastructure
Hi Thomas and Andreas, Thank you very much for your insights into the current state of H2 testing
Mar 21
Noel Grandin
, …
who...@gmail.com
3
Mar 8
Re: [h2] Extremely slow update performance
Thanks for the tips. I did try limiting it to fewer rows. I didn't mean to delete the OP, I meant
unread,
Re: [h2] Extremely slow update performance
Thanks for the tips. I did try limiting it to fewer rows. I didn't mean to delete the OP, I meant
Mar 8
Alex Tiboldi
Jan 26
Recovery of a split database
I have an old large (split) database created with the v1.4.200 version...keyword old and forgot the
unread,
Recovery of a split database
I have an old large (split) database created with the v1.4.200 version...keyword old and forgot the
Jan 26
philfrei1
, …
Evgenij Ryazanov
5
Jan 25
environment variable is being considered "implicitly relative" by systemd?
SOLVED: For whatever reason, a system-level environment variable is not accessible for a service
unread,
environment variable is being considered "implicitly relative" by systemd?
SOLVED: For whatever reason, a system-level environment variable is not accessible for a service
Jan 25
Mike Goodwin
,
Evgenij Ryazanov
2
Jan 23
Rational Datatype
Hello! There is no such thing in SQL and usually fractions are stored in a couple of numeric fields,
unread,
Rational Datatype
Hello! There is no such thing in SQL and usually fractions are stored in a couple of numeric fields,
Jan 23
Andreas Reichel
Jan 14
Java io_uring bindings
Please see https://github.com/davidtos/JUring "JUring is a high-performance Java library that
unread,
Java io_uring bindings
Please see https://github.com/davidtos/JUring "JUring is a high-performance Java library that
Jan 14
Bastian Linneweber
, …
Noel Grandin
6
Jan 14
like 'test%' with escape '' not working in MODE=ORACLE
On 1/14/2025 10:25 AM, Marcus wrote: > > And, to be honest, giving an empty result because of a
unread,
like 'test%' with escape '' not working in MODE=ORACLE
On 1/14/2025 10:25 AM, Marcus wrote: > > And, to be honest, giving an empty result because of a
Jan 14
Balamurali Krishna Ippili
, …
Evgenij Ryazanov
7
Jan 10
File corrupted while reading record: Possible solution: use the recovery tool [90030-224]
Hi Evgenij, Thanks for your reply and the points that you have mentioned and will try to upgrade to
unread,
File corrupted while reading record: Possible solution: use the recovery tool [90030-224]
Hi Evgenij, Thanks for your reply and the points that you have mentioned and will try to upgrade to
Jan 10
Dan Howard
,
Andreas Reichel
2
12/23/24
The database has been closed from AssertionError
Please upgrade to the latest H2 version. H2 2.2.224 was not the best release and quite a few
unread,
The database has been closed from AssertionError
Please upgrade to the latest H2 version. H2 2.2.224 was not the best release and quite a few
12/23/24