Re: [h2] H2 Database Engine: New version 2.3.230 released

Thank you so much, H2 team! We have done our part and integrated it into the H2 Migration Tool already: https://manticore-projects.com/H2MigrationTool/index.html All the best Andreas On Sun, 2024-07-14 at 18:57 -0400, Andrei Tokar wrote: > Hello, > > A new version 2.3.230 of H2 is

Re: [h2] Re: Duplicate records when order by date?

On Tue, 2024-04-16 at 09:54 +, 'Peter Borissow' via H2 Database wrote: > Hmm... I kinda have a row id already via the unique primary key. What > advantage would a temp table give in my case? The advantage is, that special column _rowid_ is the physical row of the data frame and it would not

Re: [h2] Re: Duplicate records when order by date?

In my understanding, you could create a temporary table from your query (without pagination) and then use the special column `_row_id_` for the pagination. On Tue, 2024-04-16 at 16:42 +0700, Andreas Reichel wrote: > On Tue, 2024-04-16 at 09:14 +, 'Peter Borissow' via H2 Database >

Re: [h2] Re: Duplicate records when order by date?

iteria -- which was "ID" in your example only. Cheers Andreas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...

Re: [h2] Re: Duplicate records when order by date?

Peter, from what I can see, your records are NOT DISTINCT regarding the ORDER criteria? So what exactly do you expect to happen when there is no formal contract on the order and sorting? Thought experiment: insert all your records but with exactly the same Date/Timestamp -- in this case, your

Re: [h2] working around differences with h2 PSQL compatibilty

Greetings! You could use JSQLParser to parse your query and then transpile/rewrite it into the specific dialect. If you would like to give me a Query sample then I will happily assist you with a template. Cheers Andreas On Sun, 2024-04-07 at 08:27 -0700, broccolai wrote: > hi! > > I'm

Re: [h2] A single update can 10x the filesize of the database

Greetings! Please try to either a) partitioning you update into smaller chunks/commits or b) use a CTAS instead (although I am not a big fan of this). Good luck Andreas On Sat, 2024-03-16 at 22:11 -0700, Alexander Kainz wrote: > Hi, > > I wanted to mention this issue that took m

Re: [h2] Year alias in select statement

issues. I may be wrong of course. Cheers Andreas On Sat, 2024-02-17 at 02:46 +, 'Peter Borissow' via H2 Database wrote: > Thank you. I get it. Compatibility mode with PostgreSQL is incomplete > and certain regressions are to be expected when jumping major > versions. > > I w

Re: [h2] Year alias in select statement

On Sat, 2024-02-17 at 08:09 +0700, Andreas Reichel wrote: > Quoting transaction didn't have any effect. Try again on MS SQL Server  -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receivin

Re: [h2] Year alias in select statement

Greetings! On Sat, 2024-02-17 at 00:47 +, 'Peter Borissow' via H2 Database wrote: > > Hi Andreas, >    Thanks for the quick reply! As you suggest, quoting "year" as the > alias works. Quoting transaction didn't have any effect. Several > questions: >

Re: [h2] Year alias in select statement

s advisable to avoid such keywords are object identifiers. Cheers Andreas On Sat, 2024-02-17 at 00:25 +, 'Peter Borissow' via H2 Database wrote: > Dear H2 Community, >     I ran into an unexpected error today migrating from 1.x to 2.x. > I'm using H2 2.2.224 in PostgreSQL mode usi

Re: [h2] Syntax error with ON CONFLICT

Greetings! The `ON CONFLICT ...` clause is Postgres specific and certainly not supported in H2. Please read Postgres' "MODE" as: some specific syntax is supported, but there is no guarantee of full compliance. Best regards Andreas On Wed, 2024-01-17 at 15:04 -0800, 'Drew Dimanl

Re: [h2] hex

1678e845ean%40googlegroups.com > . this one: https://www.h2database.com/html/functions.html#hextoraw ? cheers Andreas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, se

Re: [h2] push the insert speed to max

ST reading vs. b) FAST fetching. The fastest data-pump can easily result in the slowest data read and somehow you will may want to balance your expectations. (For me, reading is always more important than writing.) Cheers Andreas -- You received this message because you are subscribed to the Goo

Re: [h2] push the insert speed to max

