[h2] Move from Google Code to GitHub

Hi, You may have read already that Google Code will shut down. That means the source code of H2 will be moved, most likely to GitHub. This move will happen shortly, in the next weeks or months (not sure exactly when). Most likely this will be under http://github.com/thomasmueller Issue tracking w

Re: [h2] Transaction performance

Hi, I can't explain this. Could you send us a simple, reproducible test case please? If possible using the JDBC API and no dependencies. Regards, Thomas On Thursday, March 12, 2015, wrote: > Hi there, > > I'm having a test environment with the following situation. > I'm using the embedded vers

Re: [h2] Effective way to retrieve the content of a large table

Hi, At some point, server side cursors will be implemented, then you will just have to run "select * from tableName" and you are done. This will require some changes however; it can not be supported when using the PageStore. I expect it will take a while until this is available. we are caching _

Re: [h2] Persistent to In-memory Database

Hi, > but this doesn't work. We would need more details. Regards, Thomas On Thursday, March 12, 2015, Jason wrote: > I'm currently using H2 as a persistent datastore, but would like the > ability to use in-memory mode. > > I tried updating the connection string from *jdbc:h2:[filename]* to >

Re: [h2] curious join result

Hi, This is now fixed (in the trunk). Regards, Thomas On Thursday, July 3, 2014, Thomas Mueller wrote: > Hi, > > select * from table(a int = (1,2,3)), table(b int = (3,4,5)) >> > > In this case, both tables have the name "table", and H2 gets confused. I > c

Re: [h2] JDBC driver for a Windows based client

Hi, Maybe you mean ODBC? JDBC does not support or need a dll file. Regards, Thomas On Wednesday, March 11, 2015, Faraz Hasan Rizvi wrote: > Hi, > > I am trying to connect a vendor application to H2 via JDBC. The > application has both Linux and Windows versions. > > The Windows based version

Re: [h2] db deadlocked until ui takes focus

Hi, You need to tell us which version of H2 you are using. Otherwise the stack trace doesn't help. Also, please post a few (multiple) few full thread dumps instead of just one. Regards, Thomas On Wednesday, March 11, 2015, Brian Craft wrote: > I'm at a loss to explain this behavior. Wondering

Re: [h2] I want to build a shared table based on TableLink, any ideas ?

Hi, Sorry I don't understand the use case. A shared table is only route the query to correct table > What is a "shared table"? You want to "correct the table", or query "the correct table"? When do you know the table, and when don't you know it and why don't you know it? > ,do not store any da

Re: [h2] INSERT ... ON DUPLICATE KEY UPDATE with specified schema not working

nd line: $> groovy example.groovy > My current environment is: Groovy Version: 2.1.6 JVM: 1.8.0_05 > > Best, > Alessio > > > Il giorno domenica 1 marzo 2015 01:58:35 UTC-8, Thomas Mueller ha scritto: >> >> Hi, >> >> Could you provide a complete,

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

Hi, It would be nice if that's supported, however I think it's not easy to change. Patches are welcome! Regards, Thomas On Friday, January 30, 2015, wrote: > > At this time FILE_LOCK=FS is not supported when using AUTO_SERVER=TRUE; > > It generates an error: > org.h2.jdbc.JdbcSQLException: Fea

Re: [h2] MVStore - Statistics

Bytes and readBytes will be included in the new table, maybe would > be better remove info.FILE_WRITE and info.FILE_READ from settings meta > table. > > Regards, > > Fred > 2015-03-11 4:45 GMT-03:00 Thomas Mueller >: > >> Hi, >> >> I'm OK to use a

Re: [h2] Referential integrity violation on delete

Hi, For problems with Hibernate, it's probably better to ask at StackOverflow.com. Maybe you want to test with another database as well, for example Apache Derby or PostgreSQL. We would need a simple, reproducible test case. If you are using Hibernate or another ORM tool, you could append ";trace

Re: [h2] MVStore - Statistics

Hi, I'm OK to use a new table name. I'm not sure what is the best name for this table. Most of the data is "raw", so it's not really statistics just yet. Sure, it can be used to generate statistics. Maybe "metrics"? What do other databases or storage systems use for this case? Regards, Thomas

