Groups
Conversations
All groups and messages
Send feedback to Google
Help
Training
Sign in
Groups
H2 Database
Conversations
About
H2 Database
Contact owners and managers
1–30 of 6644
This is the mailing list of the
H2 database engine
.
Mark all as read
Report group
0 selected
Alexander Kainz
, …
Vincent
4
Mar 17
A single update can 10x the filesize of the database
Hello, I am not a maintainer of H2 but I was curious and I have quickly looked at your test case. If
unread,
A single update can 10x the filesize of the database
Hello, I am not a maintainer of H2 but I was curious and I have quickly looked at your test case. If
Mar 17
Olaf van der Meer
,
Evgenij Ryazanov
2
Mar 12
concurrent queries
Hi! All 1.*.* versions of H2 are entirely outdated and aren't supported in any way. 1. H2 1.4.*
unread,
concurrent queries
Hi! All 1.*.* versions of H2 are entirely outdated and aren't supported in any way. 1. H2 1.4.*
Mar 12
Ulrich
,
Noel Grandin
2
Mar 12
Compact on db close does not shrink db file size
On 3/12/2024 10:28 AM, Ulrich wrote: > > My database has around 50.000 tables storing several
unread,
Compact on db close does not shrink db file size
On 3/12/2024 10:28 AM, Ulrich wrote: > > My database has around 50.000 tables storing several
Mar 12
Sergio Morales
Mar 8
Rate limiting in H2
Hi, what options are available when you have a single server managing multiple databases? How can I
unread,
Rate limiting in H2
Hi, what options are available when you have a single server managing multiple databases? How can I
Mar 8
mche...@gmail.com
,
mps
2
Mar 4
possible to add these functions?
do it yourself. Starting: rawtohex example for next step: medium P mche...@gmail.com a következőt
unread,
possible to add these functions?
do it yourself. Starting: rawtohex example for next step: medium P mche...@gmail.com a következőt
Mar 4
Olaf van der Meer
,
Toolforger
2
Feb 28
Userdefined functions and synchronized
Not an H2 question but a multithreading-in-Java question. I have answers but don't want to go off
unread,
Userdefined functions and synchronized
Not an H2 question but a multithreading-in-Java question. I have answers but don't want to go off
Feb 28
Ryan Hamilton
,
Roman Stoffel
3
Feb 22
H2 Queries Online - 2.2.220
Thanks Roman. I've repaired the old link with a redirect now. On Thu, Feb 22, 2024 at 1:24 PM
unread,
H2 Queries Online - 2.2.220
Thanks Roman. I've repaired the old link with a redirect now. On Thu, Feb 22, 2024 at 1:24 PM
Feb 22
Peter Borissow
, …
Evgenij Ryazanov
9
Feb 17
Year alias in select statement
Thanks for checking Evgenij. I was mistaken - adding "YEAR" to the "NON_KEYWORDS"
unread,
Year alias in select statement
Thanks for checking Evgenij. I was mistaken - adding "YEAR" to the "NON_KEYWORDS"
Feb 17
Ebuzer Taha Kanat
Feb 11
How to create a database at startup with bash
I'm trying to start database RUN java -cp /tmp/h2/h2.jar org.h2.tools.Server -webAllowOthers -
unread,
How to create a database at startup with bash
I'm trying to start database RUN java -cp /tmp/h2/h2.jar org.h2.tools.Server -webAllowOthers -
Feb 11
Balamurali Krishna Ippili
,
Evgenij Ryazanov
3
Feb 9
UNIQUE KEY constraint in H2-1.4.199 is not working with H2-2.2.224
Hi Evgenij Ryazanov , Thank you so much for your quick response and the suggestion. When changed the
unread,
UNIQUE KEY constraint in H2-1.4.199 is not working with H2-2.2.224
Hi Evgenij Ryazanov , Thank you so much for your quick response and the suggestion. When changed the
Feb 9
Coff ee
2
Feb 8
Need help with IKVM 8.7.5 + H2 2.2.220 + ojdbc8.jar + VS2019 + net472
Update: IKVM 8.7.5 + H2 2.2.220 + ojdbc8.jar + VS2019 + net472 still not work. I have new founding
unread,
Need help with IKVM 8.7.5 + H2 2.2.220 + ojdbc8.jar + VS2019 + net472
Update: IKVM 8.7.5 + H2 2.2.220 + ojdbc8.jar + VS2019 + net472 still not work. I have new founding
Feb 8
Paulo Destro
Feb 2
Is there a workaround for "RETURNING" POSTGRES SQL on H2
I use H2 as JUnit tests and Postgres as the main database. I want to know if there is a workaround
unread,
Is there a workaround for "RETURNING" POSTGRES SQL on H2
I use H2 as JUnit tests and Postgres as the main database. I want to know if there is a workaround
Feb 2
Gaus Lostre
, …
Paulo Destro
4
Feb 2
Infinite looping when trigger updates same table
My git repository https://github.com/pddec/loop On Thursday, January 4, 2024 at 8:27:45 PM UTC-3
unread,
Infinite looping when trigger updates same table
My git repository https://github.com/pddec/loop On Thursday, January 4, 2024 at 8:27:45 PM UTC-3
Feb 2
mche...@gmail.com
,
Andreas Reichel
3
Jan 31
hex
no, i have a column which is integer, I want to display it as hex. thanks On Tuesday 16 January 2024
unread,
hex
no, i have a column which is integer, I want to display it as hex. thanks On Tuesday 16 January 2024
Jan 31
Alberto Soki
Jan 24
Proper Citation for H2 Database Link in Academic Article
Hello, everyone. How to cite this link in the most accurate way in an academic article? I cited it as
unread,
Proper Citation for H2 Database Link in Academic Article
Hello, everyone. How to cite this link in the most accurate way in an academic article? I cited it as
Jan 24
Drew Dimanlig
, …
Evgenij Ryazanov
4
Jan 18
Syntax error with ON CONFLICT
Hello! This PostgreSQL-specific clause is not supported by H2. You need to use the MERGE command from
unread,
Syntax error with ON CONFLICT
Hello! This PostgreSQL-specific clause is not supported by H2. You need to use the MERGE command from
Jan 18
mche...@gmail.com
,
Andreas Reichel
7
Jan 14
push the insert speed to max
This seems to be a useful and interesting link: https://commons.apache.org/proper/commons-jcs/
unread,
push the insert speed to max
This seems to be a useful and interesting link: https://commons.apache.org/proper/commons-jcs/
Jan 14
mche...@gmail.com
, …
Andrei Tokar
5
Jan 12
why insert many record to in-memory database is same speed as embedded-mode
thanks all On Wednesday 10 January 2024 at 09:38:59 UTC+8 Andrei Tokar wrote: Apparently, you
unread,
why insert many record to in-memory database is same speed as embedded-mode
thanks all On Wednesday 10 January 2024 at 09:38:59 UTC+8 Andrei Tokar wrote: Apparently, you
Jan 12
mche...@gmail.com
,
Evgenij Ryazanov
3
Jan 8
is there any command line interface can interact with h2 in shell
thanks On Sunday 31 December 2023 at 14:26:03 UTC+8 Evgenij Ryazanov wrote: Hi! You can use the shell
unread,
is there any command line interface can interact with h2 in shell
thanks On Sunday 31 December 2023 at 14:26:03 UTC+8 Evgenij Ryazanov wrote: Hi! You can use the shell
Jan 8
Ali Atav
,
Andreas Reichel
2
12/26/23
open a db file named xxxxx.h2.db
Greetings! "*.h2.db" is a very old, page store based version of H2 (I believe 1.3.175 or so
unread,
open a db file named xxxxx.h2.db
Greetings! "*.h2.db" is a very old, page store based version of H2 (I believe 1.3.175 or so
12/26/23
Vinicius Carvalho
,
Evgenij Ryazanov
2
12/19/23
Batch insert on key violation
Hello! When you use JDBC directly, H2 throws BatchUpdateException in case of failure, but only after
unread,
Batch insert on key violation
Hello! When you use JDBC directly, H2 throws BatchUpdateException in case of failure, but only after
12/19/23
prayag shete
,
Andreas Reichel
2
12/16/23
H2 db migration tool
On Fri, 2023-12-15 at 04:14 -0800, prayag shete wrote: How to use https://github.com/manticore-
unread,
H2 db migration tool
On Fri, 2023-12-15 at 04:14 -0800, prayag shete wrote: How to use https://github.com/manticore-
12/16/23
Andreas Reichel
12/12/23
Building Pivot Tables with Example
Greetings! Since H2 does not support the `PIVOT` clause yet, we have had to develop a work around,
unread,
Building Pivot Tables with Example
Greetings! Since H2 does not support the `PIVOT` clause yet, we have had to develop a work around,
12/12/23
PavelTurk
12/8/23
Hibernate settings for h2 postgresql mode
I want to use H2 in PostgreSQL mode + Hibernate 6. However, I am not sure about driver and dialect
unread,
Hibernate settings for h2 postgresql mode
I want to use H2 in PostgreSQL mode + Hibernate 6. However, I am not sure about driver and dialect
12/8/23
NaviGon Tuan
12/8/23
Connect to power bi
Hi there, has anybody connect a h2 databse file to opower bi for visualization? The JDBC driver is
unread,
Connect to power bi
Hi there, has anybody connect a h2 databse file to opower bi for visualization? The JDBC driver is
12/8/23
mche...@gmail.com
,
Andrei Tokar
3
12/3/23
out of memory after executeBatch
I figured it out. Java jdbc need some time to flush the cache after all batch are executed. On
unread,
out of memory after executeBatch
I figured it out. Java jdbc need some time to flush the cache after all batch are executed. On
12/3/23
Vincent
12/1/23
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,
12/1/23
Scott Huddleston
,
Noel Grandin
4
11/29/23
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
11/29/23
Kiss, Janos, Atrido
11/27/23
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
11/27/23
Francois Marot
,
Evgenij Ryazanov
3
11/20/23
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
11/20/23