H2 Database

1–30 of 6443

This is the mailing list of the H2 database engine.

0 selected

3:17 AM

Using field value as part of expression??

Suppose the field 'Abbr' does contain the value "ABC" and here is also a field with

unread,

Using field value as part of expression??

Suppose the field 'Abbr' does contain the value "ABC" and here is also a field with

3:17 AM

Silvio, Evgenij Ryazanov3

Jan 20

H2 2.1.210 SQL output of SCRIPT not backward compatible with 1.4.200

Thank you. I already expected that. I did not seek full backward compatibility but since we use the

unread,

H2 2.1.210 SQL output of SCRIPT not backward compatible with 1.4.200

Thank you. I already expected that. I did not seek full backward compatibility but since we use the

Jan 20

Chin Wei Low, Andrei Tokar2

Jan 18

2.0.206 Memory leak when AUTO_COMPACT_FILL_RATE=0 and REUSE_SPACE=false

This is exactly behaviour, I would expect, if you explicitely disable any space reuse. I wonder what

unread,

2.0.206 Memory leak when AUTO_COMPACT_FILL_RATE=0 and REUSE_SPACE=false

This is exactly behaviour, I would expect, if you explicitely disable any space reuse. I wonder what

Jan 18

Bluewhale1502, Evgenij Ryazanov7

Jan 18

H2 usage in test scope: v2.0.x not compatible to JPA autogenerated database modell

Meanwhile v2.1.210 is available on maven central now. I can also confirm that the fix solved my issue

unread,

H2 usage in test scope: v2.0.x not compatible to JPA autogenerated database modell

Meanwhile v2.1.210 is available on maven central now. I can also confirm that the fix solved my issue

Jan 18

Jan 17

H2 Database Engine: New version 2.1.210 released

Hello, A new version 2.1.210 of H2 is available at http://www.h2database.com (you may have to click

unread,

H2 Database Engine: New version 2.1.210 released

Hello, A new version 2.1.210 of H2 is available at http://www.h2database.com (you may have to click

Jan 17

Christoffer Bruun, Marcello Rinaldo Martina2

Jan 17

H2 2.0.202 Upgrade experience (keywords as colunm names, large varchar requires clob)

Hi, I'm pushing to update this page https://h2database.com/html/migration-to-v2.html that

unread,

H2 2.0.202 Upgrade experience (keywords as colunm names, large varchar requires clob)

Hi, I'm pushing to update this page https://h2database.com/html/migration-to-v2.html that

Jan 17

pieter...@gmail.com, Marcello Rinaldo Martina3

Jan 17

upgrade to 2.0.202 ARRAY issue

Hi, I'm pushing to update this page https://h2database.com/html/migration-to-v2.html that

unread,

upgrade to 2.0.202 ARRAY issue

Hi, I'm pushing to update this page https://h2database.com/html/migration-to-v2.html that

Jan 17

jeremie...@gmail.com, Marcello Rinaldo Martina2

Jan 17

Regression with H2 v2.0.206

Hi, I am not able to respond to your questions, but I'm pushing to update this page https://

unread,

Regression with H2 v2.0.206

Hi, I am not able to respond to your questions, but I'm pushing to update this page https://

Jan 17

Jan 16

2.0.206 Memory Leak when AUTO_COMPACT_FILL_RATE=0 and REUSE_SPACE=false

Hi, I have a long running process that open a H2 db with AUTO_COMPACT_FILL_RATE=0 and REUSE_SPACE=

unread,

2.0.206 Memory Leak when AUTO_COMPACT_FILL_RATE=0 and REUSE_SPACE=false

Hi, I have a long running process that open a H2 db with AUTO_COMPACT_FILL_RATE=0 and REUSE_SPACE=

Jan 16

Ulrich, … Pierre Caron7

Jan 14

2.0.202 and hibernate: boolean field regression?

To everyone facing the Values of types "BOOLEAN" and "INTEGER" are not comparable

unread,

2.0.202 and hibernate: boolean field regression?

To everyone facing the Values of types "BOOLEAN" and "INTEGER" are not comparable

Jan 14

Pierre Caron, Evgenij Ryazanov4

Jan 13

LIMIT keyword no longer supported

OK, thanks. I succeeded by putting the code in the datasource configuration as explained in https://

unread,

LIMIT keyword no longer supported

OK, thanks. I succeeded by putting the code in the datasource configuration as explained in https://

Jan 13

Yuqiang Fan, Evgenij Ryazanov3

Jan 13

Create alias if not exists threw exception

Thanks a lot, and I will keep your advice in mind. 在2022年1月13日星期四 UTC+8 17:26:15<Evgenij Ryazanov

unread,

Create alias if not exists threw exception

Thanks a lot, and I will keep your advice in mind. 在2022年1月13日星期四 UTC+8 17:26:15<Evgenij Ryazanov

Jan 13

Artem Bilan, Andrei Tokar2

Jan 12

The Parser doubles params for stored procedures in v.2.0.206

This issue and possible workarounds are described here and addressed by this PR. Fix will be included

unread,

The Parser doubles params for stored procedures in v.2.0.206

This issue and possible workarounds are described here and addressed by this PR. Fix will be included

Jan 12

Paul Denby, Henning Pöttker3

Jan 12

H2 v2.0.206 support for NEXTVAL

Many thanks. Will try again when the spring version is available. On Wednesday, 12 January 2022 at 12

unread,

H2 v2.0.206 support for NEXTVAL

Many thanks. Will try again when the spring version is available. On Wednesday, 12 January 2022 at 12

Jan 12

ashi...@gmail.com, … Silvio5

Jan 11