Re: [h2] DateDiff behavior

Hi, What timezone do you use (TimeZone.getDefault().getID())? My timezone is "Europe/Zurich". I tested with the latest version (trunk), and got "11" in all cases. Could you test with the latest version as well? Regards, Thomas On Tuesday, March 10, 2015, Wendell Rios wrote: > Hi, > > I've

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

Hi, The "FileLock" is the mechanism to ensure only one process accesses the database file. If there is a "concurrent update" exception, the problem is most likely a file system that is not supported by this mechanism. I think operating system file level locking is required, and the FileLock mecha

Re: [h2] No database in the Console

Hi, One way to debug is to look at the stack trace, and then set a breakpoint there, and then check what the parameters / variables are. Regards, Thomas On Thu, Mar 5, 2015 at 11:46 AM, Max Telfer wrote: > Hi again > > I get the same result with any browser - Chrome, IE, Firefox. This used

Re: [h2] Error updating database. Cause: org.h2.jdbc.JdbcSQLException: Timeout trying to lock table ;

Hi, Well the error message says timeout, are sure it is not a timeout? Regards, Thomas On Tuesday, January 27, 2015, wrote: > I am using the H2 1.4.185. > > The url is jdbc:h2:tcp:// > 127.0.0.1/activiti?TRACE_LEVEL_FILE=4;WRITE_DELAY=10;CACHE_SIZE=4096;MAX_COMPACT_TIME=5000 > ; > > ### Er

Re: [h2] I want to build a shared table based on TableLink, any ideas ?

Hi, I'm not sure what features you want to add so I can't be certain, but I think it is possible. I suggest to read all the documentation about linked tables. Then, you may want to read (part of) the implementation of that feature. It is probably more complex for what you need. Regards, Thomas

Re: [h2] DROP in SCRIPT command don't drop sequences

EQUENCE_TEST START WITH 1 BELONGS_TO_TABLE [90035- > 185] > > > According to documentation, SCRIPT DROP should > >> drop statements are created for tables, views, and sequences. >> > > I'm doing something wrong? > > Thanks > > > Il

[h2] BUG,use single quote in jpa column name will not woke correctly.

Hi, I don't know where it is converted to lowercase, so I'm afraid I can't help here. However, I would not use the column names "FROM" and "TO" (quoted or unquoted). Regards, Thomas On Sun, Mar 8, 2015 at 7:09 PM, wener > wrote: > @Data > @Accessors(chain = true, fluent = true) > @Entity > @T

Re: [h2] MVStore - Statistics

Hi, That sounds like a good idea! On the API side, I would probably make it a key-value list, by extending the existing table information_schema.settings. Otherwise the table will get a *lot* of columns if we add other data. Of course, the problem of a key-value list is that the datatype for both

Re: [h2] java embedded h2 questions

Hi, You would need to use the server mode, or the automatic mixed mode. Regards, Thomas On Saturday, January 31, 2015, Peter Cheung wrote: > Hi > I use java the start connect to h2 using jdbc. Because all threads in > java are in one single process. So I can connect to the H2 concurrently.

Re: [h2] grouped by timestamp

Hi, Such questions are typically best asked at StackOverflow.com. You would need a function that converts the timestamp to a value with a 5 minute delay. Regards, Thomas On Wednesday, January 14, 2015, Hannes Hörting wrote: > Hello! > > I write each minute in the databse: > timestamp ; uid ;

[h2] getParameterMetaData data type is not valid for LIMIT ? clause

Hi, I agree this is incorrect. A patch is welcome. However, could you explain what problem you want to solve? Regards, Thomas On Mon, Mar 9, 2015 at 11:20 AM, Vojtěch Hordějčuk < vojtech.hordej...@gmail.com > wrote: > update: the same behavior applies to OFFSET ? > > Dne pondělí 9. března 201

[h2] No database in the Console

; > The URL and Console fields are in the original post. What should it be? > > Thanks > > Max > > > On Wednesday, March 4, 2015 at 5:43:31 PM UTC+11, Thomas Mueller wrote: >> >> Hi, >> >> If the message is really >> >

Re: [h2] MVStore.cacheChunkRef memory usage

