[h2] h2 database version 1.4.200 is corrupted with error code: 90030

Hello Team, I have one .mv.db file which is corrupted. I am using following command to recover the file, however it is showing error message. java -cp h2-1.4.200.jar org.h2.tools.Recover -dir "C:/corrupted" -db "asms_corrupted" -out "C:/recover/asms2_local_DB.mv" Please suggest what can be don

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

On Sat, 2024-08-10 at 17:45 -0400, Andrei Tokar wrote: > A new version 2.3.232 of H2 is available at http://www.h2database.com > (you may have to click 'Refresh') and > https://github.com/h2database/h2database/releases/tag/version-2.3.232 Thank you so much H2 team. We have followed up and release

[h2] H2 Database Engine: New version 2.3.232 released

Hello, A new version 2.3.232 of H2 is available at http://www.h2database.com (you may have to click 'Refresh') and https://github.com/h2database/h2database/releases/tag/version-2.3.232 For details, see the 'Change Log' at http://www.h2database.com/html/changelog.html New artefacts will be upl

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 available at h

[h2] H2 Database Engine: New version 2.3.230 released

Hello, A new version 2.3.230 of H2 is available at http://www.h2database.com (you may have to click 'Refresh') and https://github.com/h2database/h2database/releases/tag/version-2.3.230 For details, see the 'Change Log' at http://www.h2database.com/html/changelog.html New artefacts will be uploa

[h2] h2-2.2.224 Automatic Mixed Mode(AUTO_SERVER=TRUE) from different PCs no longer supported?

Hi Team, I tried upgrading h2-1.4.196 to h2-2.2.224 to verify. Is connecting with Automatic Mixed Mode(AUTO_SERVER=TRUE) from different PCs no longer supported? * Automatic Mixed Mode https://www.h2database.com/html/features.html?highlight=AUTO_SERVER&search=AUTO_SERVER%20#auto_mixed_mode * Co

[h2] H2 as an odb in LibreOffice Base

Hi all, I am working on an extension allowing access to H2 in LibreOffice in embedded mode. This allows you to have your H2 database, these Base Queries and Forms in a single odb file. In order to be able to manage the privileges I provide at the connection during the creation of the H2 Databa

[h2] H2 does not use SYSTEM TABLE in table types

Hi all, It's just a question. Why H2 does not use SYSTEM TABLE in the table types returned by the DatabaseMetaData.getTableTypes() method. How to filter tables found in system schemas (ie: INFORMATION_SCHEMA) using the getTableType() method? Thank you for your suggestions. -- You received th

[h2] 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 version *1.3.176 (*Remote Code Execution (RCE) via H2 Console)* To version latest version 2.2.224 (i.e currently on Java 17) *Added +* com.h2database h2 2.2.224 test *Removed

[h2] H2 Queries Online - 2.2.220

Hi, You can run H2 database queries online here: https://www.timestored.com/time-series-data/h2-database-online/ Today I updated the jar to h2-2.2.220.jar. Hopefully you find it useful. Thanks, Ryan Hamilton Founder TimeStored https://www.timestored.com/pulse/ -- You received this message b

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 -- You receiv

[h2] H2 db migration tool

Hello Team, 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 Thanks Prayag -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and st

Re: [h2] H2 Shell stuck wanting for response from database running mixed mode (1.4.196)

On Wed, 29 Nov 2023 at 17:46, Scott Huddleston < talascend.develo...@gmail.com> wrote: > I don't see any threads named "H2 TCP Server" in the application thread > dump, so your comment about the TCP server failing to start seems spot on. > Is that the correct name of the thread to look for? > > Ye

Re: [h2] H2 Shell stuck wanting for response from database running mixed mode (1.4.196)

Sorry, that thread dump was just an excerpt from the H2 shell. Other threads were definitely running. I've attached a thread dump from the application that runs H2 and the H2 shell. I didn't see any threads named "H2 TCP Server" in the application thread dump, so your comment about not starti

Re: [h2] H2 Shell stuck wanting for response from database running mixed mode (1.4.196)

