Groups
Sign in
Groups
H2 Database
Conversations
About
Send feedback
Help
H2 Database
Contact owners and managers
1–30 of 6657
This is the mailing list of the
H2 database engine
.
Mark all as read
Report group
0 selected
prrvchr
2
Apr 18
H2 as an odb in LibreOffice Base
It's done, it's called H2dbOOo and there are two versions: - 1.0.0 for LibreOffice up to 7.x
unread,
H2 as an odb in LibreOffice Base
It's done, it's called H2dbOOo and there are two versions: - 1.0.0 for LibreOffice up to 7.x
Apr 18
Peter Borissow
, …
Evgenij Ryazanov
18
Apr 16
Duplicate records when order by date?
Understood. Thanks!
unread,
Duplicate records when order by date?
Understood. Thanks!
Apr 16
prrvchr
Apr 11
LibreOffice Base is capable of administering H2
Just to inform you that the new version jdbcDriverOOo 1.3.1 is available. It is capable of
unread,
LibreOffice Base is capable of administering H2
Just to inform you that the new version jdbcDriverOOo 1.3.1 is available. It is capable of
Apr 11
prrvchr
, …
Noel Grandin
13
Apr 10
H2 does not use SYSTEM TABLE in table types
If we want to be able to offer users intelligent software, we must find intelligence where it is
unread,
H2 does not use SYSTEM TABLE in table types
If we want to be able to offer users intelligent software, we must find intelligence where it is
Apr 10
prrvchr
,
Evgenij Ryazanov
3
Apr 9
Get user's roles and role's users
Hi, Thank you for this information, it allowed me to integrate the management of roles and rights
unread,
Get user's roles and role's users
Hi, Thank you for this information, it allowed me to integrate the management of roles and rights
Apr 9
broccolai
,
Andreas Reichel
2
Apr 8
working around differences with h2 PSQL compatibilty
Greetings! You could use JSQLParser to parse your query and then transpile/rewrite it into the
unread,
working around differences with h2 PSQL compatibilty
Greetings! You could use JSQLParser to parse your query and then transpile/rewrite it into the
Apr 8
Rinse Lemstra
, …
Noel Grandin
4
Apr 7
how much indexes are used for optimization
Run the EXPLAIN command to see which indexes are used for a specific query
unread,
how much indexes are used for optimization
Run the EXPLAIN command to see which indexes are used for a specific query
Apr 7
Σίντι Βρουσάι
Apr 5
Looking for a contribution to h2database
Hello, I'm a university student and i have to contribute to an oss as an assignment for a course
unread,
Looking for a contribution to h2database
Hello, I'm a university student and i have to contribute to an oss as an assignment for a course
Apr 5
Martin Lichtin
,
Evgenij Ryazanov
2
Apr 4
java.lang.NoClassDefFoundError: org/h2/command/dml/SetClauseList
Hello! Make sure you have only one version of H2 in classpath of your application. If you have a
unread,
java.lang.NoClassDefFoundError: org/h2/command/dml/SetClauseList
Hello! Make sure you have only one version of H2 in classpath of your application. If you have a
Apr 4
Balamurali Krishna Ippili
,
Evgenij Ryazanov
9
Apr 2
Auto Increment statement is giving an error when passing null with H2DB 2.2.224 version
Hi Evgenij, Thank you so much for your response. Sure , I will check the feasibility in our
unread,
Auto Increment statement is giving an error when passing null with H2DB 2.2.224 version
Hi Evgenij, Thank you so much for your response. Sure , I will check the feasibility in our
Apr 2
Paulo Destro
, …
Paulo Destro
3
Mar 28
Updating a current column with an old column using triggers without exception StackOverflowError
0 You must write your trigger with AFTER SQL statement CREATE TRIGGER update_timestamp_trigger AFTER
unread,
Updating a current column with an old column using triggers without exception StackOverflowError
0 You must write your trigger with AFTER SQL statement CREATE TRIGGER update_timestamp_trigger AFTER
Mar 28
Njabulo Nyambose
Mar 23
H2 version upgrade from 1.3.* to 2.2.* missing H2 JDBC Driver.
Greetings. 👋 [technical debt] I needed H2 version upgrade to address security vulnerabilities in
unread,
H2 version upgrade from 1.3.* to 2.2.* missing H2 JDBC Driver.
Greetings. 👋 [technical debt] I needed H2 version upgrade to address security vulnerabilities in
Mar 23
Peter Borissow
,
Evgenij Ryazanov
3
Mar 22
create domain text[]
Thanks for confirming that there is currently no way to create a "text[]" domain. Just as
unread,
create domain text[]
Thanks for confirming that there is currently no way to create a "text[]" domain. Just as
Mar 22
Alexander Kainz
, …
Andrei Tokar
6
Mar 20
A single update can 10x the filesize of the database
Hi Andrei, as I said I'm coming from a place where I do not need help. I got rid of the UPDATE
unread,
A single update can 10x the filesize of the database
Hi Andrei, as I said I'm coming from a place where I do not need help. I got rid of the UPDATE
Mar 20
Ulrich
, …
Andrei Tokar
4
Mar 19
Compact on db close does not shrink db file size
Hi Noel, hi Andrei, thanks for your explanations around the compact procedures! I will try to play
unread,
Compact on db close does not shrink db file size
Hi Noel, hi Andrei, thanks for your explanations around the compact procedures! I will try to play
Mar 19
Olaf van der Meer
,
Evgenij Ryazanov
2
Mar 12
concurrent queries
Hi! All 1.*.* versions of H2 are entirely outdated and aren't supported in any way. 1. H2 1.4.*
unread,
concurrent queries
Hi! All 1.*.* versions of H2 are entirely outdated and aren't supported in any way. 1. H2 1.4.*
Mar 12
Sergio Morales
Mar 8
Rate limiting in H2
Hi, what options are available when you have a single server managing multiple databases? How can I
unread,
Rate limiting in H2
Hi, what options are available when you have a single server managing multiple databases? How can I
Mar 8
mche...@gmail.com
,
mps
2
Mar 4
possible to add these functions?
do it yourself. Starting: rawtohex example for next step: medium P mche...@gmail.com a következőt
unread,
possible to add these functions?
do it yourself. Starting: rawtohex example for next step: medium P mche...@gmail.com a következőt
Mar 4
Olaf van der Meer
,
Toolforger
2
Feb 28
Userdefined functions and synchronized
Not an H2 question but a multithreading-in-Java question. I have answers but don't want to go off
unread,
Userdefined functions and synchronized
Not an H2 question but a multithreading-in-Java question. I have answers but don't want to go off
Feb 28
Ryan Hamilton
,
Roman Stoffel
3
Feb 22
H2 Queries Online - 2.2.220
Thanks Roman. I've repaired the old link with a redirect now. On Thu, Feb 22, 2024 at 1:24 PM
unread,
H2 Queries Online - 2.2.220
Thanks Roman. I've repaired the old link with a redirect now. On Thu, Feb 22, 2024 at 1:24 PM
Feb 22
Peter Borissow
, …
Evgenij Ryazanov
9
Feb 17
Year alias in select statement
Thanks for checking Evgenij. I was mistaken - adding "YEAR" to the "NON_KEYWORDS"
unread,
Year alias in select statement
Thanks for checking Evgenij. I was mistaken - adding "YEAR" to the "NON_KEYWORDS"
Feb 17
Ebuzer Taha Kanat
Feb 11
How to create a database at startup with bash
I'm trying to start database RUN java -cp /tmp/h2/h2.jar org.h2.tools.Server -webAllowOthers -
unread,
How to create a database at startup with bash
I'm trying to start database RUN java -cp /tmp/h2/h2.jar org.h2.tools.Server -webAllowOthers -
Feb 11
Balamurali Krishna Ippili
,
Evgenij Ryazanov
3
Feb 9
UNIQUE KEY constraint in H2-1.4.199 is not working with H2-2.2.224
Hi Evgenij Ryazanov , Thank you so much for your quick response and the suggestion. When changed the
unread,
UNIQUE KEY constraint in H2-1.4.199 is not working with H2-2.2.224
Hi Evgenij Ryazanov , Thank you so much for your quick response and the suggestion. When changed the
Feb 9
Coff ee
2
Feb 8
Need help with IKVM 8.7.5 + H2 2.2.220 + ojdbc8.jar + VS2019 + net472
Update: IKVM 8.7.5 + H2 2.2.220 + ojdbc8.jar + VS2019 + net472 still not work. I have new founding
unread,
Need help with IKVM 8.7.5 + H2 2.2.220 + ojdbc8.jar + VS2019 + net472
Update: IKVM 8.7.5 + H2 2.2.220 + ojdbc8.jar + VS2019 + net472 still not work. I have new founding
Feb 8
Paulo Destro
Feb 2
Is there a workaround for "RETURNING" POSTGRES SQL on H2
I use H2 as JUnit tests and Postgres as the main database. I want to know if there is a workaround
unread,
Is there a workaround for "RETURNING" POSTGRES SQL on H2
I use H2 as JUnit tests and Postgres as the main database. I want to know if there is a workaround
Feb 2
Gaus Lostre
, …
Paulo Destro
4
Feb 2
Infinite looping when trigger updates same table
My git repository https://github.com/pddec/loop On Thursday, January 4, 2024 at 8:27:45 PM UTC-3
unread,
Infinite looping when trigger updates same table
My git repository https://github.com/pddec/loop On Thursday, January 4, 2024 at 8:27:45 PM UTC-3
Feb 2
mche...@gmail.com
,
Andreas Reichel
3
Jan 31
hex
no, i have a column which is integer, I want to display it as hex. thanks On Tuesday 16 January 2024
unread,
hex
no, i have a column which is integer, I want to display it as hex. thanks On Tuesday 16 January 2024
Jan 31
Alberto Soki
Jan 24
Proper Citation for H2 Database Link in Academic Article
Hello, everyone. How to cite this link in the most accurate way in an academic article? I cited it as
unread,
Proper Citation for H2 Database Link in Academic Article
Hello, everyone. How to cite this link in the most accurate way in an academic article? I cited it as
Jan 24
Drew Dimanlig
, …
Evgenij Ryazanov
4
Jan 18
Syntax error with ON CONFLICT
Hello! This PostgreSQL-specific clause is not supported by H2. You need to use the MERGE command from
unread,
Syntax error with ON CONFLICT
Hello! This PostgreSQL-specific clause is not supported by H2. You need to use the MERGE command from
Jan 18
mche...@gmail.com
,
Andreas Reichel
7
Jan 14
push the insert speed to max
This seems to be a useful and interesting link: https://commons.apache.org/proper/commons-jcs/
unread,
push the insert speed to max
This seems to be a useful and interesting link: https://commons.apache.org/proper/commons-jcs/
Jan 14