use-case is to have a minimum deploy/maintenance all batteries included Jar DB -- not so much the raw performance. Cheers Andreas On Sun, 2024-01-14 at 00:48 -0800, mche...@gmail.com wrote: > 1) Ensure that all Indexes and constraints are turned off > > yes, faster > > 2) Re

Re: [h2] push the insert speed to max

Forgot one: try multi threading, e. g. populating one prepared statement while another is executed/written. Not guaranteed if this really will be faster though. On Fri, 2024-01-12 at 15:38 +0700, Andreas Reichel wrote: > Greetings. > > On Fri, 2024-01-12 at 00:17 -0800, mche...@gmail.

Re: [h2] push the insert speed to max

ing What exactly does "1xk" mean?  If you are really serious about loading speed you will end up with Oracle Loader. Not that I am promoting this shit, but in reality it is the fastest way for pumping data into a DB.  Best regards Andreas -- You received this message because you are subsc

Re: [h2] why insert many record to in-memory database is same speed as embedded-mode

Because its cached and data are written to disk only eventually when the cache is full? On Mon, 2024-01-08 at 09:20 -0800, mche...@gmail.com wrote: > hi. >    why insert many record to in-memory database is same speed as > embedded-mode. In-mem should be much faster, right? > > > import

Re: [h2] open a db file named xxxxx.h2.db

/manticore-projects.com/H2MigrationTool/index.html (But I have not done many tests with those ancients versions. I am in interested in feedback though.) Good luck and cheers Andreas On Tue, 2023-12-26 at 04:13 -0800, Ali Atav wrote: > Hello everyone.  > > First of all; merry xmas

Re: [h2] H2 db migration tool

On Fri, 2023-12-15 at 04:14 -0800, prayag shete wrote: > How to use https://github.com/manticore-projects/H2MigrationTool > on linux server without UI, want to upgrade db from 1.4 jar to 2.2 Please see: https://manticore-projects.com/H2MigrationTool/usage.html Best regards Andreas -

[h2] Building Pivot Tables with Example

think of it and which additional features may be useful. Your PRs and suggestions will be most welcome and appreciated. Thank you for your time and cheers Andreas 0) Maven Artifact implementation('com.manticore-projects.jdbc:MJdbcUtils:+') {changing=true} 1) Source ResultSet, with VALUE_DATE

Re: [h2] Comparing NULL able columns --> IS DISTINCT FROM

check out the support on the different RDBMS. Best regards Andreas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@google

Re: [h2] Comparing NULL able columns --> IS DISTINCT FROM

for compatibility. On Mon, 2023-09-04 at 22:25 +0700, Andreas Reichel wrote: > Greetings. > > please let me ask for some brain storming: > > I have a table COUNTER_PARTY and a matching staging table > IMP_COUNTERPARTY. > Now I want to find any records of COUNTER_PARTY which will

[h2] Comparing NULL able columns

, this fails for DECIMALS, e.g.   NVL(  a.age, 0) != NVL( b.age, 0) wont work when age is defined as DECIMAL(3,0) Can't we have a simplified Compare() or Equal() function?  Thank you for any input, best regards Andreas -- You received this message because you are subscribed to the Google

Re: [h2] H2 Database Engine: New version released

engaging the JMH benachmarking tool. I am still working on a generic Performance Test Framework, which can read simply Test Case Scripts like the one attached. In the meantime, please elaborate on your concern since I can't really confirm it so far. Best regards Andreas -- You received

Re: [h2] H2 Database Engine: New version released

all provided drivers. if not, would you like to accept such a basic test performance test suite? Best regards Andreas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, sen

Re: [h2] H2 Database Engine: New version released

ILD SUCCESSFUL in 1m 13s What exactly means "after some seconds" vs. "after some minutes"? Can you elaborate on the details please? Best regards Andreas On Tue, 2023-08-29 at 03:53 -0700, Jürgen Pingel wrote: > Thanks for the fix version 2.2.222. > Don't know if it wi

Re: [h2] H2 Database Engine: New version released

ase: We have amended H2MigrationTool for support of H2 2.2.222 already. http://h2migrationtool.manticore-projects.com/ Best regards Andreas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receivin

[h2] Fastest way to load MASSIVE data into H2