rtTrue("" + test.getUsedMemory(), test.getUsedMemory() <= 4); +} + private void testScanResistance() { boolean log = false; int size = 20; On Wed, Mar 4, 2015 at 7:30 PM, Thomas Mueller wrote: > Hi, > > Thanks a lot for the test cases and the p

Re: [h2] MVStore.cacheChunkRef memory usage

hat reproduces the problem and I reviewed my previous > patch that try to reduce the memory below of the limit. It passed in the > regression tests too. > > Regards, > > Fred > > > > 2015-02-27 16:42 GMT-03:00 Thomas Mueller >: > >> Hi, >> >> OK

Re: [h2] Show indexes

Hi, The H2 Console supports special syntax, see h2database.com/html/tutorial.html#console_syntax - example: @index_info null null TEST; Regards, Thomas On Monday, March 2, 2015, Cecil Westerhof wrote: > 2015-03-02 12:12 GMT+01:00 Noel Grandin >: > >> There isn't one. If you want that info

Re: [h2] Re: Connection error - H2 Database Engine: New version 1.4.186

ble.java:83) >> at org.h2.store.PageStore.addMeta(PageStore.java:1696) >> at org.h2.store.PageStore.readMetaData(PageStore.java:1627) >> at org.h2.store.PageStore.recover(PageStore.java:1405) >> at org.h2.store.PageStore.openExisting(PageStore.java:367) >> at org.h2.store.Pa

Re: [h2] NPE/performance degradation with version 1.4.185?

Hi, Could you please re-try with the latest version (1.4.186)? A memory leak was fixed there, which could also cause performance problems with a large (well, medium size) database. If it is still a problem, then could you please post a test case (or describe what you do in more details)? Regards,

Re: [h2] No database in the Console