H2DB upgrade from 1.4.195 to 2.0.206 - Breaks - Version mismatch, driver version is "0" but server version is "16"

Thanks. That is just what we need. On Tuesday, 11 January 2022 at 14:19:29 UTC+1 Evgenij Ryazanov

unread,

H2DB upgrade from 1.4.195 to 2.0.206 - Breaks - Version mismatch, driver version is "0" but server version is "16"

Thanks. That is just what we need. On Tuesday, 11 January 2022 at 14:19:29 UTC+1 Evgenij Ryazanov

Jan 11

Marcello Rinaldo Martina, Evgenij Ryazanov5

Jan 11

Possible mitigation for CVE-2021-42392

Thank you very much! Best, Marcello Il giorno martedì 11 gennaio 2022 alle 15:35:31 UTC+1 Evgenij

unread,

Possible mitigation for CVE-2021-42392

Thank you very much! Best, Marcello Il giorno martedì 11 gennaio 2022 alle 15:35:31 UTC+1 Evgenij

Jan 11

Matti Linnanvuori, Evgenij Ryazanov3

Jan 11

The script is like the following. URL="jdbc:h2:/opt/app/var/db/session-db;AUTO_SERVER=TRUE"

unread,

The script is like the following. URL="jdbc:h2:/opt/app/var/db/session-db;AUTO_SERVER=TRUE"

Jan 11

Behrang, … Evgenij Ryazanov4

Jan 10

H2DB breaks GraalVM native image production

Hello! I think you need to force inclusion of org.h2.store.fs.disk.* classes into compiled program

unread,

H2DB breaks GraalVM native image production

Hello! I think you need to force inclusion of org.h2.store.fs.disk.* classes into compiled program

Jan 10

William Lindsay, Evgenij Ryazanov2

Jan 10

SQLWarnings in Profiler

Hello! H2 database doesn't support warnings and cannot produce java.sql.SQLWarning, if you see

unread,

SQLWarnings in Profiler

Hello! H2 database doesn't support warnings and cannot produce java.sql.SQLWarning, if you see

Jan 10

Yuqiang Fan, Evgenij Ryazanov3

Jan 7

usage of "runscript" feature

Thank you fro replying, and it does work that your suggestion on using non_keywords settings, this

unread,

usage of "runscript" feature

Thank you fro replying, and it does work that your suggestion on using non_keywords settings, this

Jan 7

Jan 6

Hi, I am having an error when trying to use a h2 1.4.190 artifact in eclipse for a maven project. I

unread,

Hi, I am having an error when trying to use a h2 1.4.190 artifact in eclipse for a maven project. I

Jan 6

Vladimir Dzhuvinov, … Vladimir Dzhuvinov4

Jan 5

Create table error in 2.x, unsure how to interpret: expected "IDENTITY, BIGSERIAL, SERIAL, data type"

Thanks Andrei. I wasn't aware the "[*]" had that significance. I posted a suggestion in

unread,

Create table error in 2.x, unsure how to interpret: expected "IDENTITY, BIGSERIAL, SERIAL, data type"

Thanks Andrei. I wasn't aware the "[*]" had that significance. I posted a suggestion in

Jan 5

Jan 4

H2 Database Engine: New version released

Hello, A new version 2.0.206 of H2 is available at http://www.h2database.com (you may have to click

unread,

H2 Database Engine: New version released

Hello, A new version 2.0.206 of H2 is available at http://www.h2database.com (you may have to click

Jan 4

Henning Pöttker

Jan 3

License Statement for #3320

Hi, regarding the code pushed as part of https://github.com/h2database/h2database/pull/3320 I wrote

unread,

License Statement for #3320

Hi, regarding the code pushed as part of https://github.com/h2database/h2database/pull/3320 I wrote

Jan 3

kanchan jondhale, Silvio3

Jan 3

Corrupted databases with 1.4.199

Download H2 1.4.196 and try to do a record of the database with that by running java -cp h2-1.4.196.

unread,

Corrupted databases with 1.4.199

Download H2 1.4.196 and try to do a record of the database with that by running java -cp h2-1.4.196.

Jan 3

Oleg Kalnichevski, … Guillaume de GENTILE4

12/30/21

H2 (1.4.200) seems to misinterpret a valid join clause

Hello, It seems that the join conditions are not at the right place: from STUFF S inner join

unread,

H2 (1.4.200) seems to misinterpret a valid join clause

Hello, It seems that the join conditions are not at the right place: from STUFF S inner join

12/30/21

12/29/21

We were doing a security audit and found this vulnerability (https://cve.mitre.org/cgi-bin/cvename.

unread,

We were doing a security audit and found this vulnerability (https://cve.mitre.org/cgi-bin/cvename.

12/29/21

12/29/21

Question about database file versions vs H2 versions

Hello all, I am designing a H2 database version migration mechanism for our application. Since it is

unread,

Question about database file versions vs H2 versions

Hello all, I am designing a H2 database version migration mechanism for our application. Since it is

12/29/21

Rafael Simón Vera Urdaneta, Evgenij Ryazanov2

12/27/21

error version 2.0.204

Hello. H2 2.0 allows up to 1048576 characters for this data type: https://h2database.com/html/

unread,

error version 2.0.204

Hello. H2 2.0 allows up to 1048576 characters for this data type: https://h2database.com/html/

12/27/21

Andrei Tokar, Gary Gregory4

12/23/21

H2 Database Engine: New version released

"KEY" (as well as "VALUE") is a keyword now, and if used as identifier has to be

unread,

H2 Database Engine: New version released

"KEY" (as well as "VALUE") is a keyword now, and if used as identifier has to be

12/23/21

Search

Clear search

Close search

Google apps

Main menu