H2 Database

1–30 of 6361

This is the mailing list of the H2 database engine.

0 selected

Apr 14

Contribution request for PR #3087

I wrote the code, it's mine, and I'm contributing it to H2 for distribution multiple-licensed

unread,

Contribution request for PR #3087

I wrote the code, it's mine, and I'm contributing it to H2 for distribution multiple-licensed

Apr 14

Илья Ненашев, Evgenij Ryazanov5

Apr 5

What about add support of COMMENT for table to CREATE TABLE statement?

It's looks designed good enough, and it will not dramatically changed if it will be documented.

unread,

What about add support of COMMENT for table to CREATE TABLE statement?

It's looks designed good enough, and it will not dramatically changed if it will be documented.

Apr 5

Apr 3

Coding a V1 of an in-memory relational database

Hello, I am trying to code up an in-memory RDBMS in java with a basic set of entities such as

unread,

Coding a V1 of an in-memory relational database

Hello, I am trying to code up an in-memory RDBMS in java with a basic set of entities such as

Apr 3

Mar 26

MAX_LENGTH_INPLACE_LOB and StreamStore.minBlockSize

Hi, What's the relationship between MAX_LENGTH_INPLACE_LOB and StreamStore.minBlockSize (

unread,

MAX_LENGTH_INPLACE_LOB and StreamStore.minBlockSize

Hi, What's the relationship between MAX_LENGTH_INPLACE_LOB and StreamStore.minBlockSize (

Mar 26

Виталий Пунько, Andreas Reichel4

Mar 24

Don't get AVG(DareDiff) field in java and H2

Now everything is okey. I should added alies for AVG function. :( вторник, 23 марта 2021 г. в 13:48:

unread,

Don't get AVG(DareDiff) field in java and H2

Now everything is okey. I should added alies for AVG function. :( вторник, 23 марта 2021 г. в 13:48:

Mar 24

mrbr...@gmail.com, … andreas4

Mar 23

Best Practice using H2

Mike. For our own software we test if the h2 port is open. If not we start the h2 server per java api

unread,

Best Practice using H2

Mike. For our own software we test if the h2 port is open. If not we start the h2 server per java api

Mar 23

Balamurali Krishna Ippili, Evgenij Ryazanov3

Mar 23

Getting error after upgrading to H2 DB 1.4.200 from 1.4.199 and deploying on Tomcat 9.x

Hello. Your application shouldn't normally start TCP server of H2. If you need it, it should be

unread,

Getting error after upgrading to H2 DB 1.4.200 from 1.4.199 and deploying on Tomcat 9.x

Hello. Your application shouldn't normally start TCP server of H2. If you need it, it should be

Mar 23

Mar 19

Contribution statement

Please see below a contribution statement for the patch provided to resolve the issue: https://github

unread,

Contribution statement

Please see below a contribution statement for the patch provided to resolve the issue: https://github

Mar 19

mk, … ciphe...@gmail.com13

Mar 19

H2 DB Corruption: java.lang.IllegalStateException: Chunk 1936 not found [1.4.200/9]

Thank you for the useful discussion. :) Sorry for my long absence, I was not able to find the bug

unread,

H2 DB Corruption: java.lang.IllegalStateException: Chunk 1936 not found [1.4.200/9]

Thank you for the useful discussion. :) Sorry for my long absence, I was not able to find the bug

Mar 19

Sofiane CHELABI, … Artsiom Miklushou4

Mar 18

release date : 1.4.201 version

Hello, Also waiting for #2786 fix. Maybe there are some updates regarding this? Thank you! On Monday,

unread,

release date : 1.4.201 version

Hello, Also waiting for #2786 fix. Maybe there are some updates regarding this? Thank you! On Monday,

Mar 18

lefteris skountis, Jason Pyeron2

Mar 14

Contribution Request

Did you review https://github.com/h2database/h2database/issues ? From: h2-database@googlegroups.com [

unread,

Contribution Request

Did you review https://github.com/h2database/h2database/issues ? From: h2-database@googlegroups.com [

Mar 14

t603, … Jason Pyeron12

Mar 11

RFE: Enable Common Table Expression (CTE with...) in INSERT, UPDATE, DELETE, CREATE TABLE AS, CREATE VIEW AS

Thanks, I was able to find a work around and more clearly identify my issue. https://github.com/

unread,

RFE: Enable Common Table Expression (CTE with...) in INSERT, UPDATE, DELETE, CREATE TABLE AS, CREATE VIEW AS

Thanks, I was able to find a work around and more clearly identify my issue. https://github.com/

Mar 11

Knut Saua Mathiesen, Evgenij Ryazanov3

Mar 3

Isolation level per connection or global?

> H2 with default MVStore engine supports different isolation levels only since the version 1.4.

unread,

Isolation level per connection or global?

> H2 with default MVStore engine supports different isolation levels only since the version 1.4.

Mar 3

anmold...@gmail.com, Evgenij Ryazanov2

Mar 3

H2 / TCP over SSL setting truststore system property alternatve

Hello. H2 has anonymous SSL, but it works only with outdated JREs.

unread,

H2 / TCP over SSL setting truststore system property alternatve

Hello. H2 has anonymous SSL, but it works only with outdated JREs.

Mar 3

Thomas Frick, Andreas Reichel3

Mar 3

How can I repair database with error "#Row {1} not found in primary index "PUBLIC.SYS_DATA: 1570" [90143-196]"?

Hi Andreas, it worked perfectly for me!! :-) I was able to rescue every data-byte out of the damaged

unread,

How can I repair database with error "#Row {1} not found in primary index "PUBLIC.SYS_DATA: 1570" [90143-196]"?

