Re: [h2] Exploiting H2 Database with native libraries and JNI

Hi, > unfortunately Sonatype Data Research think otherwise They are free to discuss this with us of course. I couldn't find "Sonatype CVSS 3:8.0" or "sonatype-2020-1324", do you have a link? Regards, Thomas On Fri, Feb 18, 2022 at 2:53 PM András Vereb wrote: > Hi Thomas, > > however I

Re: [h2] Exploiting H2 Database with native libraries and JNI

Hi, Yes, H2 can act as a compiler / interpreter and execute code... Same as Java: you can write a Java program that reads and writes files. And same as GCC (or any other compiler / interpreter). I wouldn't call this a "Security Vulnerability". >

Re: [h2] suggestion/feature request CSVREAD respect column names

>From the docs: http://h2database.com/html/functions.html#csvread "If the column names are specified (a list of column names separated with the fieldSeparator), those are used, otherwise (or if they are set to NULL) the first line of the file is interpreted as the column names" On Thu, Feb 13,

[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 Please note the jar file may not yet be available in the Maven central repository (synchronizing usually

[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 Please note the jar file may not yet be available in the Maven central repository (synchronizing usually

[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 Please note the jar file may not yet be available in the Maven central repository (synchronizing usually

Re: [h2] Re: Next release date?

for getters and setters. We can also have a discussion about changing the rules if you like. Regards, Thomas On Wed, Dec 19, 2018 at 11:36 AM Diogo Calazans wrote: > Is there anything that I (or we) could do for help you ? > > Em qua, 19 de dez de 2018 às 08:34, Thomas Mueller Graf < >

Re: [h2] Re: Next release date?

of the year, but I will try. Regards, Thomas On Wed, Dec 19, 2018 at 10:51 AM Taras Ledkov wrote: > Hi, > > Apache Ignite is looking forward to H2 next release too. > There are several very important patches for Ignite after v.1.4.197. > > On Thursday, December 13, 2018 at 7:15:5

Re: [h2] Re: Next release date?

Hi, I did the releases so far, I can certainly do that, but it would take some time. I think near the end of this year would be possible. Regards, Thomas On Thu, Dec 13, 2018 at 5:13 PM Yan wrote: > Same question - it's been 9 months and close to 1800 commits since > 1.4.197. We don't mind

Re: [h2] CVE-2018-10054

Hi, See the CVE: Datomic was fixed. Regards, Thomas On Thu, Aug 9, 2018 at 11:36 AM Thomas Mueller Graf < thomas.tom.muel...@gmail.com> wrote: > Hi, > > > H2 1.4.197, as used in Datomic before 0.9.5697 and other products > > I think the point here is "as used in D

Re: [h2] CVE-2018-10054

Hi, > H2 1.4.197, as used in Datomic before 0.9.5697 and other products I think the point here is "as used in Datomic ... and other products". You could say that "bash" is vulnerable "as used in ". The problem to me seems not in H2, but in , that uses H2 in a way that is not secure. On Thu,

Re: [h2] MVStore and interrupts?

Hi, > not interrupting is easier said than done with other libraries. Yes... One case, that was biting us, is using java.util.concurrent.ExecutorService.shutdownNow(). This was calling Thread.interrupt() in our case. It was relatively easy to resolve: now we use shutdown() instead. See

Re: [h2] MVStore and interrupts?

Hi, Try this: "retry:nio:" + ... See also TestConcurrent.testInterruptReopen() (It would be good to improve documentation for this I guess). Regards, Thomas On Thu, Jun 28, 2018 at 9:59 AM Dan wrote: > I've been going down this road: > https://github.com/h2database/h2database/issues/227

Re: [h2] Re: Plan to support second index key?

Hi, The MVStore supports multiple maps. To add an index for a map, simply add another map. This is how the H2 database (the relational part of H2 with SQL API) uses the MVStore. Example: Map customers = ... // key: customer id; value: customer data Map

Re: [h2] MVMap similar to LinkedHashMap

Hi, What about adding a second map with a counter as a key, and the key as the value. So there are two maps: map 1: key: counter; value: your key map 2: key: your key; value: your value plus the counter from map 1 Regards, Thomas On Sun, Apr 22, 2018 at 8:46 PM, ivan

Re: [h2] Why is there no unit tests?

There are unit tests. Michael Putilov schrieb am Fr., 6. Apr. 2018, 04:44: > Could someone tell me why is there no unit tests? Regular unit tests with > mocks and stubs. > > Everything what I see is only acceptance tests. > > Is there a reason for not writing unit tests

Re: [h2] Re: How often is H2 released?

Yes, the release is done now. I'm sorry it took so long... Regards, Thomas On Sun, Mar 18, 2018 at 8:44 PM, Stéphane Eintrazi wrote: > Should be coming soon :) https://github.com/h2database/h2database/commit/ > c8a861bb1a3f04967ec40cb5e3336535c43af5fb > > -- > You

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

Re: [h2] FILE_LOCK=NO in multi ihreaded server application

Hi, Why do you use FILE_LOCK=NO? I don't think you should. Could you provide a simple, reproducible test case? Regards, Thomas On Friday, November 24, 2017, Olaf van der Meer wrote: > Hi, > > We have got a multi threaded server application. Each thread connects with > a

Re: [h2] MVStore Custom datatypes are treated as ObjectDataType

Hi, You need to set the key and value type. In Java, there is no other way to get hold of the class (that's the way generics work). Regards, Thomas On Mon, Aug 14, 2017 at 2:09 PM, wrote: > Hi, > > > H2 version 1.4.196; I implemented a custom data type. After opening map

Re: [h2] Version 1.3.176 not on download page

Hi, Yes, only recent versions are available for download at h2database.com. Older versions are available on Maven. Regards, Thomas On Monday, July 24, 2017, Richard Fuller wrote: > Not sure why it was officially removed, but they push the jars to main > Maven

Re: [h2] H2 very slow compared to others?

Hi, It depends on what you do. For simple use cases, I generally found H2 to be faster than DB2, specially in embedded mode, as no network overhead is needed. But your use case is probably different. That's hard to say, because you didn't write what you did. Regard, Thomas On Monday, July 24,

Re: [h2] DATE / TIME types are not consistent across timezones / DST!

Hi, I think you should write a simple, self contained, reproducible test case. Regards, Thomas On Monday, July 24, 2017, marcolopes wrote: > I believe H2 works differently from MySQL and PostgreSQL : > LocalTime is not SAVED, so, i have a big problem in my

Re: [h2] Query very slow over ODBC driver connection

Hi, It's hard to say, it would be best to analyze what the database engine is doing during that time using thread dumps. Usually it's enough to capture a few and then have a look at them. Regards, Thomas On Friday, July 14, 2017, Murilo Mansano wrote: > > I am

Re: [h2] H2 Database upgrade

Hi, No, the database file was not upgraded. For how to upgrade, see the documentation, section "Upgrade, Backup, and Restore". Regards, Thomas On Tuesday, July 18, 2017, Lingamoorthy Bheeman Balan < b.b.lingamoor...@gmail.com> wrote: > *Hi,* > > *Kindly help us in understanding/migration h2

[h2] H2 Database Engine: New version 1.4.196 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] Why MVMap's public V get(Object key) is not synchronized

Hi, The get method is thread-safe. The MVMap implements ConcurrentMap which implies thread-safety. Thread-safe method doesn't need to be synchronized. For example, String.hashCode is not synchronized, but is thread-safe. Regards, Thomas On Friday, June 9, 2017, Michael Wu

[h2] H2 Database Engine: New version 1.4.195 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] Which is best using one MVStore (persisted to a file) for two MVMap(s) or two?

Hi, I would try using one store, with a higher cache size. The cache is shared, so in theory performance should be a bit better (slightly higher cache usage). Regards, Thomas On Fri, Mar 31, 2017 at 4:06 PM, Kenton Garner wrote: > First - Thomas and Noel, Thanks for

Re: [h2] "WHERE param in ()" produces no error in PostgreSQL mode

Hi, > a lot of people would pay some money to see H2 being faster, more stable, more SQL 2003+ (CTE, complex merge, etc) etc Yes, I understand that... Right now we don't have the people for this I'm afraid. As for the issue at hand: I don't see why it's a syntax error in PostgreSQL. Unlike

Re: [h2] Re: h2 process dies frequently on redhat

Hi, I didn't know about the -Xrs option. But I would be careful, because according to http://stackoverflow.com/questions/34951812/why-does-xrs-reduce-performance this might reduce performance. I used nohup for testing H2 on a Raspberry Pi; it worked for me. Regards, Thomas On Thu, Mar 23,

Re: [h2] Having DbException Syntax error in SQL statement defining a H2 trigger

Hi, I'm not sure why, but it looks like inner classes are not supported right now. I get: Caused by: java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at

Re: [h2] h2 process dies frequently on redhat

Hi, I don't think this is related to H2. I would try using nohup: https://en.wikipedia.org/wiki/Nohup Regards, Thomas On Wed, Mar 22, 2017 at 11:00 AM, Snowber Khan wrote: > I am running h2 on Redhat 7.2 in server mode. I start the database as the > root user via command

Re: [h2] MVStore caching on read

MVMap<String, HashMap<String, >> Object>> >> >> Regards, >> Roland >> >> >> On Wednesday, March 15, 2017 at 1:13:14 PM UTC+1, Thomas Mueller Graf >> wrote: >>> >>> Hi, >>> >>> OK I see. I'm not sure, m

Re: [h2] MVStore caching on read

Hi, OK I see. I'm not sure, maybe this is a bug? Can you reproduce it with a simple test case (for example using )? Regards, Thomas On Wed, Mar 15, 2017 at 12:20 PM, Roland Lohner wrote: > Hi Thomas, > > I suspect you misunderstood case B). > In that case

Re: [h2] New version 1.4.194 - performance regression on index creation?

Hi, I'm not aware of a regression. Could you get a few full thread dumps and post them please? (jps -l to get the process id, then jstack -l >> jstack.txt, about 10 times). Also, we would need to know the table definition, a description of the data (example data would be best), number of rows,

Re: [h2] How to overload a H2DB function

Hi, I don't think this is supported right now, sorry. Regards, Thomas On Monday, March 13, 2017, gb co wrote: > Hi, > Is there a way to overload a predefined H2DB function? > What i want is for H2DB to be able to handle the function call: > LAST_INSERT_ID(id) > > Basically

[h2] MVStore caching on read

Hi, It's not an anomaly. If you overwrite existing entries, as you do in B), then the old value is first read. Which means reading from disk. There are currently no "blind writes". > Used cache size calculation seems to be incorrect It depends on the key and value data types you use. You didn't

Re: [h2] H2 Database Engine: New version 1.4.194 available

l a reference to 1.3.193, but I guess it should be 1.4.193. > > Kind regards, > > Remco Schoen > > > Op 12 mrt. 2017, om 08:16 heeft Thomas Mueller Graf < > thomas.tom.muel...@gmail.com> het volgende geschreven: > > Hi, > > Unfortunately, I will not be able t

Re: [h2] Re: H2 Database Engine: New version 1.4.194 available

at 5:12 AM, Gary Gregory <garydgreg...@gmail.com> wrote: > Version 1.4.194 is not in Maven Central. Can you please add it? > > Thank you, > Gary > > > On Friday, March 10, 2017 at 2:24:27 PM UTC+1, Thomas Mueller Graf wrote: >> >> Hello, >>

[h2] H2 Version 1.4.194: Maven Central files will be available on Tuesday

Hi, A new version of H2 was released today. Unfortunately, I will not be able to upload the jar files to Maven Central (Sonatype) until Tuesday, because I don't currently have the GPG authentication keys. But of course you can still download H2, and the jar files, from the h2database.com

[h2] H2 Database Engine: New version 1.4.194 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] Website color typos

Hi, Thanks a lot! I will fix those typos. This will be fixed in the next release. Regards, Thomas On Thursday, March 9, 2017, Jon Harper wrote: > Hi, > just a quick report that the page http://www.h2database.com/ > html/features.html#comparison has a small color

Re: [h2] MVStore write to disk but getting an out of memory error

Hi, The MVStore uses a limited, fixed amount of memory (about 32 MB). If your application uses a lot of memory, then you will get out of memory. I suggest to analyze such problems with "jmap -histo" or "jmap -histo:live". If you still think this is a problem of the MVStore, then please post a

Re: [h2] Invalid value "0" for parameter "parameterIndex"

Hi, This exception message doesn't seem to come from H2. Probably you should ask at the DataNucleus mailing list. Also, could you post the complete stack trace please (they will need it). Regards, Thomas On Tuesday, March 7, 2017, Carsten Langsdorf wrote: >

Re: [h2] MVStore caching on read

Hi, Which cache do you mean? MVStore.cache? How did you investigate? Regards, Thomas On Wednesday, March 8, 2017, Roland Lohner wrote: > Hi MVStore developers, > > I have a question regarding caching. > > I use a file based persistent MVStore instance. > The store seems to

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

keep running? That thread has been > running constantly for 10 days now? > FYI, there is another 3rd party application process that writes data to > the same disk, maybe on average 2 MB/sek - that shouldn't make a big impact > or...? > > Thanks, > -Andreas > > Den onsdag den 1. mar

Re: [h2] MVMap rollback

Hi, No, I'm sorry, there is no way. But you can open the map for a specific version, and copy the data to a new map. Regards, Thomas On Fri, Mar 3, 2017 at 8:11 AM, Roland Lohner wrote: > Hi, > > I have to rollback a given MVMap to an earlier version. > Other maps in the

Re: [h2] BUG? odd behavior involving automatic foreign key indices and multiple-column primary keys

Hi, Yes, H2 creates unique indexes for constraints. If you have a complete, standalone, simple reproducible test case, we can have a look. But please remove all columns that are not needed to analyze this. Regards, Thomas On Fri, Mar 3, 2017 at 8:58 PM, Laird Nelson wrote:

Re: [h2] H2 lucene

Hi, This is exception is not from Lucene, it is from H2. If you have a reproducible test case where such a corrupt database can be created, that would be great. At least I would need to know the database URL, the size of the database file, the Java version, and the stack trace. Regards, Thomas

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

Hi, Yes, this is the background thread trying to compact (garbage collect) the database file. It should only occur if there is no other write activity, and should not affect write performance. Regards, Thomas On Tuesday, February 28, 2017, andreas fw wrote: > Hi, > > I

Re: [h2] How to delete duplicate rows?

Hi, This is a generic SQL question, not related to H2, best asked at StackOverflow.com. Regards, Thomas On Wednesday, March 1, 2017, Imran Ahmed wrote: > Greetings, > > How do I go about deleting duplicate rows? In other words, if multiple > rows have a same value for a

Re: [h2] "Hexadecimal string contains non-hex character" when opening db

Hi, Could you post the exception stack trace please? Regards, Thomas On Wed, Mar 1, 2017 at 11:27 AM, JohanBerg wrote: > A user with H2 in an application gets this error code: > "org.h2.jdbc.JdbcSQLException: Hexadecimal string contains non-hex > character: "-psn_0_57358"

Re: [h2] Aggregating multiple H2 databases?

Hi, You may want to look at http://h2database.com/html/functions.html#link_schema and "create linked table". Regards, Thomas On Wednesday, March 1, 2017, Laird Nelson wrote: > Suppose I have some jar files that contain read-only H2 databases in the > manner described

Re: [h2] H2 lucene

Hi, Patches to upgrade Lucene are welcome. Regards, Thomas On Tuesday, February 28, 2017, Sylvain Pointeau wrote: > Hello, > > I tried using the native full text search on my db but from 2 GB, it grew > up to +12GB, I had to stop the index creation. > So I tried

[h2] Re: Voting up for SQL Trigger

Hi, One problem is that there is no "standard" SQL mini language. As soon as we support something, people would complain it doesn't support their use case. Regards, Thomas On Thursday, January 19, 2017, Noel Grandin wrote: > No, I meant that I'd be happy to accept a

Re: [h2] H2 1.4.190 NPE after forced kill or poweroff

Hi, I don't know what it could be, but possibly it's fixed in a newer version of H2. I suggest to re-create the database, using "script to ..." and then "runscript from ...". Regards, Thomas On Monday, February 27, 2017, Дмитрий Моряков wrote: > And just to draw your

Re: [h2] underscore in table name and czech collation

Hi, I can't reproduce it either. Regards, Thomas On Monday, February 27, 2017, Steve McLeod wrote: > Hi Ivo, > > This problem caught my eye, because I'm fascinated by code problems that > occur with obscure causes. > > However I've been unable to reproduce the problem.

Re: [h2] cross-transactional specifics of 'merge'

Hi, I think you are right, but it also depends on the storage engine and settings. Regards, Thomas On Tuesday, February 14, 2017, wrote: > Hi! > > I investigated SQL command "merge" in multi-transactional environment. It > seems to me that invocation of merge in one

Re: [h2] Strange long INSER : One INSERT out of 18889 is very long

her than windows but on the same > computer and it went better. > > Thx, > Nicolas > > Le dimanche 12 février 2017 14:00:51 UTC+1, Thomas Mueller Graf a écrit : >> >> Hi, >> >> collectReferencedChunks used to be a problem in the past, but recent >> ve

[h2] Re: Connection Properties

Properties object. > org.h2.engine.ConnectionInfo#readProperties ignores this. > org.h2.engine.Engine#openSession could be modified to handle these and > set them as properties > > Cheers > > Jon > > On Friday, 20 July 2012 16:58:35 UTC+1, Thomas Mueller Graf wrote: >&g

Re: [h2] H2 1.4.190 NPE after forced kill or poweroff

Hi, Did you try with the latest version? Regards, Thomas On Tuesday, February 21, 2017, Дмитрий Моряков wrote: > Hi. > Faced to the common problem of NullPointerException on opening database > after a forced stop. > > Configuration: > 1)Win 7 x64 > 2) Java 7 > 3)

Re: [h2] H2

Hi, I'm sorry to say this, but it's unlikely that someone will read such a long mail. I suggest to try to answer the question instead. Regards, Thomas On Monday, January 23, 2017, Cory Nichols wrote: > Thank you for the advice. I also found the limitations section i did not

Re: [h2] Table function not case insensitive

Hi, > DATABASE_TO_UPPER=FALSE This is for identifiers, not for values. You will have to check that the jobstatus column is case insensitive. Regards, Thomas On Tue, Feb 21, 2017 at 8:34 PM, Chris Sunderland wrote: > I'm having an issue when using the TABLE function

Re: [h2] connecting to h2 from non-java languages

Hi, [1] I'm afraid the web-console doesn't use JSON or any other "standard" format (it would be nice thought). [2] This I can't say. Regards, Thomas On Thu, Feb 23, 2017 at 3:47 AM, Adam McMahon wrote: > Hi Group, > > i am considering a project that may require me to

Re: [h2] H2 - Buy Support / Buy Formal Training

Hi, > In this case the multiple indexes should help to get reasonable response time for complex queries It depends on the data and the queries. In some cases, a multi-column index is needed. > Do you have any idea how to do it? It depends on the data and the queries. This is not just for

Re: [h2] Re: Errors in the DBMS comparison

Hi, Sorry, it's an old mail... The footprint is the size of the database engine itself, not just the driver. Regards, Thomas On Sun, Oct 23, 2016 at 1:13 PM, Philippe Marschall < philippe.marsch...@gmail.com> wrote: > > > On Tuesday, August 30, 2016 at 11:56:31 PM UTC+2, Thomas Kellerer

Re: [h2] Re: Strange long INSER : One INSERT out of 18889 is very long

Hi, collectReferencedChunks used to be a problem in the past, but recent version of H2 should be better. Which version do you use? If the latest version, could you create a simple test case? Regards, Thomas On Fri, Jan 27, 2017 at 12:48 PM, Noel Grandin wrote: > yeah,

Re: [h2] Recovery tool does not handle LOBs correctly (explanation and fix is proposed)

Hi, I agree, but releasing H2 will take a few weeks I'm afraid. Regards, Thomas On Thu, Feb 2, 2017 at 12:25 PM, LRichard wrote: > Hi, > > It would be great if version 1.4.194 could be released in order to > integrate the patch. > (We have corrupted customer databases

Re: [h2] Database updates

Hi, One option might be to have a background thread updating the database once every few seconds or so, if the dirty flag is set. Regards, Thomas On Sat, Feb 4, 2017 at 12:48 PM, vicenrico wrote: > Hello. I don't know how h2 database works internally, so I would like to >

Re: [h2] MVStore transaction concurrency

Hi, Using multiple threads against the same transaction is not supported or tested, I'm sorry. Regards, Thomas On Wed, Feb 8, 2017 at 3:55 PM, Roland Lohner wrote: > Dear MVStore developers, > > I have a question regarding concurrent access of a TransactionMap in one >

Re: [h2] Question about the wording of the tutorial info on timestamp values with time zone

Hi, I think the current documentation is correct, and I don't see how it could be written to be more clear. > It appears that timestamp values _without_ a time zone are parsed > _without_ using the current time zone setting of the system. If that would be true, which timezone would be used

Re: [h2] MySQL mode

Hi, Actually, it is in the src/tools directory of H2. It was an attempt to modularize the code. It was probably not a good idea. It is not included in the H2 jar file, so you would need to manually add it to the classpath or possibly your code. Regards, Thomas On Fri, Jan 6, 2017 at 7:18 AM,

Re: [h2] Re: Index hints

Hi, > With this enhancement I'm trying to solve one of my own performance issues. Sure, it sounds good to me. The "fail query" is a different feature, the links were just FYI. > It is possible that no index in the list is chosen, in which case a full table scan will be used. It looks like this

Re: [h2] Performance drawback of automatic analyze?

Hi, Your analysis is not correct. 2000 is the initial wait time (in number of changes), since starting the database. As documented, "The time between running ANALYZE doubles each time since starting the database". So it's 2000, 4000, 8000, 16000,... Regards, Thomas On Wed, Jan 4, 2017 at 7:42

Re: [h2] Index hints

Hi, The MySQL syntax sounds good to me. As an alternative, the MS SQL Server syntax, see also https://msdn.microsoft.com/en-us/library/ms190322.aspx and maybe http://blog.sqlauthority.com/2009/02/08/sql-server-introduction-to-force-index-query-hints-index-hint-part2/ A related feature is to fail

Re: [h2] Re: full join alternative for h2

Hi, See also http://stackoverflow.com/questions/406294/left-join-vs-left-outer-join-in-sql-server Regards, Thomas On Tue, Dec 27, 2016 at 11:13 PM, Christian Master wrote: > OUTER JOIN doesn not work. > But LEFT OUTER JOIN does. > So LEFT OUTER JOIN seems to be like FULL

Re: [h2] Concurrency at org.h2.store.fs.FileBase.read()

Hi, I didn't see a failure either. Regards, Thomas On Thu, Dec 22, 2016 at 10:13 AM, Noel Grandin wrote: > > > On 2016/12/21 7:24 PM, Anatolii K wrote: > >> Test attached >> >> > Are you definitely testing with the latest HEAD? Because I ran your test > for 10 minutes

Re: [h2] Concurrency at org.h2.store.fs.FileBase.read()

Hi, I guess that bug would be on my plate... I recently made changes there (trying to improve concurrency). I'm sorry about that. Having a test case would be great! Regards, Thomas On Wed, Dec 21, 2016 at 3:56 PM, Noel Grandin wrote: > Can we get a full stack trace

Re: [h2] SELECT * FROM (SELECT ? FROM DUAL) fails

Hi, You could use "cast": SELECT * FROM (SELECT CAST(? AS VARCHAR) FROM DUAL) On Thursday, November 17, 2016, Boris Granveaud wrote: > Hello, > > I have a problem with the following statement: > > SELECT * FROM (SELECT ? FROM DUAL) > > it gives this error with H2 1.4.191:

Re: [h2] SHUTDOWN COMPACT does not recover space SHUTDOWN DEFRAG take insanely long Opening DB takes 500Mb of space

Hi, It could be due to LOG data (BLOB, CLOB) that are not referenced, and not correctly garbage collected. To analyze that, we would need a reproducible test case. To find out, you could use the Recover tool on the large database. Regards, Thomas On Tuesday, November 22, 2016, Petr Holík

Re: [h2] Wait for getting connection infinitely

I'm sorry there is not enough data to reproduce or analyze this. What I would check is that you use the same version of H2 on the client and on the server. > UnfortunaIy my system was stoped 3 times recently. I don't know what "stoped" means. On Monday, November 21, 2016, yone

Re: [h2] H2 Database running really slow on mac OS sierra

Hi, Yes, I guess the problem is that somehow it's trying to resolve "localhost". I'm hoping there is a simple workaround for H2, but I'm not sure. Regards, Thomas On Saturday, November 19, 2016, wrote: > Update: I downloaded the tester from thoeni.io and ran the test

Re: [h2] Confused with the usage difference of org.h2.mvstore.type.XXXType and org.h2.value.DataType

Hi, The MVStore is a key-value storage engine that knows nothing about SQL, and can be used without the relational database engine. So the MVStore data type is used for that. The org.h2.value.DataType is the data type used for SQL (relational database) stuff. Regards, Thomas On Wednesday,

Re: [h2] Investigating large DBs

Hi, This last time there was also an index corruption, so we could not do a > dump and restore. > Hm, you should still be able to use "script to...". Did this not work? > > Do you have any suggestions on how to investigate the cause of this? E.g. > I have seen some threads mentioning the

Re: [h2] H2 Database running really slow on mac OS sierra

Hi, Yes, I guess the problem is that somehow it's trying to resolve "localhost". I'm hoping there is a simple workaround for H2, but I'm not sure. Regards, Thomas On Saturday, November 19, 2016, wrote: > Update: I downloaded the tester from thoeni.io and ran the test

Re: [h2] Confused with the usage difference of org.h2.mvstore.type.XXXType and org.h2.value.DataType

Hi, The MVStore is a key-value storage engine that knows nothing about SQL, and can be used without the relational database engine. So the MVStore data type is used for that. The org.h2.value.DataType is the data type used for SQL (relational database) stuff. Regards, Thomas On Wednesday,

Re: [h2] Wait for getting connection infinitely

I'm sorry there is not enough data to reproduce or analyze this. What I would check is that you use the same version of H2 on the client and on the server. > UnfortunaIy my system was stoped 3 times recently. I don't know what "stoped" means. On Monday, November 21, 2016, yone

Re: [h2] SHUTDOWN COMPACT does not recover space SHUTDOWN DEFRAG take insanely long Opening DB takes 500Mb of space

Hi, It could be due to LOG data (BLOB, CLOB) that are not referenced, and not correctly garbage collected. To analyze that, we would need a reproducible test case. To find out, you could use the Recover tool on the large database. Regards, Thomas On Tuesday, November 22, 2016, Petr Holík

Re: [h2] Serious bug : Urgent solution : Wrong records show when date filter in where query.

Hi, Did you run this with the H2 Console tool? select "date1" from "paymentList" where "date1">='2017-01-01' date1 8016-08-31 00:00:00.0 9016-09-30 00:00:00.0 So the result seems to be correct. Openoffice trucates the century. Regards, Thomas On Wed, Nov 23, 2016 at 12:20 PM, Mayur Bhatt

[h2] H2 Database Engine: New version 1.4.193 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] Re: The date of next 1.4 release

