Groups
Sign in
Groups
H2 Database
Conversations
About
Send feedback
Help
H2 Database
Contact owners and managers
1–30 of 6668
This is the mailing list of the
H2 database engine
.
Mark all as read
Report group
0 selected
Chris van Hinsbergen
,
Andrei Tokar
3
Jun 11
Changes to MVStore.getMetaMap() does not trigger commit()
Hi Andrei, Sorry, I missed that javadoc (RTFM, I know). I was looking for a place to store meta data
unread,
Changes to MVStore.getMetaMap() does not trigger commit()
Hi Andrei, Sorry, I missed that javadoc (RTFM, I know). I was looking for a place to store meta data
Jun 11
Yusuf Welder
Jun 9
All
paypal.me/yusufwelding
unread,
All
paypal.me/yusufwelding
Jun 9
Rinse Lemstra
, …
Yusuf Welder
3
Jun 9
what data is removed during DEFRAG
paypal.me/yusufwelding Pada Minggu, 09 Juni 2024 pukul 04.20.34 UTC+7 Andrei Tokar menulis: Plaese
unread,
what data is removed during DEFRAG
paypal.me/yusufwelding Pada Minggu, 09 Juni 2024 pukul 04.20.34 UTC+7 Andrei Tokar menulis: Plaese
Jun 9
Yusuf Welder
Jun 9
Help donase
paypal.me/yusufwelding
unread,
Help donase
paypal.me/yusufwelding
Jun 9
Olaf van der Meer
May 31
When will a new version be released?
Hi, The last release is from Sept 2023? I have seen there are some patches since than. Does anyone
unread,
When will a new version be released?
Hi, The last release is from Sept 2023? I have seen there are some patches since than. Does anyone
May 31
Doug Merrett
,
Evgenij Ryazanov
3
May 22
How to tell .db version without opening it
Thanks for the help Evgenij On Wednesday 22 May 2024 at 9:42:59 pm UTC+10 Evgenij Ryazanov wrote: Hi!
unread,
How to tell .db version without opening it
Thanks for the help Evgenij On Wednesday 22 May 2024 at 9:42:59 pm UTC+10 Evgenij Ryazanov wrote: Hi!
May 22
Rinse Lemstra
, …
Christian Buchegger
3
May 22
Can aliases made by CREATE ALIAS , be retrieved by SQL?
I have not tried with the latest version, but for 2.1.214 CREATE ALIAS MY_SQRT FOR 'java.lang.
unread,
Can aliases made by CREATE ALIAS , be retrieved by SQL?
I have not tried with the latest version, but for 2.1.214 CREATE ALIAS MY_SQRT FOR 'java.lang.
May 22
Olaf van der Meer
2
May 14
Error during database recover
Hi, I see it has been fixed Nov 26, 2023 https://github.com/h2database/h2database/commit/
unread,
Error during database recover
Hi, I see it has been fixed Nov 26, 2023 https://github.com/h2database/h2database/commit/
May 14
Bruce Visscher
,
Noel Grandin
2
May 9
LOCK TABLE syntax doesn't work with H2
On 5/8/2024 6:31 PM, Bruce Visscher wrote: > On stack overflow, Thomas Mueller <https://
unread,
LOCK TABLE syntax doesn't work with H2
On 5/8/2024 6:31 PM, Bruce Visscher wrote: > On stack overflow, Thomas Mueller <https://
May 9
Marat Akselrod
,
Noel Grandin
2
May 3
Linked table issues (autocommit, prepared statement) ,modifications and licensing
On 5/1/2024 10:10 PM, Marat Akselrod wrote: > > And if it can take a long, I want to understand
unread,
Linked table issues (autocommit, prepared statement) ,modifications and licensing
On 5/1/2024 10:10 PM, Marat Akselrod wrote: > > And if it can take a long, I want to understand
May 3
Rinse Lemstra
2
Apr 27
what about *.mv.db files
forget this question. The files mentioned are empty databases. They still cause an exception during
unread,
what about *.mv.db files
forget this question. The files mentioned are empty databases. They still cause an exception during
Apr 27
neive
3
Apr 27
h2-2.2.224 Automatic Mixed Mode(AUTO_SERVER=TRUE) from different PCs no longer supported?
Sorry, it appears to be a Windows file sharing issue. *It was resolved by canceling sharing and
unread,
h2-2.2.224 Automatic Mixed Mode(AUTO_SERVER=TRUE) from different PCs no longer supported?
Sorry, it appears to be a Windows file sharing issue. *It was resolved by canceling sharing and
Apr 27
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
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