--> PARQUET File --> PreparedStatement --> Rebuild Index? Thank you in advance and cheers Andreas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h

Re: [h2] H2 DB - Issues with the migration need from 2.1 to 2.2. And likely again to 2.3?

re completely broken since 2.1.212 and return no rows (without throwing errors). As long as you don't use CTEs, you should be good. If you use CTEs you may need to refactor your queries (We use JSQLParser for this.) Good luck and cheers Andreas -- You received this message because you are subscri

Re: [h2] Problem upgrading from h2 version 2.1.214 to 2.2.220

Andreas On Tue, 2023-08-01 at 06:35 -0700, Fredrik Sjögren wrote: > When we have upgraded the h2 library we get following error trying to > open the existing databases: > > Unsupported database file version or invalid file header in file > "/path/to/database.h2.mv.db"

Re: [h2] Slow Performance of Update / merge into sStatements

to "write amplification". I filed a similar issue 2 years back. The received advice was: 1) remove indexes, update, create indexes (effective, but not nice) 2) update smaller portions (is this what you mean with "split" mode?) Best regards Andreas On Wed, 2023-07-19 at 07:24 -0

Re: [h2] H2 Database Engine: New version released

egards Andreas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://gro

Re: [h2] H2 Database Engine: New version released

Thank you so much H2 Team! We have updated the H2 Migration Tool to reflect the new H2 Library. <https://manticore-projects.com/H2MigrationTool/index.html> All the best Andreas On Tue, Jul 4 2023 at 01:07:51 PM -04:00:00, Andrei Tokar wrote: Hello, A new version 2.2.220

[h2] H2 Migration Tool 1.3.4 with Online Version and H2 2.2.219 Snapshot

Greetings! We have updated the H2 Migration Tool and made an Online Version available (for the quick migration or recovery in between). Please see: http://h2migrationtool.manticore-projects.com Cheers Andreas -- You received this message because you are subscribed to the Google Groups &qu

Re: [h2] Create an SQL to copy all from H2 database in geonetork

works on any OS including MacOS since it is a Java based application which depends on a JRE 11 only. Good luck! Andreas On Tue, 2023-05-30 at 02:15 -0700, xavi rayo wrote: > My main problem is that I have de h2.db file but I can't find how to > acces to it > > El dia dimarts, 30 de

Re: [h2] Create an SQL to copy all from H2 database in geonetork

Greetings, you can try "Export to SQL" and/or "Recovery". Both will give you an SQL script which can be used to create a DB afresh. There is command line and I also provide an (unoffical) UI:  https://github.com/manticore-projects/H2MigrationTool Good luck! Andreas On Mon,

Re: [h2] SpringBoot multi Thread. Query extremely slow

. IF the performance is the same (more or less), then the issue is with your table/index design or with Spring/Hibernate. (I assume this is the case here.) Only if the performance was much better, then this may be a H2 issue worth to report. Good luck Andreas -- You received this message because you

Re: [h2] SpringBoot multi Thread. Query extremely slow

against H2 directly and eliminate the Spring/Hibernate Layer. Get a proper execution plan and check the reads and used indices. Avoid Full table Scans at all cost. Good Luck! Andreas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubs

Re: [h2] Problem updating from 1.4.200 to 2.1.214

Greetings, maybe compile H2 from source by yourself with a JDK 8, just to prove any doubts. Best regards Andreas On Tue, 2023-05-23 at 14:51 +0530, Vardhan Belide wrote: > Hi, > I am trying to update from 1.4.200 to 2.1.214. I am using Java 8 in > my project. I have the following piec

Re: [h2] In-Memory H2 deleted rows not garbage collected.

to write a self containing unit test simulating this, Only this way people will help ypu. Best regards Andreas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an em

Re: [h2] In-Memory H2 deleted rows not garbage collected.

peaks or grows forever. Cheers Andreas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To view this discussion

Re: [h2] Latest version H2 available via tycho

Greetings. You may consider BNDTOOLS https://bndtools.org/ over TYCHO in order to manage dependencies via Maven coordinates. Best regards Andreas On Fri, 2023-05-12 at 00:38 -0700, mrbr...@gmail.com wrote: > I have inherited an old project that is based on Eclipse 2019-09 and > uses

Re: [h2] Request for advice

