[h2] what data is removed during DEFRAG

My databases (mvstore) are growing rapidly, much more than I would expect based on the entered data. I also see CPU usage increasing. Performing a DEFRAG reduces the database size significantly, sometimes by 60-70%. Running SCRIPT TO / RUNSCRIPT also has a similar effect. How can I identify

[h2] Can aliases made by CREATE ALIAS , be retrieved by SQL?

Can aliases made by CREATE ALIAS , be retrieved by SQL? could not find any documentation about this also seached the system tables without any result. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and

[h2] Re: what about *.mv.db files

forget this question. The files mentioned are empty databases. They still cause an exception during backup (duplicate entry) Op zaterdag 27 april 2024 om 09:44:00 UTC+2 schreef Rinse Lemstra: > Just moved to mvstore. After conversion in some directories there is a > *.mv.db file, al

[h2] what about *.mv.db files

Just moved to mvstore. After conversion in some directories there is a *.mv.db file, all have the same size ~ 20k. These mv.db files cause an exception while making a backup. What are these files? -- You received this message because you are subscribed to the Google Groups "H2 Database"

[h2] how much indexes are used for optimization

from the H2 website: If a table has multiple indexes, *sometimes more than one index could be used.* Example: if there is a table TEST(ID, NAME, FIRSTNAME) and an index on each column, then two indexes could be used for the query SELECT * FROM TEST WHERE NAME='A' AND FIRSTNAME='B', the index

[h2] Using field value as part of expression??

Suppose the field 'Abbr' does contain the value "ABC" and here is also a field with the name "ABC_budget". Is there an SQL expression possible to get the value of field ABC_budget using the contents of field Abbr ? Thanks in advance -- You received this message because you are subscribed to

[h2] Unexpetced result when calculate with fields

Hi, For this test I use this table: drop table if exists test; create table test(minutes numeric(12,2)); insert into test values(1200); select sum(minutes)/60 from test; When I execute this I get as result 2E+1. How can I get a more readable output? -- You received this message because you

[h2] suggestion/feature request CSVREAD respect column names

with CSVREAD one can insert/merge records from a .csv file. Although the csv file does containt column names, they are not respected. Wouldn't it be nice if CSVREAD could respect these column names while importing the data? regards, Rinse -- You received this message because you are

[h2] Can INFORMATION_SCHEMA be used to find last_modified of a table

I am looking for a fast way to determine the last_modified of each table. I found the LAST_MODIFIED column in INFORMATION_SCHEMA\TABLES, however this field is allways 0 Is there any way to use the INFORMATION_SCHEMA to quickly find the tables wich are modified since a specific timestamp ?

[h2] Re: Recovery of encrypted databases

Realy no one has experience with recovery of encrypted databases ? Op dinsdag 29 mei 2018 09:25:04 UTC+2 schreef Rinse Lemstra: > > Until now we have used UnEncrypted databases. Every now and then we need > the recovery tool to repair a corrupted database, succes rate ~98%.

[h2] Recovery of encrypted databases

Until now we have used UnEncrypted databases. Every now and then we need the recovery tool to repair a corrupted database, succes rate ~98%. We do considder using database encryption. What can be said about the succes rate of using the recovery tool on encrypted databases ? regards, Rinse

[h2] SET MODE MSSQLSERVER

not sure what to expect from this. Can a H2 server in MSSQLSERVER mode replace a M$ SQL server ? (so clients only able to connect with M$ can work with H2) ? regards, Rinse -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from

[h2] Re: What will happen if......

.4.190.jar:1.4.190] at org.h2.jdbc.JdbcConnection.(Unknown Source) ~[h2-1.4.190.jar:1.4.190] at org.h2.jdbc.JdbcConnection.(Unknown Source) ~[h2-1.4.190.jar:1.4.190] at org.h2.Driver.connect(Unknown Source) ~[h2-1.4.190.jar:1.4.190] Op dinsdag 8 november 2016 14:21:49 UTC+1 schreef Rinse Lemstra: &

[h2] What will happen if......

