H2 Database

1–30 of 6536

This is the mailing list of the H2 database engine.

0 selected

Sandro Mosdzinski

Nov 29

How to modify SELECT LOB_TIMEOUT

The default value of SELECT LOB_TIMEOUT is 30000. I want to increase the timeout. Does anyone know

unread,

How to modify SELECT LOB_TIMEOUT

The default value of SELECT LOB_TIMEOUT is 30000. I want to increase the timeout. Does anyone know

Nov 29

Vojtěch Jaroš, Noel Grandin4

Nov 21

DELETE statement causes the database to multiply in size and stuck.

HI There probably is something wrong with our execution of that query, but I'm afraid it's

unread,

DELETE statement causes the database to multiply in size and stuck.

HI There probably is something wrong with our execution of that query, but I'm afraid it's

Nov 21

Nov 16

Configuration file not created if default port is not available

I have installed H2 ver. 1.4.196 and started H2 Console and got Error 404: Not found in the browser.

unread,

Configuration file not created if default port is not available

I have installed H2 ver. 1.4.196 and started H2 Console and got Error 404: Not found in the browser.

Nov 16

Silvio, Noel Grandin4

Nov 8

Question about JDBC prepared statements in H2

On 11/7/2022 4:59 PM, Silvio wrote: > > I was hoping for perhaps some speedup if the query

unread,

Question about JDBC prepared statements in H2

On 11/7/2022 4:59 PM, Silvio wrote: > > I was hoping for perhaps some speedup if the query

Nov 8

Heiko Sasse, … Andrei Tokar3

Nov 2

Wrong Discription on Download for Distribution "1.4.202"

It was already fixed in the repository, just never made it to the actual site. Uploaded now. Thanks

unread,

Wrong Discription on Download for Distribution "1.4.202"

It was already fixed in the repository, just never made it to the actual site. Uploaded now. Thanks

Nov 2

Mark Raynsford, … Ritu Jain6

Oct 30

How are "multiple rows" represented in MVStore?

Hi I am using h2 database with mode as oracle , so need to define create alias for Oracle function

unread,

How are "multiple rows" represented in MVStore?

Hi I am using h2 database with mode as oracle , so need to define create alias for Oracle function

Oct 30

Shubham kapoor2

Oct 26

General error: "Chunk 849734 not found [2.1.212/9]

Hi, I guess many of us have faced this issue, but no one has replied to it yet. Can anyone please

unread,

General error: "Chunk 849734 not found [2.1.212/9]

Hi, I guess many of us have faced this issue, but no one has replied to it yet. Can anyone please

Oct 26

Ananda Bose, jto...@colegiosperuanos.edu.pe2

Oct 25

Keycloak H2 database migration to RDS Posgtres RDS

ETL El martes, 13 de septiembre de 2022 a las 4:52:39 UTC-5, boseana...@gmail.com escribió: Hello , I

unread,

Keycloak H2 database migration to RDS Posgtres RDS

ETL El martes, 13 de septiembre de 2022 a las 4:52:39 UTC-5, boseana...@gmail.com escribió: Hello , I

Oct 25

akash verma, Christian Buchegger2

Oct 23

Want to get the metadata of h2 database .

https://www.h2database.com/html/systemtables.html

unread,

Want to get the metadata of h2 database .

https://www.h2database.com/html/systemtables.html

Oct 23

Kevin O'Neal, Ritu Jain4

Oct 23

Oracle EMPTY_BLOB()

Hey Kevin I am not able to see H2 console while executing my application Can you suggest any property

unread,

Oracle EMPTY_BLOB()

Hey Kevin I am not able to see H2 console while executing my application Can you suggest any property

Oct 23

Oct 19

Trouble with H2 Web Console

I have a springboot app, and I'm using an embedded h2 database 1.4.200. I can access the h2 web

unread,

Trouble with H2 Web Console

I have a springboot app, and I'm using an embedded h2 database 1.4.200. I can access the h2 web

Oct 19

Eric Faulhaber2

Oct 18

Expert assistance addressing performance issues

Sorry, didn't realize my email address would not post: ecf@goldencode.com Thanks, Eric On 10/18/

unread,

Expert assistance addressing performance issues

Sorry, didn't realize my email address would not post: ecf@goldencode.com Thanks, Eric On 10/18/

Oct 18

Gerhard Duennebeil, … Noel Grandin7

Oct 14

Problems with linked table

On 10/14/2022 9:28 AM, Gerhard Duennebeil wrote: > > Maybe it's a bit naive, but wouldn

unread,

Problems with linked table

On 10/14/2022 9:28 AM, Gerhard Duennebeil wrote: > > Maybe it's a bit naive, but wouldn

Oct 14

sravan dyapa, Evgenij Ryazanov2

Oct 14

ERROR SqlExceptionHelper: Unknown data type: "unsigned"

Hello. CAST in MySQL and its forks is not compliant with cast specification from the SQL Standard and

unread,

ERROR SqlExceptionHelper: Unknown data type: "unsigned"

Hello. CAST in MySQL and its forks is not compliant with cast specification from the SQL Standard and

Oct 14

Emmanuel Callado, Noel Grandin2

Oct 13

Encountered a org.h2.jdbc.JdbcSQLException: IO Exception: null [90028-190] while accessing the database

You can try the recovery tool, but there are no guarantees, sometimes you get lucky, sometimes not.

unread,