Hi, If the message is really java.sql.SQLException: No suitable driver found for at java.sql.DriverManager.getConnection(Unknown... then your database URL is empty (an empty String). Regards, Thomas On Tuesday, March 3, 2015, Max Telfer wrote: > Hi > > I have posted this before. I am

[h2] H2 Database Engine: New version 1.4.186 available

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 For future plans, see the 'Roadmap' page at http://www.h2database.com/html/roadmap.html Please note the jar

Re: [h2] MySQL compatibility: ORDER BY NULL

Hi, That should already work. Regards, Thomas On Thu, Feb 19, 2015 at 2:37 PM, Vojtěch Hordějčuk < vojtech.hordej...@gmail.com> wrote: > Hello, I recently found that certain queries I have to deal with contain > the ORDER BY NULL clause, which were used by old MySQL to optimize > performance.

Re: [h2] $$ causes syntax error in CREATE ALIAS AS

as I have > encountered similar problems recently. But now I use single quotes. > > Dne středa 16. října 2013 17:37:15 UTC+2 Thomas Mueller napsal(a): >> >> Hi, >> >> I guess the "SQuirreL client" thought that the statements ends at the >> ";&qu

Re: [h2] INSERT ... ON DUPLICATE KEY UPDATE with specified schema not working

Hi, Could you provide a complete, simple, reproducible test case please (I set of SQL statements, including "create table" and so on)? Regards, Thomas On Sat, Feb 21, 2015 at 2:08 AM, Alessio Della Motta < alessio.dellamo...@gmail.com> wrote: > I'm getting an error trying to execute an INSERT .

Re: [h2] Automatic version column

Hi, I think "computed columns", combined with sequences, should do what you want: http://h2database.com/html/features.html#computed_columns drop all objects; create sequence address_version; create table address( id int primary key, name varchar, version int as next value for address_

Re: [h2] Problem using Maven to spawn H2 DB with Triggers

Hi, I think you should ask the question on the Maven side, not on the H2 side. Please note the next version of H2 will allow declaring triggers as source code. This should solve the problem as well (but I didn't test this feature so far). Regards, Thomas On Wed, Feb 25, 2015 at 8:41 PM, llauri

Re: [h2] Fail to stop database while executing 'BACKUP TO' query

Hi, What you could do is use a custom file system implementation for the backup target. See http://h2database.com/html/advanced.html#file_system - there are quite a few file system implementations available in the H2 source code. That way, you can throw an exception in the file system (when stori

Re: [h2] Operator precedence

Hi. > > What do you mean by that? Is it available or should it be? If available, > could you point me where to look at that page? > > Br, > Timo > > On Friday, February 27, 2015 at 9:19:49 PM UTC+2, Thomas Mueller wrote: >> >> Hi, >> >> This sho

Re: [h2] Is it safe and reasonable to open a read-only database in embedded mode from two processes without locking?

Hi, I don't recommend to use this mode. If all processed access the database in read-only mode, then it should work. But if there is one process that updates the database, then the reading processes might not work correctly, or not at all. And you can't really protect against this as far as I see

Re: [h2] MVStore.cacheChunkRef memory usage

memory limit continued to not met. What you >> think of the attached patch? >> >> Regards, >> >> Fred >> >> 2015-02-19 16:31 GMT-02:00 Thomas Mueller : >> >>> Hi, >>> >>> Thanks a lot for the test case! I can now reproduce

Re: [h2] Operator precedence

Hi, This should be available in the SQL grammar railroads: http://h2database.com/html/grammar.html#operand On Wed, Feb 25, 2015 at 10:07 PM, Timo Westkämper wrote: > Hi. > > Could someone point me to the specification of operator precedence in H2? > > Thanks, > Timo > > -- > You received this m

[h2] MVStore.cacheChunkRef memory usage

decreased from 87MB to ~5MB. > > Regards, > > Fred > > 2015-02-19 16:31 GMT-02:00 Thomas Mueller >: > > Hi, >> >> Thanks a lot for the test case! I can now reproduce it, and I'm working >> on a fix. >> >> Regards, >> Thomas >> &

Re: [h2] Should "SHUTDOWN DEFRAG" reduce the DB File size when all tables are empty?

Hi, If you have entries in LOB_BLOCKS, then it is either a CLOB or a BLOB value. Such values can also occur for example when using PreparedStatement.setCharacterStream; it doesn't necessarily mean the table has a CLOB / BLOB column. When using the MVStore, with the current released version, some

Re: [h2] Should "SHUTDOWN DEFRAG" reduce the DB File size when all tables are empty?

; On Thu, Feb 19, 2015 at 1:31 PM, Daniele Renda > wrote: > >> Thank you very much! >> >> 2015-02-19 19:30 GMT+01:00 Thomas Mueller : >> >>> Hi, >>> >>> I found other cases where the problem occurs, but with "shutdown >>> immediate

Re: [h2] MVStore.cacheChunkRef memory usage

ObjectName.getInstance("com.sun.management:type=HotSpotDiagnostic"), > "dumpHeap", > new Object[] {"heapdump.hprof", true}, > new String[] {"java.lang.String", "boolean"}); > > connecti

[h2] Should "SHUTDOWN DEFRAG" reduce the DB File size when all tables are empty?

problem happears only when "shutdown > immediatly" is enabled? > > Thanks > Il 17/feb/2015 20:01 "Thomas Mueller" > ha > scritto: > > Hi, >> >> A short update: I can reproduce the orphaned lob block problem with a >> simple unit tes

[h2] MVStore "Pluggable Data Types" Examples

Hi, > is the default serialization using java.io.Serializable Yes, for classes that are not directly supported. See http://www.h2database.com/html/mvstore.html#dataTypes > This performs poorly on Android so I wanted to make sure. Yes, for higher performance you should use your own serialization

Re: [h2] Bugfix: MVStore 2GB cache size limitation

Hi, Thanks a lot! I will fix this. Regards, Thomas On Wednesday, February 18, 2015, Yannick Lecaillez < yannick.lecail...@forgerock.com> wrote: > Hi, > > I found another small issue: it looks like a computation using an incorrect > type artificially limit the cache size to 2GB: > > > https://

Re: [h2] Should "SHUTDOWN DEFRAG" reduce the DB File size when all tables are empty?

en the problem has occurred. I only know that I can run >> it for a period of time and the database will defrag fine and the recovery >> shows no orphaned BLOCKS; and other times when I run it there will be lots >> and lots and lots of orphaned BLOCKS. >> >> >>

Re: [h2] 1.4.x stability

Hi, I'm afraid the MVStore is not yet stable, and it's hard to say when it will be the case. The main issue is, the file format might still change. I'm quite sure it will be stable later this year, but when exactly that will be I don't know, sorry. Regards, Thomas On Monday, February 16, 2015,

Re: [h2] Re: [90007-169] The object is already closed - Weird behavior of JdbcResultSet

Hi, Well, yes, if the Statement is closed, then you can no longer use it... That's normal (not a bug). Regards, Thomas On Fri, Feb 13, 2015 at 8:25 AM, Duc Nguyen wrote: > Another similar error where the statement stat25631 got closed, later the > ResultSet rs39848 got from stat25631 called ne

Re: [h2] 1.4 beta creates much bigger database file

; Speaking of real world example - we are using H2 1.4.x to hold results >>>> for a continuous delivery chain. With 1.4.177, our database was > 600 Mb, >>>> and after a 'shutdown defrag', we went down to... 11 Mb. We switched to >>>> 1.4.184 but

Re: [h2] MVStore.cacheChunkRef memory usage

Hi, That means the LIRS cache keeps too many non-resident cold entries. I wonder how to best reproduce this problem... Do you have a simple test case (a description what you do would be enough in this case)? Regards, Thomas On Thu, Feb 12, 2015 at 3:17 AM, Trask Stalnaker wrote: > Hi, > > I wa

Re: [h2] Concurrency bugfix in TransactionStore

Hi, Thanks a lot! Yes, this is a bug. I have fixed this now in the trunk, and added a test case. Regards, Thomas On Wednesday, February 11, 2015, Yannick Lecaillez < yannick.lecail...@forgerock.com> wrote: > Hi, > > During my evaluation of MVStore/TransactionStore (trunk) i found a small > b

Re: [h2] org.h2.util.StringUtils.toUpperEnglish can be a bottleneck

Hi, I have committed my patch, could you please test it? You would need to compile H2 from the trunk, see https://code.google.com/p/support/source/checkout Regards, Thomas On Tue, Feb 10, 2015 at 7:45 AM, Thomas Mueller < thomas.tom.muel...@gmail.com> wrote: > Hi, > > It migh

Re: [h2] org.h2.util.StringUtils.toUpperEnglish can be a bottleneck

Hi, It might make sense to use a concurrent and global cache in the StringUtils class instead, similar to StringUtils.softCache (StringUtils.fromCacheOrNew). That way, other components could benefit from it as well, and small result sets would also benefit. I will write a patch. Regards, Thomas

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

th SMB2 itself), but never corruption issues. > > Ryan > > On 23/01/2015 9:34 PM, Rinse Lemstra wrote: > > Ok, certain versions of windows do have this behaviour, see: > https://groups.google.com/forum/?utm_source=digest&utm_medium=email#!topic/h2-database/w65UQETmo7U > >