We open our database with: Connection connection = new org.h2.Driver().connect(“jdbc:h2:file:\\Data;FILE_LOCK=FILE;AUTO_SERVER=TRUE;MODE=REGULAR;MV_STORE=FALSE;DB_CLOSE_DELAY=0", new Properties() ); We close our database with: connection.close(); What will happen if the

[h2] Is there a fast and reliable way to test if an index up-to-date

Some users of our application who have choosen to use the AUTO_SERVER option, do experience index-curruption every now and then. We think there are two approches to this problem: 1st, avoid the corruption and 2nd minimize the effects by detecting curruption. Is there a fast and reliable way

Re: [h2] Error when connencting to tcp server (when using auto_server)

necessary must be unnecessary Op dinsdag 19 april 2016 14:35:18 UTC+2 schreef Rinse Lemstra: > > It looks necessary and might hide a bug > > Op dinsdag 19 april 2016 11:59:08 UTC+2 schreef Noel Grandin: >> >> If the connection works, why do you care? >> > --

Re: [h2] Error when connencting to tcp server (when using auto_server)

It looks necessary and might hide a bug Op dinsdag 19 april 2016 11:59:08 UTC+2 schreef Noel Grandin: > > If the connection works, why do you care? > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop

Re: [h2] Database size keeps growing when creating and deleting CLOBs

Is SCRIPT TO / RUNSCRIPT not more or less the same ? regards, Rinse > > -- 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] H2 DB in Auto Server Mode

Op dinsdag 6 oktober 2015 07:45:03 UTC+2 schreef Thomas Mueller: > > Hi, > > Yes it should work. I'm wondering which shared file system you use? > > Regards, > Thomas > There are versions of SMB witch use caching. On these versions it can take up to 10 seconds before a new file becomes visible

[h2] Is there a way to detect ' rowCount expected' corruptions ?

Now these corruptions can appear everywhere in my program, I would like te test for this corruption after opening the database. Is there a light weight solution for this ? Thanks in advance, Rinse -- You received this message because you are subscribed to the Google Groups "H2 Database"

[h2] ALTER TABLE DROP COLUMN does not support multiple columns

Hello, Is it correct that ALTER TABLE DROP COLUMN does not support multiple columns in one statement ? As I have to drop more then one column in a rather large table it would be very efficient to do this in one statement. regards, Rinse -- You received this message because you are

[h2] Is there a setting for letting null and empty values sort equal

Now empty fields and null values are sorted in two groups. Is there a setting or command to let both values sort equaly ? regards, Rinse -- You received this message because you are subscribed to the Google Groups H2 Database group. To unsubscribe from this group and stop receiving emails

Re: [h2] Is there a setting for letting null and empty values sort equal

mean by empty fields? On 18 Jun 2015 19:29, Rinse Lemstra r.le...@xso.nl javascript: wrote: Now empty fields and null values are sorted in two groups. Is there a setting or command to let both values sort equaly ? regards, Rinse -- You received this message because you

[h2] Can I controll the index usage ?

The query below takes about 5 sconds to run select uren.MEDEW_ID as MEDEW_ID, uren.START as UREN_WEEK, sum(uren.DUUR) as DUUR from uren as uren where uren.START = '2015-05-25' and uren.START '2015-06-01' and *uren.type = 0* group by uren.MEDEW_ID, UREN_WEEK When I remove the *uren.type =

Re: [h2] Can I controll the index usage ?

query's (with filters on TYPE) witch are not related to START. regards, Rinse On 2015-06-04 10:16 AM, Rinse Lemstra wrote: The query below takes about 5 sconds to run select uren.MEDEW_ID as MEDEW_ID, uren.START as UREN_WEEK, sum(uren.DUUR) as DUUR from uren as uren where

Re: [h2] Can I controll the index usage ?

Op donderdag 4 juni 2015 10:59:28 UTC+2 schreef Stig Christensen: Just add two indexes I tried, then H2 prefers using the single index and is slow again. -- You received this message because you are subscribed to the Google Groups H2 Database group. To unsubscribe from this group and

Re: [h2] Could data corruption being caused by non-accurate .lock.db information ?

Ok, certain versions of windows do have this behaviour, see: https://groups.google.com/forum/?utm_source=digestutm_medium=email#!topic/h2-database/w65UQETmo7U Rinse Op donderdag 22 januari 2015 21:36:09 UTC+1 schreef Thomas Mueller: Hi, on some windows-version the .lock.db file is not

[h2] Could data corruption being caused by non-accurate .lock.db information ?

What could be the result if H2 thinks it is the first user ( no .lock.db file ), but in reality some other user opened the database just before ? (on some windows-version the .lock.db file is not visible for remote connections for up to 10 seconds) regards, Rinse -- You received this

[h2] Re: Database corruption after upgrade to 1.3.176 (from 1.3.169)

Today put a new version of our product live, containing 1.4.184 in a AUTO_SERVER scenario. Got serveral exceptions not seen before: Caused by: org.h2.jdbc.JdbcSQLException: Error opening database: \Concurrent update\ [8000-184] org.h2.store.FileLock.getExceptionFatal(Unknown Source)

[h2] Directory caching on SMBv2 shares

We recently had an issue where backup.zips made by H2 where not visible to remote clients for some time (up to 10 seconds) We now found the reason for this behaviour, it is caused by directory caching of windows running the SMBv2 protocol. see:

[h2] What would be the best update-candidate

Hello, We are currently using version h2-1.3.176 In AUTO_SERVER mode we experiece corruption of various kinds: index not found 202 File corrupted while reading record: \[1280] stream data key:1344 pos:11 remaining:0\. rowCount expected 11462 got 11466 What would be the best / most

Re: [h2] What would be the best update-candidate

Connecting to H2 database: jdbc:h2:file:c:\TimeWriter5Std\lib\..\data\xso_standard\default\Data.std.h2.db H2 properties: {AUTO_SERVER=TRUE, MODE=REGULAR, CACHE_SIZE=16384, DB_CLOSE_DELAY=0, IGNORECASE=TRUE, DATABASE_TO_UPPER=TRUE} Does this make sense ? regards, Rinse -- You received

Re: [h2] What would be the best update-candidate

problematic in your settings. Probably the best update-candidate is 1.4.184, but add MV_STORE=false to your URL to keep using the old(stable) storage engine. On 2015-01-09 10:23 AM, Rinse Lemstra wrote: Connecting to H2 database: jdbc:h2:file:c:\TimeWriter5Std\lib\..\data\xso_standard

[h2] What is kept in PageStores and when is it released ?

We have put a new (H2-based) product live. Now the numbers of users are growing, the memory consumption also grows. JVisualVM learns us that the top 20 memory consuming objects are org.h2.store.PageStore#xx and org.h2.util.CacheLRU#xx Could someone explain what is kept in these objects ?

Re: [h2] Backup.zip not immediately available

you know the file is not available (does the file not exist, is the size incorrect,...)? Regards, Thomas On Thu, Dec 11, 2014 at 9:39 AM, Rinse Lemstra r.lems...@xso.nl wrote: I have a database connection made with the URL below jdbc:h2:file:D:\TW\lib\..\data\xso_standard\default

Re: [h2] Backup.zip not immediately available

describe what you do exactly (how you create the backup, how you copy it)? How do you know the file is not available? Regards, Thomas On Sunday, December 7, 2014, Rinse Lemstra r.le...@xso.nl javascript: wrote: We found that a backup.zip is not immediately ready for copying after creating

[h2] Backup.zip not immediately available

We found that a backup.zip is not immediately ready for copying after creating the backup, it can take up to 5 seconds before the backup.zip is available. This behavior does not occur in all situations, it only occurs if the database is located on a share on a server, it may be related

Re: [h2] how to become a donor

Hi Thomas en Noel, Thanks for your response... The key point of my message was: I think it would help if there was an email address for paypal donations... In other words: I want to become a donor, but I don't know wich email-address to use for my donation. regards, Rins -- You

[h2] how to become a donor

The H2 website does contain a list of donors, however there is no information on how te become a donor I think it would help if there was an email address for paypal donations... regards, Rinse -- You received this message because you are subscribed to the Google Groups H2 Database

[h2] Server side cursors

Server side cursors could be a usefull feature for our product. In the roadmap I see it has priority 1 on the current version. Just for sake of our internal planning: in what therms of time could we expect first results of this feaure ( weeks, month, years ?) regards, Rinse -- You

Most efficient way to duplicate tables

I have to ( frequently ) duplicate tables to another database, what is the most efficient ( and generic) way to do so ? Found the Create table [table] as Select way, however this does not duplicate the indexes... regards, Rinse Lemstra -- You received this message because you

Best approach for using H2 over public internet

What would be the best approach to use H2 over a public internet, in terms of stability and performance ? Wrapping JDBC in a compression-class ? Serverlets ? .? Thanks in advance, Rinse -- You received this message because you are subscribed to the Google Groups H2 Database group.

infinite loop when using user defined variables

Hello, While researching a performance issue when using user defined variables ( @variable ) I ran into a infinite loop. Running the query below without a variable the query runs in a few miliseconds. When running it with a user define variable the server runs for several hours. The EXPLAIN

Optimize joins ?

In our application we have defined skeleton query's where we add/ replace some clauses when the query is executed. Example: Select [fields] from MasterTable left join detail1 as Stem1 on MasterTable.id1 = Stem1.id left join detail2 as Stem2 on MasterTable.id2 = Stem2.id left join

Website question

When visiting the website ( h2database.com ) with IE8 I am not able to select text and copy it to the clipboard. Only selecting all text (Ctrl-A) does work. I found that the line below does cause this behaviour. td class=nav style=cursor: e-resize; onmousedown=return mouseDown(event)

off-line download

Zipped versions of the pages and files associated with this group will be available for download until August 31, 2011. After this date, this feature and the zip file downloads will be turned off permanently. Download pages | Download Files When I try to download these files, they appear to have