Sorry, I only included an excerpt from the thread dump from running the H2 Shell. Other threads were definitely running. I've attached the thread dump from the application that runs H2 and the execution of the H2 shell. I don't see any threads named "H2 TCP Server" in the application thread d

Re: [h2] H2 Shell stuck wanting for response from database running mixed mode (1.4.196)

On 11/29/2023 12:42 AM, Scott Huddleston wrote: Where there other threads running when you took that thread dump? Because I dont' see the actual server thread running, which it what I would have expected. So most likely what happened is that some other program is running on the port that

[h2] H2 Shell stuck wanting for response from database running mixed mode (1.4.196)

Hello, I have an application that uses H2 1.4.196 running in mixed mode. Recently, I started the H2 Shell and instead of seeing the prompt like normal, it just hangs. The application uses the following url to connect jdbc:h2:file:/var/packet-manager/data/database/packetmanager;MVCC=TRUE;AUTO_

[h2] H2 Database Engine: New version released

Hello Everybody, A new version 2.2.224 of H2 is available at http://www.h2database.com (you may have to click 'Refresh'). This is a patch release, and there are no incompatibilities with on-disk format of v.2.2.222, so it can be used as drop in replacement for 2.2.222. It will be available in

[h2] H2 mem db failing with LocalDateTime

I have a Spring Boot 3.2 project which I want to use h2 mem The entities I have that contain LocalDateTime properties fail in the auto DDL. i.e. All the other tables get created for java objects that dont have a LocalDateTime property - but those objects that do fail. Hibernate is the ORM. s

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

Greetings! I have run your test through all H2 versions and have not been able to see any material performance deviation: INFO: 1.3.176: 101681 ms INFO: 1.4.196: 104554 ms INFO: 1.4.197: 103474 ms INFO: 1.4.198: 101421 ms INFO: 1.4.199: 99655 ms INFO: 1.4.200: 100125 ms INFO: 2.0.201: 100645 ms I

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

On 8/29/2023 1:33 PM, Andreas Reichel wrote: if not, would you like to accept such a basic test performance test suite? Sure, sounds like a useful tool. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and sto

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

H2 Team, do you have any facility in place for running such performance tests across various versions of H2 and comparing the outcome? Something like: 1) load driver 2) run various test scripts  3) write performance measures for this driver version as per script 4) unload driver and repeat over

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

Greetings Juergen. Unfortunately I can't reproduce your concern after implementing your test in the quickest and dirtiest way, with lots of overhead. It ran through in 1 minute and I did not see any slowdown while iterating: > Task :ETLBox:H2PerformanceTest.main() Aug 29, 2023 6:13:20 PM com.mant

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

Thanks for the fix version 2.2.222. Don't know if it will work for me, because I run with that revision into a performance problem. One of my unit tests runs now extremely long and it seems that much memory get allocated. Can't send you the complete code but I isolate it to the SQL statements and

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

On Wed, 2023-08-23 at 08:09 -0400, Andrei Tokar wrote: > This is a patch release, and AFAIK there are no incompatibilities > with > on-disk format of v.2.2.220, so hopefully it can be used as drop in > replacement for 2.2.220 (and only 2.2.220!). Thank you very much. Just in case: We have amended

[h2] H2 Database Engine: New version released

Hello Everybody, A new version 2.2.222 of H2 is available at http://www.h2database.com (you may have to click 'Refresh'). This is a patch release, and AFAIK there are no incompatibilities with on-disk format of v.2.2.220, so hopefully it can be used as drop in replacement for 2.2.220 (and only 2.

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

Hi, Jurgen and TheRaywell, Andrei has released h2-2.2.222 yesterday evening for public. I had a same error like You and now my code works OK without any error. So You can try 2.2.222 version and send the result to the appropriate email thread https://groups.google.com/g/h2-database/c/yCIcidC0pi

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