= c.fk_a Why use (uncorrelated?) sub-queries? Best regards Andreas On Wed, 2023-04-26 at 02:03 -0700, Silvio wrote: > We have some heavy queries that involve selecting records from a base > cached table A (~100K records) that satisfy a quite a number of > conditions expressed as

[h2] PR #3786 CSV empty String to Number conversion

Greetings! To whom it may concern: I wrote the code, it's mine, and I'm contributing it to H2 for distribution multiple-licensed under the MPL 2.0, and the EPL 1.0 (https://h2database.com/html/license.html).  Warm regards Andreas -- You received this message because you are subscribed

Re: [h2] DB file size grows in an unexpected size (H2 version 1.4)

ing the VM).  Cheers Andreas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To view this discussion on

Re: [h2] DB file size grows in an unexpected size (H2 version 1.4)

s to break such large DMLs into smaller chunks, which I did not find easy since there is no "RETURNING" facility in H2. Alternatively you would have to remove indexes, execute your DML and create indexes afresh. Good luck and cheers Andreas On Tue, 2023-04-18 at 03:59 -0700, Jürgen Pingel

Re: [h2] Alter table not working from code with prepared statements, but working from console (browser)

used it for ORACLE's CREATE TABLE ... AS SELECT ... FROM (where the SELECT must not contain parameters). Good luck and cheers Andreas On Fri, 2023-04-14 at 04:44 -0700, airjairj wrote: > The following code is what i'm using for the alter table, nothing > special but it results in an exc

Re: [h2] Re: Need help in diagnosing the db file

Unfortunately you can't count on it since there are no resources available for such an analysis. Only when you have a self contained repeatable test case there was a realistic chance to get help. On 12 Apr 2023 15:47, Moleesh A wrote:Anyone got a chnace to look into this ?On Tuesday, March 28,

Re: [h2] Re: show hex value

Greetings. On Sat, 2023-01-21 at 09:21 -0800, mche...@gmail.com wrote: > hi , possible to show an integer in hex format? As far as I understand you can define your own Functions in H2, using Java language. This should do the trick. Cheers Andreas -- You received this message because

Re: [h2] index doesn't help

ssible the OR expressions are not considered at all. It's not a Oracle DB after all. Good luck Andreas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-d

Re: [h2] Re: questions about case sensitivity

entifiers "upper case" (maybe with Functions spelled "camel case", if you are adventurous). select COLUMN1, MY_COLUMN_2 from CFE.TABLE_NAME where Trim(COLUMN1)='something'; This will always work, with out without quoting. And its easy to read even when most SQL syntax highlighti

Re: [h2] Re: questions about case sensitivity

e usual challenge of writing platform agnostic SQL. My advice: stick to the SQL:2016 standard as much as possible and document well founded deviations (e.g. Oracle .nextval) when forced to use it. Cheers Andreas -- You received this message because you are subscribed to the Google Groups "H2

Re: [h2] Re: RecoverTools creating scrip with tablenames 0_Number pattern? why

*)\*/ _1.toUpperCase() 2) Alternatively, parse your exported SQL with JSQLParser and the use a customized De-Parser to rewrite it T-SQL compliant. Illustration is here: https://www.manticore-projects.com/JSQLParser/usage.html#parse-a-sql-statements Good luck and cheers Andreas -- You received thi

Re: [h2] index doesn't speed up

From https://www.h2database.com/html/performance.html: This database uses indexes to improve the performance ofSELECT, UPDATE, DELETE. If a column is used in the WHERE clause of a query, and if an index exists on this column, then the index can be used. Multi-column indexes are used if all or the

Re: [h2] index doesn't speed up

for SEQUENCE (replacing you composite index). Good luck Andreas On Sun, 2022-12-18 at 02:17 -0800, mche...@gmail.com wrote: > hi >    i have 20 millions rows , and this index doesn't speed up the > query, please help: > > create index mem on data(mem, sequence); > > select

Re: [h2] How are "multiple rows" represented in MVStore?

. Cheers Andreas On Sat, 2022-10-29 at 10:50 +, 'Mark Raynsford' via H2 Database wrote: > > > Imagine I had the following rows: > >   (1, 1)   // Group 1 contains member 1 >   (1, 23)  // Group 1 also contains member 23 >   (1, 24)  // Group 1 also contains member 24 &g

