Search

Clear search

Close search

Main menu

Google apps

H2 Database

1–30 of 6709

This is the mailing list of the H2 database engine.

0 selected

Apr 15

Anyone have suggestions?

Anyone have suggestions? In an environment with approximately 1000 databases ( .mw.db ) and around

unread,

Anyone have suggestions?

Anyone have suggestions? In an environment with approximately 1000 databases ( .mw.db ) and around

Apr 15

Gino Marckx, Evgenij Ryazanov3

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 Reichel3

Apr 2

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 2

Roberto La Rosa, Evgenij Ryazanov2

Mar 27

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 27

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 Ryazanov3

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 Reichel6

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

Martin Changer, … MartinSt7

Mar 20

ETA for next Release?

also interested in ETA Mario Ackerl schrieb am Freitag, 28. Februar 2025 um 11:44:37 UTC+1: +1 from

unread,

ETA for next Release?

also interested in ETA Mario Ackerl schrieb am Freitag, 28. Februar 2025 um 11:44:37 UTC+1: +1 from

Mar 20

Noel Grandin, … who...@gmail.com3

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

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 Ryazanov5

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, Noel Grandin2

Jan 24

H2 Architecture

It is already structured this way, you can use the MVStore layer independently on the SQL layer On

unread,

H2 Architecture

It is already structured this way, you can use the MVStore layer independently on the SQL layer On

Jan 24

Mike Goodwin, Evgenij Ryazanov2

Jan 24

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 24

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 Grandin6

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 Ryazanov7

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 Reichel2

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

Sarat Vemuri, Evgenij Ryazanov3

12/15/24

Materialized View

Hello!!!! Thank you very much. I will try this out and post the results. Thanks, Sarat Vemuri. On

unread,

Materialized View

Hello!!!! Thank you very much. I will try this out and post the results. Thanks, Sarat Vemuri. On

12/15/24

Paulo Dias, … Christian Buchegger3

12/10/24

Use at least Java 11. Looks you are still using Java 8 https://javaalmanac.io/bytecode/versions/

unread,

Use at least Java 11. Looks you are still using Java 8 https://javaalmanac.io/bytecode/versions/

12/10/24

Gururaja shreshti, witerat2

12/7/24

i am getting a null in all the records of the h2 database ...how to fix the problem

How is the table populated? On Friday, 6 December 2024 at 23:31:26 UTC+13 Gururaja shreshti wrote:

unread,

i am getting a null in all the records of the h2 database ...how to fix the problem

How is the table populated? On Friday, 6 December 2024 at 23:31:26 UTC+13 Gururaja shreshti wrote:

12/7/24

Enno Thieleke, … Noel Grandin13

12/2/24

Implement restore points (vaguely similar to Oracle)

Hi, I've put some more work into this feature request and wanted to end this thread here in favor

unread,

Implement restore points (vaguely similar to Oracle)

Hi, I've put some more work into this feature request and wanted to end this thread here in favor

12/2/24

Christopher Espinal, t6032

11/22/24

What is latest Stable release

Hello Christopher, I do not know, why http://www.h2gis.org/ is not updated, but AFAIK H2GIS is

unread,

What is latest Stable release

Hello Christopher, I do not know, why http://www.h2gis.org/ is not updated, but AFAIK H2GIS is

11/22/24

Balamurali Krishna Ippili, Andreas Reichel5

11/20/24

H2 DB 2.2.224 is crashing intermittently

Hi Andreas, Thanks for your reply and I really appreciate it. Sure I will try to upgrade to the

unread,

H2 DB 2.2.224 is crashing intermittently

Hi Andreas, Thanks for your reply and I really appreciate it. Sure I will try to upgrade to the

11/20/24

Olaf Brenn, Andrei Tokar3

11/6/24

H2 Server Performance

Thanks, we found out, that using and increasing batch mode is improving the issue. Andrei Tokar

unread,

H2 Server Performance

Thanks, we found out, that using and increasing batch mode is improving the issue. Andrei Tokar

11/6/24

9/25/24

Prepared Statement trigger which translates from another database SQL synthesis to H2 SQL synthesis.

There is no embedding of the Postgres database for testing. The H2 database helps a lot and makes it

unread,

Prepared Statement trigger which translates from another database SQL synthesis to H2 SQL synthesis.

There is no embedding of the Postgres database for testing. The H2 database helps a lot and makes it

9/25/24

9/15/24

Limit size of temporary files

Hi, Is there a way to limit the size of the temporary files the database is using ? This just to

unread,

Limit size of temporary files

Hi, Is there a way to limit the size of the temporary files the database is using ? This just to

9/15/24

prachi sugdare, Alex Tsvetkov4

8/31/24

h2 database version 1.4.200 is corrupted with error code: 90030

Did you try not to use not supported "-out" argument? пн, 26 авг. 2024 г. в 10:55, prachi

unread,

h2 database version 1.4.200 is corrupted with error code: 90030

Did you try not to use not supported "-out" argument? пн, 26 авг. 2024 г. в 10:55, prachi

8/31/24

Matt Hicks, Noel Grandin2

8/29/24

Persistence Issues w/ Auto-Commit = false

On 8/28/2024 10:38 PM, Matt Hicks wrote: > I'm sharing a single Connection to a file instance

unread,

Persistence Issues w/ Auto-Commit = false

On 8/28/2024 10:38 PM, Matt Hicks wrote: > I'm sharing a single Connection to a file instance

8/29/24

村林良胤, Andreas Reichel2

8/16/24

On Thu, 2024-08-15 at 22:53 -0700, 村林良胤 wrote: My name is Murabayashi. I wish to record the following

unread,

On Thu, 2024-08-15 at 22:53 -0700, 村林良胤 wrote: My name is Murabayashi. I wish to record the following

8/16/24

Alex Tsvetkov, Evgenij Ryazanov4

8/12/24

error wile building master branch

I think I measured performance of new generator incorrectly and on really fast CPUs two sequential

unread,

error wile building master branch

I think I measured performance of new generator incorrectly and on really fast CPUs two sequential

8/12/24