Hi Andreas, it worked perfectly for me!! :-) I was able to rescue every data-byte out of the damaged

Mar 3

jackp...@gmail.com, Evgenij Ryazanov4

Mar 1

Table not found after ALTER table - leftover "_COPY_" table

Hi, just wondered if there were any more thoughts? On Thursday, 4 February 2021 at 16:04:58 UTC jackp

unread,

Table not found after ALTER table - leftover "_COPY_" table

Hi, just wondered if there were any more thoughts? On Thursday, 4 February 2021 at 16:04:58 UTC jackp

Mar 1

Evgenij Ryazanov, Andreas Reichel4

Feb 21

For everyone who use snapshot builds of upcoming H2 2.0

Dear All, we have implemented support for H2 Driver Version Snapshots, based on GIT IDs. This way,

unread,

For everyone who use snapshot builds of upcoming H2 2.0

Dear All, we have implemented support for H2 Driver Version Snapshots, based on GIT IDs. This way,

Feb 21

Thamindu Jayawickrama, Andrei Tokar2

Feb 21

Locking in Pagestore Engine Indices

Please note, that PageStore is not in active development any more. H2 currently uses MVStore as

unread,

Locking in Pagestore Engine Indices

Please note, that PageStore is not in active development any more. H2 currently uses MVStore as

Feb 21

js, Andrei Tokar2

Feb 21

Concurent B+tree indexing in H2 Database

Hi JS, First of all, there are two storage implementations co-exist in H2, old "PageStore"

unread,

Concurent B+tree indexing in H2 Database

Hi JS, First of all, there are two storage implementations co-exist in H2, old "PageStore"

Feb 21

Rafael Barbaresco, … Noel Grandin5

Feb 19

PostgreSQL range type and functions

On 2021/02/19 9:27 am, Evgenij Ryazanov wrote: > New data types will definitely require massive

unread,

PostgreSQL range type and functions

On 2021/02/19 9:27 am, Evgenij Ryazanov wrote: > New data types will definitely require massive

Feb 19

impradee, … Noel Grandin8

Feb 16

Nested loop join implementation

Hi Noel Grandin, Thank You very much for the reply. On Tuesday, February 16, 2021 at 6:39:19 PM UTC+5

unread,

Nested loop join implementation

Hi Noel Grandin, Thank You very much for the reply. On Tuesday, February 16, 2021 at 6:39:19 PM UTC+5

Feb 16

Andreas Reichel2

Feb 12

Automatic H2 Migration tool, first release for testing

Dear All, we have a functional UI. H2 DB files can be added by pointing on folders, which will be

unread,

Automatic H2 Migration tool, first release for testing

Dear All, we have a functional UI. H2 DB files can be added by pointing on folders, which will be

Feb 12

Quy Nguyen, Andreas Reichel2

Feb 11

Debugging large database file

Good Morning Quy, unfortunately I have observed similar problems in the past: https://github.com/

unread,

Debugging large database file

Good Morning Quy, unfortunately I have observed similar problems in the past: https://github.com/

Feb 11

Gauri Shree, Evgenij Ryazanov2

Feb 4

Number Format exception for search by uuid column, when uuid value is fetched from another table uuid column..

Hello. Your issue is not related with H2 in any way. Your application tries to read an UUID value

unread,

Number Format exception for search by uuid column, when uuid value is fetched from another table uuid column..

Hello. Your issue is not related with H2 in any way. Your application tries to read an UUID value

Feb 4

Venkat Pedapati, Evgenij Ryazanov4

Jan 29

MAX function does not return updated value until commit in SERIALIZABLE isolation level

If you can reproduce this bug with H2 compiled from the current sources, please provide a complete

unread,

MAX function does not return updated value until commit in SERIALIZABLE isolation level

If you can reproduce this bug with H2 compiled from the current sources, please provide a complete

Jan 29

Caltinor, Noel Grandin4

Jan 21

Odd UUID to BOOLEAN conversion error

I wanted to follow up on this. I did resolve the issue though the problem was entirely caused by a

unread,

Odd UUID to BOOLEAN conversion error

I wanted to follow up on this. I did resolve the issue though the problem was entirely caused by a

Jan 21

Pylou Ej, Evgenij Ryazanov6

Jan 19

Name for Constraint Unique

On Tuesday, 19 January 2021 at 21:34:58 UTC+8 pylo...@gmail.com wrote: I need to put a single value

unread,

Name for Constraint Unique

On Tuesday, 19 January 2021 at 21:34:58 UTC+8 pylo...@gmail.com wrote: I need to put a single value

Jan 19

Jan 19

ALTER CONSTRAINT UNIQUE

Close. Le mardi 19 janvier 2021 à 13:17:43 UTC+1, Pylou Ej a écrit : Hello I want to add a constraint

unread,

ALTER CONSTRAINT UNIQUE

Close. Le mardi 19 janvier 2021 à 13:17:43 UTC+1, Pylou Ej a écrit : Hello I want to add a constraint

Jan 19

Jan 15

License Agreement for PR #3001

I wrote the code, it's mine, and I'm contributing it to H2 for distribution multiple-licensed

unread,

License Agreement for PR #3001

I wrote the code, it's mine, and I'm contributing it to H2 for distribution multiple-licensed

Jan 15

John Arkley, Evgenij Ryazanov2

Jan 8

what does the H2 Console Auto Select [ On/Off ] control do??

Hello. Run Selected button or Shift+Enter key combination runs the selected code only. When selection

unread,

what does the H2 Console Auto Select [ On/Off ] control do??

Hello. Run Selected button or Shift+Enter key combination runs the selected code only. When selection

Jan 8

Search

Clear search

Close search

Google apps

Main menu