Groups
Conversations
All groups and messages
Send feedback to Google
Help
Sign in
Groups
H2 Database
Conversations
About
H2 Database
1–30 of 6582
This is the mailing list of the
H2 database engine
.
Mark all as read
Report abusive group
0 selected
小林裕幸
,
Andreas Reichel
3
May 25
SpringBoot multi Thread. Query extremely slow
Greetings once again. One thing you could do for confirming the performance: Export your tables into
unread,
SpringBoot multi Thread. Query extremely slow
Greetings once again. One thing you could do for confirming the performance: Export your tables into
May 25
Arjun Sahoo
, …
Andrei Tokar
10
May 24
In-Memory H2 deleted rows not garbage collected.
The problem still exists in 2.1.214 and with LOB_TIMEOUT=1000. The issue could not be reproduced with
unread,
In-Memory H2 deleted rows not garbage collected.
The problem still exists in 2.1.214 and with LOB_TIMEOUT=1000. The issue could not be reproduced with
May 24
Vardhan Belide
, …
Noel Grandin
3
May 23
Problem updating from 1.4.200 to 2.1.214
I don't know how that code could ever have compiled. A JdbcDataSource is a supplier of java.sql.
unread,
Problem updating from 1.4.200 to 2.1.214
I don't know how that code could ever have compiled. A JdbcDataSource is a supplier of java.sql.
May 23
mrbr...@gmail.com
,
Andreas Reichel
3
May 12
Latest version H2 available via tycho
Thanks, I glanced at this, it is quite a job to make the change and there are a large number of plug
unread,
Latest version H2 available via tycho
Thanks, I glanced at this, it is quite a job to make the change and there are a large number of plug
May 12
Christian Dirks
,
Noel Grandin
3
May 5
Need advice with embedded H2 losing data due to "revert"
Thanks for the reply. I do not believe that the application is used in a setup with cloud-share by
unread,
Need advice with embedded H2 losing data due to "revert"
Thanks for the reply. I do not believe that the application is used in a setup with cloud-share by
May 5
Thomas Collignon
May 4
In-file H2 database in a Docker container
Hello, Is there an example somewhere of the code of a simple Java app (Spring Boot would be nice)
unread,
In-file H2 database in a Docker container
Hello, Is there an example somewhere of the code of a simple Java app (Spring Boot would be nice)
May 4
prrvchr
, …
Noel Grandin
18
May 2
How to differentiate system tables from others
no, that doesn't change anything... Le mardi 2 mai 2023 à 21:30:00 UTC+2, prrvchr a écrit : I
unread,
How to differentiate system tables from others
no, that doesn't change anything... Le mardi 2 mai 2023 à 21:30:00 UTC+2, prrvchr a écrit : I
May 2
Silvio
, …
Noel Grandin
5
Apr 26
Request for advice
That is actually a very good idea. We never considered using a UNION here. Would H2 be able to use a
unread,
Request for advice
That is actually a very good idea. We never considered using a UNION here. Would H2 be able to use a
Apr 26
Andreas Reichel
Apr 25
PR #3786 CSV empty String to Number conversion
Greetings! To whom it may concern: I wrote the code, it's mine, and I'm contributing it to H2
unread,
PR #3786 CSV empty String to Number conversion
Greetings! To whom it may concern: I wrote the code, it's mine, and I'm contributing it to H2
Apr 25
ChereGG
,
Evgenij Ryazanov
5
Apr 24
[Spring bot3 + h2 v.2.1.214] H2 failing to fetch Java Instant.
You are right! Creating a custom converter solved the issue. I'm not sure tho why did this issue
unread,
[Spring bot3 + h2 v.2.1.214] H2 failing to fetch Java Instant.
You are right! Creating a custom converter solved the issue. I'm not sure tho why did this issue
Apr 24
ELIELDO MARTINS
2
Apr 19
Integration Tests for Oracle
I did some research and found that Hibernate can generate the tables through the "spring.jpa.
unread,
Integration Tests for Oracle
I did some research and found that Hibernate can generate the tables through the "spring.jpa.
Apr 19
Jürgen Pingel
,
Andreas Reichel
3
Apr 18
DB file size grows in an unexpected size (H2 version 1.4)
Just to cheer you up: I just turned a 2 GByte database into a 15 GByte Database -- by running a
unread,
DB file size grows in an unexpected size (H2 version 1.4)
Just to cheer you up: I just turned a 2 GByte database into a 15 GByte Database -- by running a
Apr 18
airjairj
, …
Moleesh A
4
Apr 14
Alter table not working from code with prepared statements, but working from console (browser)
Parameterized placeholders in prepared statements can only be used for values, not for database
unread,
Alter table not working from code with prepared statements, but working from console (browser)
Parameterized placeholders in prepared statements can only be used for values, not for database
Apr 14
Moleesh A
,
Andreas Reichel
4
Apr 13
Need help in diagnosing the db file
I guess i can wait. On Thursday, April 13, 2023 at 8:25:26 PM UTC+5:30 Andreas Reichel wrote:
unread,
Need help in diagnosing the db file
I guess i can wait. On Thursday, April 13, 2023 at 8:25:26 PM UTC+5:30 Andreas Reichel wrote:
Apr 13
Olaf van der Meer
Apr 13
Timeout trying to lock table when using transactions
Hi, A Timeout trying to lock table "SYSTEEM" error occurs in the next situation:
unread,
Timeout trying to lock table when using transactions
Hi, A Timeout trying to lock table "SYSTEEM" error occurs in the next situation:
Apr 13
Mohamad Ibrahim
Apr 8
Error when recovering a corrupted database
Exception in thread "main" java.lang.ArrayIndexOutOfBoundsException: Index -641 out of
unread,
Error when recovering a corrupted database
Exception in thread "main" java.lang.ArrayIndexOutOfBoundsException: Index -641 out of
Apr 8
Hedley Proctor
, …
Evgenij Ryazanov
4
Mar 28
Problems with DATEADD, DATEDIFF and daylight savings time
Hello! I have tests that use a H2 db, and the data set is populated with timestamps relative to the
unread,
Problems with DATEADD, DATEDIFF and daylight savings time
Hello! I have tests that use a H2 db, and the data set is populated with timestamps relative to the
Mar 28
ELIELDO MARTINS
,
Evgenij Ryazanov
5
Mar 27
Cannot find symbol NUMERIC
The tip works exactly !!! Thanks for your attention. Em sex., 24 de mar. de 2023 às 22:45, Evgenij
unread,
Cannot find symbol NUMERIC
The tip works exactly !!! Thanks for your attention. Em sex., 24 de mar. de 2023 às 22:45, Evgenij
Mar 27
Francesco Nigro
Mar 17
Limit the row list allocation based on the row count
Hi all, Persistent flavour of database isn't limiting the array list of rows based on the row
unread,
Limit the row list allocation based on the row count
Hi all, Persistent flavour of database isn't limiting the array list of rows based on the row
Mar 17
Michael Earl
,
Andrei Tokar
4
Mar 16
Blocking locks on: org.h2.mvstore.cache.CacheLongKeyLIRS$Segment.get
Closing this...I think I found the issue...thanks for your time. On Thursday, March 16, 2023 at 6:44:
unread,
Blocking locks on: org.h2.mvstore.cache.CacheLongKeyLIRS$Segment.get
Closing this...I think I found the issue...thanks for your time. On Thursday, March 16, 2023 at 6:44:
Mar 16
Nazar Viliura
,
Evgenij Ryazanov
8
Mar 14
Timestamp's value is different in different time zones
This is *.h2.db file( So, the issue is solved: PageStore backend cannot read persisted timestamps
unread,
Timestamp's value is different in different time zones
This is *.h2.db file( So, the issue is solved: PageStore backend cannot read persisted timestamps
Mar 14
Ted Yu
,
Evgenij Ryazanov
2
Mar 14
Unique index or primary key violation
Hi! It doesn't look like an original error from H2, H2 produces messages like Unique index or
unread,
Unique index or primary key violation
Hi! It doesn't look like an original error from H2, H2 produces messages like Unique index or
Mar 14
Bogdan Zamfir
,
Marcin Wisnicki
3
Mar 14
Contribution statement
This statement is in relation to https://github.com/h2database/h2database/pull/3753 and any other
unread,
Contribution statement
This statement is in relation to https://github.com/h2database/h2database/pull/3753 and any other
Mar 14
Hemant Kumar
Feb 25
Migrating from 1.4.200 to 2.1.214
Hello We use H2 in our test framework and PG in production. I am trying to migrate from 1.4.200 to
unread,
Migrating from 1.4.200 to 2.1.214
Hello We use H2 in our test framework and PG in production. I am trying to migrate from 1.4.200 to
Feb 25
Richard Tan
Feb 23
H2 1.4.200 - Unable to Recover 90030 File corrupted while reading record
Hi all. Version 1.4.200 We had an issue with our database where the database got corrupted. If you
unread,
H2 1.4.200 - Unable to Recover 90030 File corrupted while reading record
Hi all. Version 1.4.200 We had an issue with our database where the database got corrupted. If you
Feb 23
Dhanasekar Rengasamy
,
Evgenij Ryazanov
4
Feb 22
"SELECT .. WHERE ... IN ... OR ... IN" on large tables
Thanks @Evgenij for the suggestion.. Will try the same. Regards, RDS On Friday, 17 February 2023 at
unread,
"SELECT .. WHERE ... IN ... OR ... IN" on large tables
Thanks @Evgenij for the suggestion.. Will try the same. Regards, RDS On Friday, 17 February 2023 at
Feb 22
Kris
,
Evgenij Ryazanov
3
Feb 21
Problem updating from 1.4.199 to 2.1.214
I was able to update to Spring 2.7.8 which mvn dependency:tree shows as using hibernate 5.6.14.Final.
unread,
Problem updating from 1.4.199 to 2.1.214
I was able to update to Spring 2.7.8 which mvn dependency:tree shows as using hibernate 5.6.14.Final.
Feb 21
sidhesh gawas
,
Evgenij Ryazanov
2
Feb 13
Index not found error while using index hints
Hi! I think there are only two possible reasons for that failure. 1. Index belongs to another table (
unread,
Index not found error while using index hints
Hi! I think there are only two possible reasons for that failure. 1. Index belongs to another table (
Feb 13
Jim Foster
, …
Evgenij Ryazanov
4
Feb 13
Asking for help
Hello! In H2 2.1.210 an old bug with incorrectly parsed join conditions was fixed. In earlier version
unread,
Asking for help
Hello! In H2 2.1.210 an old bug with incorrectly parsed join conditions was fixed. In earlier version
Feb 13
Silvio
,
Evgenij Ryazanov
3
Feb 3
Error converting value
Thanks Evgenij, That is clear enough. Intuitively I would have expected a conversion to the column
unread,
Error converting value
Thanks Evgenij, That is clear enough. Intuitively I would have expected a conversion to the column
Feb 3