which look abandoned, also I wanted to fix the issue #375 > but the fix becomes a bit complicated and risky, it is better to postpone > it. > > Sergi > > > > 2016-10-21 17:42 GMT+03:00 Thomas Mueller Graf < > thomas.tom.muel...@gmail.com>: > >> Hi, >> &g

Re: [h2] Errors in the DBMS comparison

Hi, Thanks, and sorry for the delay! This is now fixed in the documentation (in trunk; the website will be updated next week). By the way, if you would like us to update the documentation, feel free to send a pull request. Regards, Thomas On Tue, Aug 30, 2016 at 11:56 PM, Thomas Kellerer <

Re: [h2] Re: The date of next 1.4 release

Hi, Yes, I would like to make a new official release as well. I can wait a week. Regards, Thomas On Fri, Oct 21, 2016 at 4:29 PM, Sergi Vladykin <sergi.vlady...@gmail.com> wrote: > Guys, > > I'm going to merge few more improvements this week and after that I will > be ask

Re: [h2] why it is? This map is closed [1.4.188/4] / Last block not stored, possibly due to out-of-memory

Hi, As the error message says, possibly there was an out-of-memory problem before this. Regards, Thomas On Fri, Aug 12, 2016 at 11:17 AM, test love wrote: > h2-1.4.188.jar > > java.lang.IllegalStateException: This map is closed [1.4.188/4] > at