Re: [h2] Documentation about Geometry type of H2 Database

Hi, Thanks! I will document it. Regards, Thomas On Saturday, January 17, 2015, Nicolas Fortin (OrbisGIS) < nico.de...@gmail.com> wrote: > Hello, > > Geometry and spatial index need documentation on official h2 documentation > web site. Maybe h2 team don't see this post ? > > Nicolas Fortin >

Re: [h2] Updated from 1.4.182 to 1.4.185

Hi, Yes, this is a bug that was introduced in version 1.4.184. It is fixed in the trunk. Regards, Thomas On Thursday, January 29, 2015, Rami Ojares wrote: > .. and got the following error in one of my queries. > Any idea what this could be related to? > I know I have to dig deeper but wanted

[h2] Re: Cannot remove records, cache size too small? exception

rmation_schema.settings shows it has > exceeded the cache_size_max setting - > > e.g. - > > info.CACHE_MAX_SIZE 80 > info.CACHE_SIZE 1034869 > > The CPU approaches 100% and a restart of H2 is required. > > > On Wednesday, January 16, 2

Re: [h2] FILE_LOCK=FILE and CACHE_SIZE=xxx?

Hi, In this document is written that CACHE_SIZE affects only when using a > client/server environment: > http://h2database.com/html/grammar.html?highlight=CACHE_SIZE&search=cache_size#set_cache_size > > No, it's a bit different. I will change the documentation as follows: "This setting only aff