Re: [h2] How are "multiple rows" represented in MVStore?

nt member ) and a class T (int group, int member). If group represents the key, and member represents the object, then PRIMARY KEY(group) and MAP. Best regards Andreas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from t

Re: [h2] ALTER VIEW PUBLIC."View1" AS SELECT ....

Sorry, I seem to have misread your e-mail. Now it would be: DROP VIEW .. IF EXISTS CREATE OR REPLACE VIEW .. IF NOT EXISTS Best regards Andreas On Tue, 2022-07-05 at 02:50 -0700, prrvchr wrote: > Hi Andreas, > > The UNO API also provides an interface com.sun.star.sdbcx.XRename to

Re: [h2] ALTER VIEW PUBLIC."View1" AS SELECT ....

Greetings! On Tue, 2022-07-05 at 02:36 -0700, prrvchr wrote: > What is the best alternative with H2? H2 has a really excellent documentation: https://www.h2database.com/html/commands.html Your are looking for: https://www.h2database.com/html/commands.html#alter_view_rename Best regards Andr

Re: [h2] Export a MSSQL compatible script from h2?

+ _2.toLowerCase() + "]" (\w*)\.(\w*).NEXTVAL "NEXT VALUE FOR " + _1.toLowerCase() + "." + _2.toLowerCase() /\*TRANSACT: ([\w\s]*)\*/ _1.toUpperCase() More rules/search expressions may be needed, depending on your database. Good luck and best regards Andreas -- Yo

Re: [h2] Automatic COMPACT does not seem to work

daily). It is a very welcome improvement, which deserve more promotion in my opinion. All the best Andreas  On Fri, 2022-06-24 at 12:47 -0700, Andrei Tokar wrote: > Yes, it makes sense now to make RETENTION_TIME=0 as a default. Use > case for a positive value is that it theoretically improv

Re: [h2] Automatic COMPACT does not seem to work

300 MB defragmented content blown up to 20 GByte. The databases are idle during the night and most time the day. Heavy Delete/Write/Querying happens only in the early morning -- but it never shrinks, only grows, until "SHUTDOWN DEFRAG". Best regards Andreas -- You received this mes

Re: [h2] Automatic COMPACT does not seem to work

especially when data are constantly written and deleted. I made exactly the same observation. Best regards Andreas On Mon, 2022-06-13 at 02:48 -0700, Ulrich wrote: > Hi all, > > I am running a H2 2.1.212 and I wonder why the automatic compact > feature does not shrink the database siz

Re: [h2] Column not found when SELECTing from a recursive Common Table Expression (CTE)

experimental although I never had problem using those with latest snapshots 2.2.212 - 2.2.219 Best of luck Andreas On Sat, 2022-06-11 at 10:34 -0700, Robert Faust wrote: > Hello all, > > I'm new to the group so I apologize if this question has already been > answered elsewhere. I'm

Re: [h2] Database corrupted after SHUTDOWN COMPACT

Agreed, I just provided alternatives and options. Cheers Andreas On Fri, 2022-06-10 at 03:54 -0700, Ulrich wrote: > Do you mean the migration tool as UI? > The database has already been migrated by exporting it to SQL and > importing it with the FROM_1X appendix. So I do not e

Re: [h2] Database corrupted after SHUTDOWN COMPACT

Use the UI I sent to you. It takes care of those challenges. Sent from my Galaxy Original message From: Ulrich Date: 10/06/2022 12:21 (GMT+01:00) To: H2 Database Subject: Re: [h2] Database corrupted after SHUTDOWN COMPACT Stop, I am silly. It overlooked that the file

Re: [h2] Database corrupted after SHUTDOWN COMPACT

 https://github.com/manticore-projects/H2MigrationTool I am not a H2 developer but do use H2 on many large databases. It should work. Can you share the DB SQL script with me for an independent test? Viel Glueck Andreas On Fri, 2022-06-10 at 01:28 -0700, Ulrich wrote: > I tried with the latest

RE: [h2] Database corrupted after SHUTDOWN COMPACT

Greetings. Please try the latest snapshot. It has been fixed in 219.Sent from my Galaxy Original message From: Ulrich Date: 10/06/2022 09:34 (GMT+01:00) To: H2 Database Subject: [h2] Database corrupted after SHUTDOWN COMPACT Hi all,I am migrating my application from H2