Re: [h2] Support for large lists in memory

Hi, I suggest to use StackOverflow.com for such questions. Regards, Thomas On Mon, Aug 15, 2016 at 8:25 PM, anaderi wrote: > I am currently building out custom forum software for my project, and I > would like for a Forum to contain a List, and a Thread to contain a >

Re: [h2] Shall I add H2 to Travis CI?

Hi, I agree, it would be great! Regards, Thomas On Thu, Aug 11, 2016 at 12:40 PM, Sergi Vladykin wrote: > Very good idea! I wanted to do exactly that, but never got time. It will > be a great contribution! > > Sergi > > 2016-08-11 13:18 GMT+03:00 Steve McLeod

Re: [h2] H2 can't recover database

The worst part is that I've lost all the data, not only part of it... > > > Tatyana > > On Wednesday, July 20, 2016 at 12:33:00 PM UTC-3, Thomas Mueller Graf > wrote: >> >> Hi, >> >> I suggest to use the Recover tool of the very latest version of H2.

Re: [h2] File corrupted in chunk 1550574, expected page length 4..1024, got 1852517937 [1.4.191/6]

Hi, I would be interested to analyze the database file if you still have them. Regards, Thomas On Tuesday, July 12, 2016, Zheng Wang wrote: > I met the same problem. H2 database 1.4.191 was corrupted after a Windows > 7 crash. > When connecting to the database via

Re: [h2] Database size is strangely big, actual data is not so much, dropping/adding rows/tables does not modify file size, Database size after cleaned is anyway very big even if no data is present an

Hi, The PageStore is a classical storage system with redo and undo log, and overwrites old data (in a save way). The MVStore doesn't overwrite data immediately, but wait doing that for at least 1 minute. In theory, the PageStore needs less (measurable) disk space, but in practise, with solid

  1   2   3   4   5   6   7   8   9   10   >