Re: [h2] Should "SHUTDOWN DEFRAG" reduce the DB File size when all tables are empty?

up to 6GB >>>>>>>> and again the tables were empty. >>>>>>>> I ran the recovery and again had lots of LOB_BLOCKS. >>>>>>>> >>>>>>>> I was trying to come up with a test case - as I have mentioned I >>>

[h2] Re: Git repo request

Hi, So, will h2 move to git ? > Probably yes, at some point. But it's not something urgent for me, so it might still take a year or so. Regards, Thomas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop rec

Re: [h2] java.lang.RuntimeException: log.removeUntil not found: 29189 last 32020

Hi, Yes, that's strange. I saw that before, but not with recent versions of H2. I'm afraid I can't say what the problem is, sorry. We would need a reproducible test case I'm afraid. Regards, Thomas On Saturday, January 24, 2015, Daniele Renda wrote: > Hi, > I've this strange error in trace l

Re: [h2] Am I bananas or does serializable isolation not work as it should?

Hi, Version 1.4.x, when using the MVStore, only supports the MVCC model, and read committed. Setting the transaction isolation level to serializable basically has no effect there. This is a limitation (of the TransactionStore), I will need to document this. Serializable could be implemented, but i

Re: [h2] Coping a table takes very long

Hi, You wrote: 'not using the Driver directly'. Why shouldn't I? > It is not the official API. The preferred way is to use DriverManager.getConnection, or a data source. If you use DriverManager.getConnection, then the application can be compiled without having the H2 jar file in the classpath. T

Re: [h2] Need ! Microstrategy Developer ! Foster City, CA

Hi I'm sorry, usually I filter out such spam. This time I made a mistake. Regards Thomas On Friday, January 23, 2015, mohammed rizwaan wrote: > Hi, > > Please find the job description below if you have any suitable consultants > available please revert me back ASAP. > > > *Requirement:* > > Jo

Re: [h2] When MV_STORE is not set explicitely, H2 may create the database without the MV_STORE (it creates a file .h2.db)

Hi, I think I (independently) found and fixed the problem now in the trunk. If it was the same problem (this I will still need to test). Regards, Thomas On Thu, Jan 22, 2015 at 6:21 PM, Axel Maumont wrote: > Hello, > > First thank you for your amazing work on H2 :-) > > I'm using *h2-1.4.185.

Re: [h2] Re: Performance regression in versions starting 1.165 when using BLOB in temporary table

Hi, I could now fix last part of the problem ("An old transaction with the same id is still open"). This was a strange limitation in the MVStore transaction engine. Regards, Thomas On Sat, Jan 17, 2015 at 5:26 PM, Ken Jorissen wrote: > > On Monday, January 12, 2015 at 2:27:42 PM UTC-6, Ken Jor

Re: [h2] ArrayIndexOutOfBoundsException with H2 1.4.184

mething stupid - is not because > MAX_LENGTH_INPLACE_LOB > default value is 128? And so 130 > 128 > > In the end, there is a doc that explains as I can see these > "session-scope values" autonomously in order to understand when the > problems happens and tr

Re: [h2] DROP in SCRIPT command don't drop sequences