Hello, I have also this problem using the same H2 version - get a corrupted database. Do you have any solution or fix? Because without any fix that version is unusable for me. Thanks, Jürgen TheRaywell schrieb am Donnerstag, 20. Juli 2023 um 03:36:29 UTC+2: > H2 last release (220): after ins

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

On Thu, 2023-08-03 at 04:27 -0700, Thomas Hurley wrote: > I am a Product Manager with 3 commercial products using H2 and > needing to upgrade.  1 upgraded to 2.1 and we had to go through a > migration process to make this seamless to our customers (mostly > heavily regulated companies).  This upgra

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

hi , Posting this as a new conversation. one of my colleagues posted this recently: Fredrik Sjögren Aug 2, 2023, 4:07:04 PM (20 hours ago)    to H2 Database When we have upgraded the h2 library we get following error trying to open the existing databases: *Unsupported database file vers

[h2] H2 as an embedded database in LibreOffice / OpenOffice Base

It is possible to integrate any JDBC database into LibreOffice or OpenOffice Base. This integration has already been done for the HsqlDB database and SQLite JDBC with the HsqlDriverOOo and SQLiteOOo extension. I

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

H2 last release (220): after insert /delete command : In runtime, after a few inserts and deletions to the database version 2.2.220, our database was damaged, and we observe such a picture on several servers. Before that, we used version 2.1.214 for over 4 months without problem. The database ve

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

Greetings! On Tue, 2023-07-11 at 10:20 -0700, Vali Maties wrote: > How do I upgrade it to be able to use the latest driver, as long as > this one seems to be no more warnings in it! You could use the H2 Migration Tool https://manticore-projects.com/H2MigrationTool/index.html Best regards Andreas

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

Hi. I've tried to update the driver used in my Maven project from 2.1.214 to 2.2.220, and now it gives me some error: "The write format 2 is smaller than the supported format 3 [2.2.220/5]". Seems that I have to upgrade the database as well? How do I upgrade it to be able to use the latest dri

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. 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 of H2 is available

[h2] H2 Database Engine: New version released

Hello, A new version 2.2.220 of H2 is available at http://www.h2database.com (you may have to click 'Refresh') and https://github.com/h2database/h2database/releases/tag/version-2.2.220 For details, see the 'Change Log' at http://www.h2database.com/html/changelog.html New artefacts will be upl

[h2] H2 DB performance deteriorates after migration with Spring Boot 3

-1 We have migrated a Spring Boot 2.x to Spring Boot 3.x and still using the same H2 version 2.1.210. Internally it uses the whole stack (Spring data JPA, Hibernate, Hikari etc.) We found that H2 performance drastically decreased with Spring b

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

Happy birthday to the person who still isn’t showing their age…or acting it! On Wed, Jun 28, 2023 at 3:09 AM Andreas Reichel < andr...@manticore-projects.com> wrote: > Greetings! > > We have updated the H2 Migration Tool and made an Online Version available > (for the quick migration or recovery

[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 "H2 Data

[h2] H2 1.4.200 - Unable to Recover 90030 File corrupted while reading record

Hi all. Version 1.4.200 We had an issue with our database where the database got corrupted. If you try to open it, you get the error 90030. The database is around 500MB. We copied the database with the issue into a folder and then run java -cp /some/location/h2-1.4.200.jar org.h2.tools.Recover

Re: [h2] H2 Console beginner ;) issue

Solved... with Installation of oder 1.x Version 'Jochen Winkler' via H2 Database schrieb am Mo., 30. Jan. 2023, 09:33: > Following quickstart it does not create a test.db. Setting "Generic H2" > should be used, this is not in my list, instead I try to use "Generic DB2". > Get the error: " Datab

[h2] H2 Console beginner ;) issue

Following quickstart it does not create a test.db. Setting "Generic H2" should be used, this is not in my list, instead I try to use "Generic DB2". Get the error: " Database "C:/Users/myname/test" not found, either pre-create it or allow remote database creation (not recommended in secure envi

Re: [h2] H2 PreparedStatement and Arrays