Re: [h2] How to create table programming in version 2 ?

). This way you would be independent from the particular SQL Flavour and/or RDBMS. Cheers and good luck. Andreas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, sen

Re: [h2] How to run a sql script with duplicate insert queries on h2db

, id_attribute HAVING Count( * ) > 1 ) ; The example above would ensure a UNBIQUE KEY (id_instrument, id_attribute) in table cfe.instrument_attribute (although you would need to repeat that delete until no row is returned). Good luck Andreas -- You received

Re: [h2] H2 Running problem

. java -jar libs/h2.jar from the console) 2) What is the output on the console after starting it 3) How do you connect to the H2 server (e.g. URL connection settings) 4) What network ports are in use and does your firewall allow for them Good luck and cheers Andreas -- You received this message b

Re: [h2] UNLINK_SCHEMA as opposition of LINK_SCHEMA, LINK_SCHEMA RFE and questions

hema anymore, is there something like > UNLINK_SCHEMA?  Would not that be a simple DROP SCHEMA? Best regards Andreas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emai

RE: [h2] Is it possible to flatten arrays when doing nested array aggregation?

https://www.h2database.com/html/functions.html#unnestThis one.Sent from my Galaxy Original message From: Adam R Date: 26/04/2022 05:59 (GMT+01:00) To: H2 Database Subject: [h2] Is it possible to flatten arrays when doing nested array aggregation? Here's a toy

RE: [h2] Is it possible to flatten arrays when doing nested array aggregation?

Greetings. Why would you not aggregate on the whole table without the subquery?Anyway. If the subquery must be involved then you needed to unroll its arrays first before aggregating it again.Look for the unnest syntax in h2. I know its supported.Best regards AndreasSent from my Galaxy

[h2] Big Thank You!

Shout-out to the team and big thank you for the corrections and the frequent releases! Cheers Andreas On Sat, 2022-04-09 at 09:15 -0400, Andrei Tokar wrote: > Hello, > > A new version 2.1.212 of H2 is available at http://www.h2database.com > (you may have to cl

Re: [h2] insert with on conflict do nothing not working

from the SELECT list. It should work. What is your connection setting please? Best regards Andreas On Tue, 2022-04-05 at 16:28 -0700, Tom wrote: > hi All, > > Is there anything special that I need to do to get ON CONFLICT DO > NOTHING working with Postgresql? I'm using H2 2.1.210 

[h2] H2 Database Migration Tool 1.2 released

Greetings. Release 1.2 fixes the Connection Strings on Windows and provides an Ueber-Jar. https://github.com/manticore-projects/H2MigrationTool Any issues, please do let me know. Cheers -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To

Re: [h2] Query in latest version is returning empty results

xample, you may better ask the Perl obfuscation contest for help. Best regards Andreas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+uns

[h2] Library for Support of Named Parameter Statements

to be RDBMS agnostic as possible. Warm regards Andreas -- MJdbcUtils Library supporting Named Parameters (e.g. :Customer_Id ) in Queries or DML/DDL statements. Use case When the RDBMS does not support Named Parameters directly, it will: 1) find any Named Parameter,  2) replace it with an ordinary

[h2] https://github.com/manticore-projects/MJdbcUtils for support of Named Parameter Statements

Statements nicely. Summary and examples are shown below. It is in its very early stages and I will appreciate feedback and tests and are more than willing to incorporate interesting use cases. I do use H2 as basis for the development, although I want to be RDBMS agnostic as possible. Warm regards Andreas

[h2] H2 Performance Windows vs Linux

have expected a very similar performance -- given that it runs within the JVM.  Any thoughts on this? Warm regards Andreas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails fro

Re: [h2] DB regression when exiting with SHUTDOWN COMPACT?

ave gotten much more stable recently -- just a "gut feeling" though.) Best regards Andreas On Thu, 2021-12-09 at 04:20 -0800, torlpedo wrote: > Hi all, > > Creating a medium sized database (300MB with 800MB disk usage) and > then exiting with SHUTDOWN COMPACT makes t

Re: [h2] Release date of next version of H2? Maybe version 2.x?