Hi, Could you please post a simple, reproducible test case? Regards, Thomas On Sunday, January 18, 2015, Daniele Renda wrote: > According to documentation ( > http://www.h2database.com/html/grammar.html#script) I'm using SCRIPT DROP > TO 'filename' table tablename to create a sql script of a

Re: [h2] ArrayIndexOutOfBoundsException with H2 1.4.184

Hi, How is possibile that that lob is referenced 16millios of times when that > value is only readed from other transactions in the application? > Each time you query the LOB (select * from test), the LOB is copied to a session-scope value. This is because the row with the LOB might be removed in

[h2] The object is already closed 90007-175 vs 9007-185

Hi, > So what does the code 9007-185 and 90007-175 means? 90007 is the error code (see ErrorCode.java) and 175 is the build number of H2 (version 1.3.175). Regards, Thomas On Thu, Jan 22, 2015 at 12:10 PM, Noel Grandin > wrote: > It means that you're calling a method on the JDBC Statement o

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

Hi, > on some windows-version the .lock.db file is not visible for remote connections for up to 10 seconds OK, if you have a file system where a new file is not visible for up to 10 seconds, then this is not something that can be supported by the auto-server mode (by this file locking method). I

Re: [h2] Coping a table takes very long

Hi, The following works for me. There are a few changes (not using the Driver directly, "create table as select", not using "select" in the "create linked table" definition). public static void main(String... args) throws Exception { DeleteDbFiles.execute("~/temp", "test2", true);

Re: [h2] ArrayIndexOutOfBoundsException with H2 1.4.184

utOfBound (you should yet seen this exception in my db). I'm > asking is removing the emailContent table can reduce the size of the db > > 3.now I try to make what you wrote in local with a real execution of the > app. > > Thanks > > > > 2015-01-15 7:50 GMT+01:00 T

Re: [h2] Parser bug introduced in 1.4.183 (Unexpected code path)

Hi, Yes, I can reproduce the problem with the following table definition: create table marketdataterm_2(mandator_id int, valid_from int, currency int, type int) And I have a simpler test case: create table test(id int); select * from test join(select id from test) on 1=1; The follo

Re: [h2] Should "SHUTDOWN DEFRAG" reduce the DB File size when all tables are empty?

what to think about that. Can you explain what I am seeing? > > Thanks Kent > > > On Wednesday, January 14, 2015 at 1:48:29 AM UTC-5, Thomas Mueller wrote: >> >> Hi, >> >> Could you send me the database file? >> >> If not, you you run the Recover

[h2] H2 Database Engine: New version 1.4.185 available

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 For future plans, see the 'Roadmap' page at http://www.h2database.com/html/roadmap.html Please note the jar

Re: [h2] Issue H2 Parser GROUP BY, 1.4.181 -> 1.4.184

Hi, This was a regression introduced in version 1.4.184, to fix the following issue: Group by with a quoted select column name alias didn't work. Example: select 1 "a" from dual group by "a" I have fixed this now (will commit to the trunk today or tomorrow). Regards, Thomas On Thursday, Janu

Re: [h2] ArrayIndexOutOfBoundsException with H2 1.4.184

Hi, Is needed a new db (version 1.4.184) or I can use the actual db? > You would need a new database file. Using an old (existing) database doesn't make sense, because it may already contain the problematic data. That way, we couldn't get a reproducible test case. But we need one. Because in tha

[h2] Re: ddl-statement and rollback

Hi, This should work. Is this available today? We are currently using 1.3.175 > The "marker checkpoint" feature is not yet implemented. I will implement something similar in the next release: the database setting REUSE_SPACE (default: true). If disabled, all changes are appended to the database f

Re: [h2] Version 1.4.181 has changed the temp file location?

Hi, There is a feature request to drop the file name suffix at all. That means, for the database URL "jdbc:h2:./data", the database file would then be called just "data". I think it's better to give access rights based on path than access rights based on file name suffixes. That is, allow to read

Re: [h2] ArrayIndexOutOfBoundsException with H2 1.4.184

Hi, Could you append ";trace_level_file=3" to the database URL, then run your test case against a new database (version 1.4.184), and then post the resulting database and *.trace.db file? The test case should be minimal in this case, so that the database doesn't get big (a few MB is enough for thi

Re: [h2] Is it SAFE to downgrade from 1.3.176 to 1.3.169?

Hi, Can you please elaborate on this? "Because using version 1.3.176 could have > changed the database file already" > You use the PageStore storage mechanism. Let's assume there was a bug introduced in H2 version 1.3.176, in the PageStore mechanism. I wouldn't know what that bug could be because

Re: [h2] ArrayIndexOutOfBoundsException with H2 1.4.184

ggest me what I can do to help you to fix the problem and avoid > my production db collaps?! > > Thanks very much! > > 2015-01-14 7:47 GMT+01:00 Thomas Mueller : > >> Hi, >> >> As why the database is so large: >> >> I got the large database and ran the R

[h2] Re: ddl-statement and rollback

issue. I saw no where in the documentation that this is > the behavior. This is quite severe in my opinion. We have an schema upgrade > framework that involved from DDL and DML commands. To move from one schema > version to another, you mass perform all steps successfully or non at all. &g

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

Hi, I can't say what the problem might be, but reverting to 1.3.169 should be possible. But it might make sense to re-create the database, by first creating a SQL script, then dropping the database, and re-creating it from the SQL script. > avoiding the creation of the TRACE FILE has absolutely n

Re: [h2] Pivot Request

Hi, Pivot is not implemented. The easiest solution is probably to write a user defined function that returns a result set. Regards, Thomas On Tuesday, January 6, 2015, Philbat wrote: > Hello, > > I have a table LINE(ID, NAME) AND a table TAG(ID, LINEID, TAG, VAL). > > Here is a example of co

Re: [h2] UNION of decimal value with different scale does not merge

Hi, I guess the problem is that for java.math.BigDecimal, hashCode (used for union) and compareTo (used for join) are a bit strange. See also the javadocs: "Note that two BigDecimal objects that are numerically equal but differ in scale (like 2.0 and 2.00) will generally not have the same hash co

[h2] ArrayIndexOutOfBoundsException with H2 1.4.184

tion in the database file (PageStore). I didn't further analyze this yet, I think the "large database file" issue is more urgent in this case. Regards, Thomas On Sun, Jan 4, 2015 at 11:15 AM, Thomas Mueller < thomas.tom.muel...@gmail.com > wrote: > Hi, > > I think pa

Re: [h2] Please suggest for this error, When I am doing Maven clean install on my project getting this error. Thanks in advance.

Hi, H2 does not use maven. You need to use "./build.sh". See also the documentation. Regards, Thomas On Tuesday, January 6, 2015, Saransh Tripathi wrote: > [java] generateScript: > [java] [eclipse.buildScript] Some inter-plug-in dependencies have not > been satisfied. > [java] [ecl

Re: [h2] High processor usage when no transactions taking place

wrote: > Hi, > > Apologies for the delay in responding - I have been on vacation, and not > had access to the system . I have attached a sequence of thread dumps over > a couple of minutes. > > Regards > > Stephen Lake > > On Sunday, 7 December 2014 09:00:42 UTC, Thoma

Re: [h2] Version 1.4.181 has changed the temp file location?

0, Harshad RJ wrote: >> >> Indeed would be great if there is documentation on that. >> >> Would be even more awesome if Constants.java added a constant for that >> suffix string. >> >> thanks, >> Harshad >> >> On Tuesday,

[h2] Attempted to run 1.4.184 overnight and failed with ArrayIndexOutOfBoundsException

Hi, The ArrayIndexOutOfBoundsException was due to a bug in the MVStore code, and the MVStore is beta. > how am I suppose to code for this? You can't really code for this I'm afraid. > I cannot just shutdown and warn the user that all is lost. Well, except if there is a backup (if you periodica

[h2] Should "SHUTDOWN DEFRAG" reduce the DB File size when all tables are empty?

Hi, Could you send me the database file? If not, you you run the Recover tool and check the created *.sql and *.txt files? For an empty database, they should contain no data. Regards, Thomas On Fri, Jan 9, 2015 at 4:07 PM, Kenton Garner > wrote: > > URL: > "jdbc:h2:../data/audit;COMPRESS=TRU

[h2] What would be the best update-candidate

Hi, The main change in version 1.4 was that the MVStore is now the default. That's the reason why it is "beta". There were a few other changes (see the change log), but mostly just bugfixes or new features that are not dangerous. Regards, Thomas On Fri, Jan 9, 2015 at 12:03 PM, Rinse Lemstra >

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

Hi, The PageStore is the storage engine, it mainly references the cache. The CacheLRU is the cache. You can configure the cache size using "set cache_size <...>" or by appending ";cache_size=..." to the database URL. See also the documentation. Regards, Thomas On Tuesday, January 6, 2015, Rins

Re: [h2] Getting this error while updating version of H2 from 1.3.152 to 1.3.176

Hi, H2 doesn't use maven. You need to use the "./build.sh" shell script. See also the documentation ("build"). Regards, Thomas On Thursday, January 8, 2015, Saransh Tripathi wrote: > On running maven clean install. > > With version 1.3.152 its working fine. > > With version 1.3.176 giving e

<    1   2   3   4   5   6   7   8   9   10   >