Thank you very much for this hint. It does the trick. Am 06.12.2022 um 10:55 schrieb Evgenij Ryazanov: Your code actually constructs something like mstb_etypenum IN (ARRAY[2, 3, 4, 5]) instead of mstb_etypenum IN (2, 3, 4, 5). In SQL statements from JDBC (unlike in JPQL from JPA) you cannot pas

Re: [h2] H2 PreparedStatement and Arrays

Your code actually constructs something like mstb_etypenum IN (ARRAY[2, 3, 4, 5]) instead of mstb_etypenum IN (2, 3, 4, 5). In SQL statements from JDBC (unlike in JPQL from JPA) you cannot pass parameters in that way. One parameter always creates one value. You can use mstb_etypenum = ANY(?) i

Re: [h2] H2 PreparedStatement and Arrays

Unfortunately, this does not solve my problem. there is no table or column named BIGINT. The error seems to happen within H2 when it should  the Array typeArray as an arry of values to be used in the IN clause. It seems to try to convert the Array to a single BIGINT value for whatever reason (whi

Re: [h2] H2 PreparedStatement and Arrays

You can do something like: final Long[] messageIds = ... final String sqlQuery = "SELECT * FROM FROM FOO WHERE FOO.MessageID IN (SELECT ID FROM TABLE(ID BIGINT=?))"; PreparedStatement ps = conn.prepareStatement(sSqlQuery); ps.setObject(1, messageIds ); -- You received this messa

[h2] H2 PreparedStatement and Arrays

I am using H2 2.1.214 and facing this problem: part of SQL Select statement: ... + "where events.mstb_recno in (select mstb_recno from events where events.mstb_edate >= ? and events.mstb_edate <= ?) and " + "mstb_etypenum in (?) and " ... this statement can be prepared wit

Re: [h2] H2 knowledge

what documentation we have is all either at https://h2database.com/html/main.html or inside the source code -- 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

[h2] H2 knowledge

Hello Is there any documentation where we could learn all the things about H2? Like all the classes and their working in detail . How its used for Lucene and How it works with other databases. Thanks -- You received this message because you are subscribed to the Google Groups "H2 Database" gr

[h2] H2 version 2.1.210 droping public table on its own

Hi all, Recently I have migrated my h2db from verison 1.4.192 to 2.1.210. Every thing works wells and application is started with h2db.mv.db version 2. After some time I noticed that h2 deletes some of the tables by its own. In total I had 14 tables but after some time only 9 remains and 5 got

[h2] h2 trigger

Hi, i want to use a trigger. I have a JUnit test class in my eclipse project where i open a connection to the h2 database file and query tables and so on. In the same package as the JUnit test class i have a public class implementing the Trigger interface. The connection url to the database fil

Re: [h2] H2 Running problem

On Thu, 2022-04-28 at 09:49 -0700, Kristóf Sándor Vad wrote: > The problem is that after installing neither the console or the > command line doesn't seem to work. Greetings, that's a bit generic and you will need to provide many more details please: 1) How to you start the H2 server (e.g. java

[h2] H2 Running problem

Hi all, I've got a problem starting the H2 Database Console. The problem is that after installing neither the console or the command line doesn't seem to work. I can't figure out because there's nothing about this problem on the internet. If there would be someone who could help me out with thi

[h2] H2 DB Access Denied Error after Uprade to v2.1.210

After upgrading to v2.1.210 facing issue of access denied error and not creating .mv.db file. Below is the error message database: opening C:\Program Files\nt\nt-h2-store org.h2.message.DbException: IO Exception: "java.nio.file.AccessDeniedException: C:\\Program Files\\nt"; -- You received this m

[h2] H2 in LibreOffice Base

Hi all, I'm trying to write a JDBC driver for LibreOffice Base and I'm having trouble getting autoincrement keys working with H2 in Base. I managed to make it work with Derby and HsqlDB but not with H2... Maybe someone has some ideas for me? Thank you.

[h2] H2 in LIbreOffice Base

Hi all, I'm trying to write a JDBC driver for LibreOffice Base and I'm having trouble getting autoincrement keys working with H2 in Base. I managed to make it work with Derby and HsqlDB but not with H2... Maybe someone has some ideas for me? Thank. --

[h2] H2 Database Engine: New version released

Hello, A new version 2.1.212 of H2 is available at http://www.h2database.com (you may have to click 'Refresh'). It will be available in Maven repository shortly. For details, see the 'Change Log' at http://www.h2database.com/html/changelog.html P.S. If you reply to this message please use a dif

[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 unsubsc

Re: [h2] H2 DB Temp File is created on separate drive

Thanks! That's exactly what I needed. On Wednesday, February 2, 2022 at 1:26:10 PM UTC-6 Noel Grandin wrote: > You'd have to modify how the java VM chooses where to put temporary files. > There are various ways to do that depending on how you want to control it, > but at minimum it would have t

Re: [h2] H2 DB Temp File is created on separate drive

You'd have to modify how the java VM chooses where to put temporary files. There are various ways to do that depending on how you want to control it, but at minimum it would have to apply to that whole java process, -- You received this message because you are subscribed to the Google Groups "H2

[h2] H2 DB Temp File is created on separate drive

I am using an embedded H2 DB (v2.1.210) in a Windows Server 2016 environment. I have the database configured to use a jdbc URL with a relative path from a location on the D: drive (jdbc:h2:../data). I have a query with a large result set that seemed to be hanging. Upon further investigation, i f

[h2] H2 2.1.210 SQL output of SCRIPT not backward compatible with 1.4.200

Hello all, Executing SCRIPT TO command from H2 2.1.210 generates an SQL file that can not be processed by an application using 1.4.200. The culprit seems to be that in INSERT statements UUID values are exported in their hex-string format prefix by the UUID keyword. So it looks like UUID 'x

[h2] 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 'Refresh'). For details, see the 'Change Log' at http://www.h2database.com/html/changelog.html P.S. If you reply to this message please use a different subject. Have fun, Andrei Tokar -- You r

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

Hi there, first of all thanks to H2! It helps a lot in projects especially in local development setups. In my project junit tests manages their own test data and I let the databasemodell be generated by JPA in test scope, so I have no special *.sql file around (on which I can apply any syntax

Re: [h2] 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:52:09 UTC henning...@gmail.com wrote: > The problem is in Spring JDBC: > https://github.com/spring-projects/spring-framework/pull/27870 > > It will be fixed in release 5.3.15 which should be rel

Re: [h2] H2 v2.0.206 support for NEXTVAL

The problem is in Spring JDBC: https://github.com/spring-projects/spring-framework/pull/27870 It will be fixed in release 5.3.15 which should be released latest next week. Am Mi., 12. Jan. 2022 um 13:16 Uhr schrieb Paul Denby : > Overriding Spring Boot h2.version to 2.0.206 (from 1.4.200) throws

[h2] H2 v2.0.206 support for NEXTVAL

Overriding Spring Boot h2.version to 2.0.206 (from 1.4.200) throws an error Column \"TABLE1_ID_SEQ.NEXTVAL\" not found in the following SQL which worked previously: CREATE SEQUENCE table1_id_seq; CREATE TABLE table1 ( id integer default table1_id_seq.nextval NOT NULL UNIQUE, versionid integ

[h2] 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 'Refresh'). It contains a patch for H2 console security issue: https://github.com/h2database/h2database/security/advisories/GHSA-h376-j262-vhq6 For details, see the 'Change Log' at http://www.h2da

Re: [h2] 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 STUFF_DETAILS SD on S.ID = SD.ID inner join STUFF_MORE_DETAILS SMD on SD.ID = SMD.ID Regards, Guillaume Le mer. 29 déc. 20

[h2] H2 (1.4.200) seems to misinterpret a valid join clause

Folks, Please consider the following schema. There is nothing really special about it. ``` create table STUFF ( ID number(19) generated by default as identity (start with 1 increment by 1), NAME varchar2(128) not null, constraint PK_STUFF primary key (ID), constraint BK_STUFF uni

[h2] H2 Database Engine: New version released

Hello, A new version 2.0.204 of H2 is available at http://www.h2database.com (you may have to click 'Refresh'). For details, see the 'Change Log' at http://www.h2database.com/html/changelog.html P.S. If you reply to this message please use a different subject. Have fun, Andrei Tokar -- You r

[h2] H2 Performance Windows vs Linux

Greetings, incidentally I stumbled over a performance comparison related to H2 on Windows vs Linux:  https://www.phoronix.com/scan.php?page=article&item=ryzen7pro-windows-linux&num=3 The difference looks relevant to me and I am curios to ask: Any idea why there is such a difference? I would actu

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

Thanks for the new release! I needed two changes when upgrading 1: I had a few tables with a column called "value" and had to add ;NON_KEYWORDS=VALUE to my jdbc connect string. 2: In a table with a column of type "text" I have in in 1.4.200 been able to set the content in a preparedStatement u

[h2] H2 2.0.202 table metadata tabletype is "BASE TABLE" instead "TABLE"

Hello, congratulations and many thanks for the new H2 release. I started to migrate some applications and found the following changed behaviour: - CREATE TABLE TEST_1 (MY_COL CHARACTER VARYING(10)) - Get the table type per JDBC: - rs = connection.getMetaData().getTables(...); rs.next()

[h2] H2 Database Engine: New version released

Hello, A new version of H2 is available at http://www.h2database.com (you may have to click 'Refresh'). For details, see the 'Change Log' at http://www.h2database.com/html/changelog.html P.S. If you reply to this message please use a different subject. Have fun, Thomas -- You received thi

Re: [h2] H2 Connection leaks in application logs

somewhere you are leaking connections i.e. forgetting to return them to the pool -- 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] H2 Inmemory not able to load 7lc records and giving heapspace issues

try using nioMemFS to store the data on the native heap -- 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 dis

[h2] H2 Inmemory not able to load 7lc records and giving heapspace issues

Hi , I have an Inventory application created in Quarkus framework with AWS RDS Db. I configured H2 inmemory db with the application for faster performance. on my local inventory table in RDS Db was having 1 lc records so h2 inmemory while startup of application was building this table in memor

[h2] H2 function alias - ClassNotFoundException

Hello, I have some issues with a function. I'm almost sure it is a "user error" somewhere in my setup, however cannot determine it yet. Will try to explain. I have an integration tests which boots up an Apache Karaf and executes commands on it via SSH. This Karaf is connected to an H2 database

[h2] H2 doesn't work properly with @ManyToMany in test profile

Hey Folks! How are you all doing? I found a problem and a temporary solution in my project. But now, I need to definetly solve the problem. I am noob here. But I intend to contribute a lot in this group. Let's go to my question: I have a Spring Boot project that contains two classes with a Man

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 appeared > > java.util.concurrent.ExecutionException

[h2] H2 Database not support materialized?

When my SQL contains materialized, some exception appeared java.util.concurrent.ExecutionException: org.springframework.jdbc.BadSqlGrammarException: ### Error querying database. Cause: org.h2.jdbc.JdbcSQLSyntaxErrorException: Syntax error in SQL statement "with temp_table as materialized[*]

[h2] H2 / TCP over SSL setting truststore system property alternatve

Hi, We are using H2 in remote mode over TCP/SSL. To achieve the SSL handshake we are setting system property* javax.net.ssl.trustStore* and *javax.net.ssl.trustStorePassword* Is there any alternative to setting the system property and provide a SSLContext to the H2 client org.h2.engine.Sessio

[h2] H2 EOL Versions?

I am trying to find out if there are any end-of-life versions for H2, and if so, when do these versions typically become EOL/unsupported in terms of security? If this information is publicly stored anywhere please let me know. Thanks. -- You received this message because you are subscribed t

[h2] H2 Database Linked table Performance

Hello, I have general question around Linked Tables of H2 Database: 1. How does Linked Table work? When i create a Linked Table in H2 Database - does it continuously monitor the actual database table that it is linked to - for changes? and if changes are identified does it deletes all records

[h2] H2 to Oracle migration

Hello Friends, We wanted to migrate H2 database to Oracle. Does anyone performed this in past? any documentation? Your inputs will be much appreciated. Thanks Dipesh Tamore -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from

Re: [h2] H2 1.4.200: Random JRE crash

H2 does not use any native code at all, so if you are seeing crashes you either have a dodgy machine, or are unlucky enough to have found a bug in the Java VM. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and sto

[h2] H2 1.4.200: Random JRE crash

Hello, I have an application using H2 v1.4.200, and I see random but frequent jre crash when the application starts. Every crash seems to point at H2, see an example below. I reproduce this issue with windows 10 and jdk11, but less frequently on windows 7 with a jdk 8. Is it a known issue ? a

Re: [h2] H2 Procedural SQL language efforts

I don't see the point. We have a perfectly good language already (Java), and even a built-in compiler for it. -- 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

[h2] H2 Procedural SQL language efforts

Hi all, Could someone tell me please is there any efforts about implementing Procedural SQL Language functionality? Maybe some roadmap exists somewhere about it? -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and

[h2] H2 in-memory DB performance

Hi all, I'm using H2 as an in-memory cache in a long-running server application. Are there any guidelines on configuring H2 for such use, with the primary goal being low latency for queries? I'd like to bring performance as close as possible to say, scanning some in-memory collections using an

[h2] H2 cluster with 3 nodes

Hello all: Is it possible to create a cluster of 3 nodes in H2? This question was asked few years back, I am not sure if it resolved. Thanks in advance, Vidhya -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and s

Re: [h2] H2 as read-only cache, strategy for refresh

I have used h2 as cache for analytics query. This is working very well. Things to consider - manage connection pool and make sure you keep atleast 1 open - when doing changes use copy on write pattern to avoid any slowness on read query. Disk are very cheap! - disable all the index before large

Re: [h2] H2 as read-only cache, strategy for refresh

Looks like a good strat. For people coming from a search engine, here's the command to rename a table: http://h2database.com/html/commands.html#alter_table_rename On Fri, Jun 26, 2020 at 4:47 PM Noel Grandin wrote: > last line should have been > > "rename new table to proper name" > > -- > You

Re: [h2] H2 as read-only cache, strategy for refresh

last line should have been "rename new table to proper name" -- 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 th

Re: [h2] H2 as read-only cache, strategy for refresh

create new table from CSV drop old table rename old table to new table -- 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.

[h2] H2 as read-only cache, strategy for refresh

Hi, I want to use H2 in-memory as a read-only cache in front of a larger database. This cache will hold about 20 tables, a total of 1Gb, and should be refreshed every 15 minutes.The fresh data will be available as a CSV file, so H2's creation from CSV is attractive: http://h2database.com/html

[h2] H2 GIS - How to use multiple Geometry for st_within

Hi , I have a collection of lat/longs , i want to find out if what all belongs to Geometry B and what all not belongs to Geomentry B.. I have given below example, Here i have array of lat/longs,. Instead of iterating each and every lat/longs and executing query every time ,finding out if it is

[h2] H2 in-memory database error “Data conversion error while using GEOMETRY" (JdbcSQLException: Data conversion error converting)

Hi, I am getting below error while loading GeoJson into H2 table . I am using java . Please help. a8155d5f4049c052934acaff7ff87371007e0020bfc3e16d6dc1a47b4049c054477ff1527ff8' (CZONE: THE_GEOM GEOMETRY )"; SQL statement: **INSERT INTO "CZONE" VALUES(?,?,?,?) -- (?1,

Re: [h2] H2 AUTO_SERVER failed when using two JVM's

I idiot should have appended the files... Am Samstag, 29. Februar 2020 16:58:44 UTC+1 schrieb Frank Berger: > > Hi Thomas, > > I can reproduce it. I know for sure that it worked, because I tested it > some years ago but now it fails, but I have no idea since when. > > To reproduce the issue I h

  1   2   3   4   5   6   7   8   >