Greetings. The situation seems to be difficult: H2 is written by volunteers in their precious spare time and at the same time is a software which depends on a lot of knowledge and expertise. Right now, the main developers do not seem to be able to invest much time. Even sponsoring offers did not

Re: [h2] H2 Database not support materialized?

Greetings: I do not think H2 supports MATERIALIZED within WITH CTEs: https://www.h2database.com/html/commands.html#with Best regards Andreas On Fri, 2021-06-04 at 00:36 -0700, JUN LUO wrote: > When my SQL contains materialized, some exception appea

Re: [h2] Re: Same query, sometimes I get JdbcSQLSyntaxErrorException, sometimes not :o

Greetings. On Sat, 2021-05-22 at 21:26 -0700, Evgenij Ryazanov wrote: > It may be surprising, but validity of some queries depends on the > data. > H2 and some other DBMS support optional feature T301, “Functional > dependencies” from the SQL Standard.  Indeed! > SELECT A, B, COUNT(C) FROM TEST

Re: [h2] using external(cloud) key-value db as backing store

u will use "Shared" mode and will rely on a kind of Service Dispatcher, which is usually the H2 SQL Server over a TCP connection. Anyway, maybe I am just not understanding it well and  it is certainly not on me to evangelize you.  Good luck and cheers Andreas -- You received t

Re: [h2] using external(cloud) key-value db as backing store

uot;traditional" approach (despite having no buzzwords in the description). Cheers Andreas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to

Re: [h2] Re: 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 and stop it when the software exits.When the port is found open we assume the h2 servers has been started externally and act as a client strictly.This may not been best practise but works like a

Re: [h2] Don't get AVG(DareDiff) field in java and H2

nobody will be able to walk through the code using screenshots only Best regards Andreas  -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-databas

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

a volume. I have experimented with H2 databases up to 20 GByte large and they perform surprisingly well as long as you avoid large DML with indexes or constraints. There is an open ticket on "INSERT INTO ... SELECT .. FROM ...". Best regards Andreas -- You received this message because you ar

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

oc/org/h2/tools/RunScript.html Good luck and best regards Andreas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegro

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

DBs, each product will need its own handling or SQL statement where not compliant with the standard. In case of H2 compared to Oracle, we do not need any particular adjustments any more (since 2.0.201), while MS SQL Server has basically its own DDL/query definition file. Running the same soft

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

to 2.0.201 eventually. Consider using 2.0.201 and establish a weekly procedure of exporting to SQL script and re-importing into the next version, followed by a large batch processing test including reports. This works for us at least and has reduce the headache. Best regards Andreas On Mon, 2021-0

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

ver again since we switched to 2.0.201+ (until Feb/March 2020). In my opinion, the current 2.0.201+ snapshot is the most robust and correct H2 database and I prefer this "unstable" develepmoent snapshot over the actually released versions. Best regards Andreas  -- You received this me

Re: [h2] 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, one can easily migrate many H2 databases from one H2 snapshot to another one. You can now also add H2 Drivers to the program (e. g. for adding more snapshots or adding older H2 versions). There

Re: [h2] For everyone who use snapshot builds of upcoming H2 2.0

On Mon, 2021-02-15 at 08:11 +0700, Andreas Reichel wrote: > this is where a "Build ID" or "Commit ID" would become handy, packing > into "h2-2.0.201_888e228.jar" instead of "h2-2.0.201" only. Patch attached. Best regards Andreas -- You re

Re: [h2] For everyone who use snapshot builds of upcoming H2 2.0

sely as possible even when 1.4.200 is declared stable. (At least in our experience, 1.4.200 is far less robust and correct than 2.0.201.) I will also have to figure out, how to support "Build IDs" in the Migration Tool, because following your advise we will have to export/create 20 H2 da

[h2] Re: Automatic H2 Migration tool, first release for testing --> UI is functional

/releases/download/v1.0/H2MigrationTool-1.0.zip Best regards Andreas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.co

Re: [h2] Debugging large database file

are written 2) "pagination" helps, but is not very robust or reliable Also, beyond the problem above, H2 in general is meant to take a lot of filespace -- trading of speed vs. file space efficiency. Best regards Andreas On Thu, 2021-02-11 at 10:11 -0800, Quy Nguyen wrote: > Hello, > &

  1   2   >