Groups
Conversations
All groups and messages
Send feedback to Google
Help
Sign in
Groups
H2 Database
Conversations
About
H2 Database
Contact owners and managers
1–30 of 6619
This is the mailing list of the
H2 database engine
.
Mark all as read
Report abusive group
0 selected
Vincent
Dec 1
License agreement for PR#3932
In regards to https://github.com/h2database/h2database/pull/3932: I wrote the code, it's mine,
unread,
License agreement for PR#3932
In regards to https://github.com/h2database/h2database/pull/3932: I wrote the code, it's mine,
Dec 1
Scott Huddleston
,
Noel Grandin
4
Nov 29
H2 Shell stuck wanting for response from database running mixed mode (1.4.196)
On Wed, 29 Nov 2023 at 17:46, Scott Huddleston <talascend...@gmail.com> wrote: I don
unread,
H2 Shell stuck wanting for response from database running mixed mode (1.4.196)
On Wed, 29 Nov 2023 at 17:46, Scott Huddleston <talascend...@gmail.com> wrote: I don
Nov 29
Kiss, Janos, Atrido
Nov 27
License agreement for PR#3915
I wrote the code, it's mine, and I'm contributing it to H2 for distribution multiple-licensed
unread,
License agreement for PR#3915
I wrote the code, it's mine, and I'm contributing it to H2 for distribution multiple-licensed
Nov 27
mche...@gmail.com
,
Andrei Tokar
2
Nov 21
out of memory after executeBatch
Hi Peter, It is really hard to tell exactly what the problem with your code is, because it is not a
unread,
out of memory after executeBatch
Hi Peter, It is really hard to tell exactly what the problem with your code is, because it is not a
Nov 21
Francois Marot
,
Evgenij Ryazanov
3
Nov 20
Lock file absent by default ?
Thanks Evgenij, seems like I have to refresh my system knowledge and I have been using veeeeery old
unread,
Lock file absent by default ?
Thanks Evgenij, seems like I have to refresh my system knowledge and I have been using veeeeery old
Nov 20
Abeleshev Artem
, …
yusuf welder
4
Nov 18
Unnesting multiple array columns
https://www.timestored.com/data/h2-database-online/?qcode=DROP%20TABLE%20IF%20EXISTS%20weather%3B%
unread,
Unnesting multiple array columns
https://www.timestored.com/data/h2-database-online/?qcode=DROP%20TABLE%20IF%20EXISTS%20weather%3B%
Nov 18
Knut Skomedal
,
Noel Grandin
11
Oct 25
Java junit tests fails with "object already exists" after upgrade from h2 1.4.199 to 2.2.224
D'oh, I ran the tests with version 1.4.199 the first time, they're still failing with 2.2.224
unread,
Java junit tests fails with "object already exists" after upgrade from h2 1.4.199 to 2.2.224
D'oh, I ran the tests with version 1.4.199 the first time, they're still failing with 2.2.224
Oct 25
Hyeonsu Byun
Oct 9
Questions about FIle Encryption
Hello, I appreciate your kind words about the program. I have a question regarding file encryption.
unread,
Questions about FIle Encryption
Hello, I appreciate your kind words about the program. I have a question regarding file encryption.
Oct 9
Pierre Caron
, …
Eric Njogu
8
Oct 4
LIMIT keyword no longer supported
Thanks for the tip Evgenij Ryazanov. Was facing a similar issue. Added the following to a Junit5
unread,
LIMIT keyword no longer supported
Thanks for the tip Evgenij Ryazanov. Was facing a similar issue. Added the following to a Junit5
Oct 4
Andrei Tokar
Sep 16
H2 Database Engine: New version released
Hello Everybody, A new version 2.2.224 of H2 is available at http://www.h2database.com (you may have
unread,
H2 Database Engine: New version released
Hello Everybody, A new version 2.2.224 of H2 is available at http://www.h2database.com (you may have
Sep 16
Nils Tolleshaug
,
Evgenij Ryazanov
4
Sep 15
Use of COMMIT TRANSACTION
Thanks! Much better solution and seems like COMMIT and ROLLBACK works as expected. Nils fredag 15.
unread,
Use of COMMIT TRANSACTION
Thanks! Much better solution and seems like COMMIT and ROLLBACK works as expected. Nils fredag 15.
Sep 15
Elemér Zágoni
,
Evgenij Ryazanov
2
Sep 14
Support returning ID of inserted row right from the INSERT INTO statement
Hello! H2 supports standard data change delta tables: https://h2database.com/html/grammar.html#
unread,
Support returning ID of inserted row right from the INSERT INTO statement
Hello! H2 supports standard data change delta tables: https://h2database.com/html/grammar.html#
Sep 14
Bastian Linneweber
,
Evgenij Ryazanov
2
Sep 14
like 'test%' with escape '' not working in MODE=ORACLE
Hello! This issue cannot be resolved on H2 side. ESCAPE '' is not valid according to the SQL
unread,
like 'test%' with escape '' not working in MODE=ORACLE
Hello! This issue cannot be resolved on H2 side. ESCAPE '' is not valid according to the SQL
Sep 14
Andrei Tokar
, …
Evgenij Ryazanov
18
Sep 12
H2 Database Engine: New version released
H2 2.2.222 has a known regression: it doesn't perform automatic calculation of statistics. You
unread,
H2 Database Engine: New version released
H2 2.2.222 has a known regression: it doesn't perform automatic calculation of statistics. You
Sep 12
Al Grant
,
Evgenij Ryazanov
2
Sep 12
H2 mem db failing with LocalDateTime
Hello! You cannot use MySQL/MariaDB-specific features without MySQL or MariaDB compatibility mode:
unread,
H2 mem db failing with LocalDateTime
Hello! You cannot use MySQL/MariaDB-specific features without MySQL or MariaDB compatibility mode:
Sep 12
Ronery Coder
,
Andrei Tokar
4
Sep 8
It is my pleasure to present some transaction-testing code...
Thank you Andrei, If H2 is stricter than necessary, that's fine. I have update all my code to
unread,
It is my pleasure to present some transaction-testing code...
Thank you Andrei, If H2 is stricter than necessary, that's fine. I have update all my code to
Sep 8
Andreas Reichel
,
Evgenij Ryazanov
4
Sep 5
Comparing NULL able columns
On Mon, 2023-09-04 at 20:41 -0700, Evgenij Ryazanov wrote: IS DISTINCT FROM is a null-safe equivalent
unread,
Comparing NULL able columns
On Mon, 2023-09-04 at 20:41 -0700, Evgenij Ryazanov wrote: IS DISTINCT FROM is a null-safe equivalent
Sep 5
Peter Borissow
,
Evgenij Ryazanov
3
Aug 31
Create Table Problem (Upgrading from 1.4.x)
Thank you Evgenij, Adding the following properties definitely helped: properties.setProperty("
unread,
Create Table Problem (Upgrading from 1.4.x)
Thank you Evgenij, Adding the following properties definitely helped: properties.setProperty("
Aug 31
t603
,
Andrei Tokar
5
Aug 23
2.2.220: File corrupted in chunk 17, expected page length 4..1536, got -1711276031 [2.2.220/6]
Hi, Andrei, I run my code just now with h2-2.2.222.jar released yesterday evening for public and I
unread,
2.2.220: File corrupted in chunk 17, expected page length 4..1536, got -1711276031 [2.2.220/6]
Hi, Andrei, I run my code just now with h2-2.2.222.jar released yesterday evening for public and I
Aug 23
Andreas Reichel
Aug 21
Fastest way to load MASSIVE data into H2
Greetings! Please what would be the equivalent to Oracle SQL Loader for H2? I know that H2 can read
unread,
Fastest way to load MASSIVE data into H2
Greetings! Please what would be the equivalent to Oracle SQL Loader for H2? I know that H2 can read
Aug 21
Richard Billa
,
Noel Grandin
3
Aug 4
Using (+) symbol for joins H2 database in Oracle mode
OK, Thanks for the reply. On Thursday, 3 August 2023 at 21:42:10 UTC+5:30 Noel Grandin wrote: Sorry,
unread,
Using (+) symbol for joins H2 database in Oracle mode
OK, Thanks for the reply. On Thursday, 3 August 2023 at 21:42:10 UTC+5:30 Noel Grandin wrote: Sorry,
Aug 4
Fredrik Sjögren
, …
Noel Grandin
5
Aug 3
Problem upgrading from h2 version 2.1.214 to 2.2.220
On 8/3/2023 1:10 PM, Thomas Hurley wrote: > I am Product Manager for 3 products all using H2 DB
unread,
Problem upgrading from h2 version 2.1.214 to 2.2.220
On 8/3/2023 1:10 PM, Thomas Hurley wrote: > I am Product Manager for 3 products all using H2 DB
Aug 3
Thomas Hurley
,
Andreas Reichel
2
Aug 3
H2 DB - Issues with the migration need from 2.1 to 2.2. And likely again to 2.3?
On Thu, 2023-08-03 at 04:27 -0700, Thomas Hurley wrote: I am a Product Manager with 3 commercial
unread,
H2 DB - Issues with the migration need from 2.1 to 2.2. And likely again to 2.3?
On Thu, 2023-08-03 at 04:27 -0700, Thomas Hurley wrote: I am a Product Manager with 3 commercial
Aug 3
prrvchr
Aug 2
H2 as an embedded database in LibreOffice / OpenOffice Base
It is possible to integrate any JDBC database into LibreOffice or OpenOffice Base. This integration
unread,
H2 as an embedded database in LibreOffice / OpenOffice Base
It is possible to integrate any JDBC database into LibreOffice or OpenOffice Base. This integration
Aug 2
Pierre-Olivier Lecomte
Jul 27
Database never reduce its file size until the connection is shut down in 2.1.214. Version 1.4.200 does.
Hello, We faced a situation with H2 V2.1.214 where the database file size never goes down until all
unread,
Database never reduce its file size until the connection is shut down in 2.1.214. Version 1.4.200 does.
Hello, We faced a situation with H2 V2.1.214 where the database file size never goes down until all
Jul 27
Pierre-Olivier Lecomte
Jul 27
Database never reduce its file size until the connection is shut down in 2.1.214. Version 1.4.200 does
Hello, We faced issue with long running databases in H2 v2.1.214 which file size never goes down
unread,
Database never reduce its file size until the connection is shut down in 2.1.214. Version 1.4.200 does
Hello, We faced issue with long running databases in H2 v2.1.214 which file size never goes down
Jul 27
Andrii Odnoviunenko
,
Andreas Reichel
2
Jul 19
Slow Performance of Update / merge into sStatements
Greetings! 1) your write "embedded" mode, but your URL shows File access (not Memory) 2)
unread,
Slow Performance of Update / merge into sStatements
Greetings! 1) your write "embedded" mode, but your URL shows File access (not Memory) 2)
Jul 19
Andrii Odnoviunenko
Jul 19
test
test
unread,
test
test
Jul 19
Ryan Hamilton
Jul 18
Run H2 Database in Browser
Hi, Some of you may find it useful or interesting to be able to run H2 SQL in the browser: https://
unread,
Run H2 Database in Browser
Hi, Some of you may find it useful or interesting to be able to run H2 SQL in the browser: https://
Jul 18
CrazyDrumming
,
Noel Grandin
3
Jul 12
Time statistics for explian analzy
Meaning that this time does not include the time to convert the result to String? Because in some
unread,
Time statistics for explian analzy
Meaning that this time does not include the time to convert the result to String? Because in some
Jul 12