Encountered a org.h2.jdbc.JdbcSQLException: IO Exception: null [90028-190] while accessing the database

You can try the recovery tool, but there are no guarantees, sometimes you get lucky, sometimes not.

Oct 13

Ritu Jain, Noel Grandin2

Oct 13

data conversion issues

That's not enough information to make a proper diagnosis, but at a guess I would say that you are

unread,

data conversion issues

That's not enough information to make a proper diagnosis, but at a guess I would say that you are

Oct 13

Harrison Kaiser, Noel Grandin2

Oct 13

Adding New Data Types in H2 Open Source Code

The relevant classes are called things like Value* - ValueString, ValueDecimal, etc. So you'd

unread,

Adding New Data Types in H2 Open Source Code

The relevant classes are called things like Value* - ValueString, ValueDecimal, etc. So you'd

Oct 13

Salvatore Coppola

Oct 13

Next release date

Hi, is there an expected date for the next h2 release? Thanks. Salvatore

unread,

Next release date

Hi, is there an expected date for the next h2 release? Thanks. Salvatore

Oct 13

Oct 9

ChangeFileEncryption.execute fails with proper password?

resolved. On Saturday, October 8, 2022 at 1:32:12 PM UTC-6 Daniel Hopins wrote: I can't figure

unread,

ChangeFileEncryption.execute fails with proper password?

resolved. On Saturday, October 8, 2022 at 1:32:12 PM UTC-6 Daniel Hopins wrote: I can't figure

Oct 9

Nikita Salomatin

Oct 8

Legal note for the pull request 3639

Hi, This is the legal note for the pull requests https://github.com/h2database/h2database/pull/3639 :

unread,

Legal note for the pull request 3639

Hi, This is the legal note for the pull requests https://github.com/h2database/h2database/pull/3639 :

Oct 8

nicolas duminil, … Evgenij Ryazanov5

Oct 3

Can't insert SHA3-256 from runscript

H2 1.4.200 supports only SHA-256 and it needs to be specified as SHA256 (without dash) in this

unread,

Can't insert SHA3-256 from runscript

H2 1.4.200 supports only SHA-256 and it needs to be specified as SHA256 (without dash) in this

Oct 3

Ananda Bose, Christian Buchegger2

Oct 2

Table check of H2 database in Keycloak

Hi, I just coincidentally came accross this link: https://www.thrysoee.dk/keycloak-h2/ The classpath

unread,

Table check of H2 database in Keycloak

Hi, I just coincidentally came accross this link: https://www.thrysoee.dk/keycloak-h2/ The classpath

Oct 2

Silvio, … Evgenij Ryazanov7

Sep 30

JDBC getIndexInfo for large table is very slow

Right! Thanks Evgenij, I will change that immediately. Thanks again guys. On Friday, 30 September

unread,

JDBC getIndexInfo for large table is very slow

Right! Thanks Evgenij, I will change that immediately. Thanks again guys. On Friday, 30 September

Sep 30

Sep 28

Hi, Can I pivot the table in h2?

unread,

Hi, Can I pivot the table in h2?

Sep 28

Sudeep C, Evgenij Ryazanov3

Sep 26

Help needed for COLUMN option in SCRIPT

Is there any other option to retrieve the INSERT statement with column names using the above tool? On

unread,

Help needed for COLUMN option in SCRIPT

Is there any other option to retrieve the INSERT statement with column names using the above tool? On

Sep 26

Bruno Santos Silva, … Sudeep C3

Sep 26

PREPAREDSTATMENT - SCRIPT COLUMNS HELP

To get insert statement like INSERT INTO TBL (A, B, C) VALUES (1, 2, 3), what command I have to use?

unread,

PREPAREDSTATMENT - SCRIPT COLUMNS HELP

To get insert statement like INSERT INTO TBL (A, B, C) VALUES (1, 2, 3), what command I have to use?

Sep 26

Indrek Võitra, … Indrek Võitra3

Sep 14

Cant get VARCHAR column to maximum size

Thanks a lot! I had 2.1.210. On Tuesday, September 13, 2022 at 2:56:01 PM UTC+3 Evgenij Ryazanov

unread,

Cant get VARCHAR column to maximum size

Thanks a lot! I had 2.1.210. On Tuesday, September 13, 2022 at 2:56:01 PM UTC+3 Evgenij Ryazanov

Sep 14

prrvchr, Evgenij Ryazanov3

Sep 5

SELECT command that returns a strange RESULSET

Newbie mistake, thank you Evgenij Ryazanov,, it took me a while to find the malfunction now I

unread,

SELECT command that returns a strange RESULSET

Newbie mistake, thank you Evgenij Ryazanov,, it took me a while to find the malfunction now I

Sep 5

prrvchr, … Evgenij Ryazanov12

Sep 5

Management of users, roles and privileges in LibreOffice Base

> Can you confirm that the names of users and roles only support uppercase characters without

unread,

Management of users, roles and privileges in LibreOffice Base

> Can you confirm that the names of users and roles only support uppercase characters without

Sep 5

Yosei Ito, Evgenij Ryazanov3

Sep 1

Database hangs when the query contains multibyte space.

Thank you so much for the quick fix..! (because it's not so urgent for us) we look forward to the

unread,

Database hangs when the query contains multibyte space.

Thank you so much for the quick fix..! (because it's not so urgent for us) we look forward to the

Sep 1

Search

Clear search

Close search

Google apps

Main menu