Re: [h2] Infinite loop when creating session (only) with h2-1.4.186.jar

Hi, Yes, this issue was reported (issue 605) and is now fixed in the trunk. I wanted to release a new version this weekend, but unfortunately I was sick. Right now I'm trying to fix an important issue (also related to LOBs); hopefully there release will be this weekend. Regards, Thomas On Friday

[h2] NULL Geometry index problem

Hi, Yes, this issue was reported last week as well; it should be fixed in trunk. Regards, Thomas On Tue, Apr 7, 2015 at 12:11 PM, John McMahon > wrote: > We are experiencing null pointer exceptions when we attempt to store a > null geometry in H2 when we close the connection > > Attached is a s

[h2] Timeout trying to lock table ; SQL statement:

Hi, Yes, use SELECT * FROM INFORMATION_SCHEMA.LOCKS; SELECT * FROM INFORMATION_SCHEMA.SESSIONS; To cancel a transaction of a different connection, see http://h2database.com/html/functions.html#cancel_session Regards, Thomas On Tue, Apr 7, 2015 at 12:20 PM, Антон Чехов > wrote: > Hi Thomas Th

[h2] JDBC 4.0

Hi, I would probably try version 1.3.176 (2014-04-05), which is marked as the "last stable" version. The method DatabaseMetaData#getSchema(String,String) is there since about February 2011, but threw an exception back then ("unsupported"). In February 2013 (revision 4659) the method was correctly

Re: [h2] question abount MVStore: does MVStore support multithread?

Hi, Where is it documented ? > That's a good point. It is not well documented currently, I will fix that. The documented limitations only apply to the PageStore storage engine, which is the default in version 1.3.x. With version 1.4.x, the MVCC mode is enabled by default, and better tested, and a

Re: [h2] JDBC 4.0

Hi, What database URLs do you currently use? Maybe we should add a way to auto-delete the database file if it is closed? This could be done in the file system abstraction, for example using the prefix "autoDelete:", so that a database URL would look like "jdbc:h2:autoDelete:./target/db/test" (usi

Re: [h2] JDBC 4.0

RUE > > I had to change that everywhere to instead > use jdbc:h2:mem:db1;DB_CLOSE_DELAY=-1 > > On Wed, Apr 8, 2015 at 7:37 AM, Thomas Mueller < > thomas.tom.muel...@gmail.com > > wrote: > >> Hi, >> >> What database URLs do you currently use? >> >

Re: [h2] JDBC 4.0

Hi, We added db_close_delay because we have tests that open a Hibernate Session > (connection), do some work, close that Session (thus closing that > connection), open a new Session and try to do some work with the stuff done > in the initial Session. But H2 had dropped the database in between. >

[h2] Migrated to Github

Hi, The source code of H2 is now migrated to Github: https://github.com/h2database/h2database The list of issues could not be migrated, I hope I can still do that, but if not I guess it's not a big issue. The links from the web page will need to be changed. Regards, Thomas -- You received thi

Re: [h2] NULL Geometry index problem

Hi, As I already wrote, the bugfix and a test case are already committed in the trunk. Regards, Thomas On Thu, Apr 9, 2015 at 6:15 PM, John McMahon wrote: > Hi Thomas, > > Did you have time to look into this? > > Thanks > John > > On 8 April 2015 at 09:18, John McMahon wrote: > >> Minor corr

[h2] First query very expensive

Hi, I would say, it depends on what you do exactly... Regards, Thomas On Thu, Apr 9, 2015 at 12:13 PM, Cecil Westerhof > wrote: > The first time I send a query to H2 it takes around 25 seconds. All > subsequent queries are ready in less as a second. Is this normal? Can I > circumvent this? > >

Re: [h2] question abount MVStore: does MVStore support multithread?

Hi, Sorry I don't understand the question. After shutdown, the database is closed of course. Regards, Thomas On Thursday, April 9, 2015, sim wrote: > Hi, > > db returns in multi_threaded false state after executing shutdown defrag. > > Is that a normal behaviour? > > > -- > You received thi

Re: [h2] Query index selection with 'sub types'

Hi, I think you are missing an index on table B, column A. But probably the explain plan is a big confusing as well, not sure how to be fix this. Regards, Thomas On Tuesday, March 17, 2015, Fred&Dani&Pandora&Aquiles wrote: > Hi, > > > There are 2 tablescans in the query, there should only

[h2] in-memory mode memory consumption problem

Hi, I found some more issues with nioMemLZF, I will fix that as well. And add a test case. Also, the page sizes are probably too small, I will check that. By the way the prefixes are "nioMemFS:" and "nioMemLZF:". Regards, Thomas On Thursday, April 9, 2015, Ravi Sanwal > wrote: > There is a b

[h2] Re: Migrated to Github

Hi The Google Group will be kept. Regards, Thomas On Friday, April 10, 2015, Fred&Dani&Pandora&Aquiles wrote: > Hi, > > The discussions about the requests will move there now too, or you'll > still keep this group for a time? > > Regards, > > Fr

Re: [h2] Maven repository

Hi, Thanks! My mistake, I didn't copy all the files... I fixed it now, but it will take some more time until it is synchronized. Regards, Thomas On Sat, Apr 11, 2015 at 4:29 PM, bocher wrote: > > Dear Thomas, > > The maven repository contains only the sources for the last release > 1.4.187 (h

Re: [h2] H2 seems to create a huge number of orphan lobs since 1.4.183.

Hi, Yes, I added a timeout. First I wanted to keep the CLOB / BLOB objects only until the next transaction. The problem is that some methods in JdbcConnection started a new transaction (Statement.getQueryTimeout for example). It would be better if those transactions are not required, but thats a

[h2] MVMap LinkedHashmap

my purpose. > > Any suggestion? > > Regards, > Arun > > > On Friday, April 10, 2015 at 9:33:04 PM UTC+5:30, Thomas Mueller wrote: >> >> Hi, >> >> You would need to use a more recent version of H2. The version you are >> using does not support serializ

[h2] First query very expensive

Hi, As I already wrote, it depends on what you do exactly. If you don't give us that info, then we can't help I'm afraid. Regards, Thomas On Sun, Apr 12, 2015 at 12:55 PM, Cecil Westerhof > wrote: > 2015-04-12 12:03 GMT+02:00 Fred&Dani&Pandora&Aquiles >: > >> Hi Cecil, >> >> I tried that, but

[h2] upgrade from 1.0.x to newest version

Hi, > If this were just my local database I would do upgrade myself, but since this "old" version is on customer side, and most of them are computer unsavy this would be a no go... Well, you could automate that... Regards, Thomas On Tue, Apr 14, 2015 at 9:30 AM, Andy Rozman > wrote: > Ok. So

[h2] How to extract the where clause from a Select object?

Hi, > how to get the where clause? Well, why do you need it exactly? Regards, Thomas On Sun, Apr 12, 2015 at 6:39 PM, Pablo Beltran > wrote: > Hi Fred, > > I've searched for the condition attribute in the org.h2.command.dml.Select > class source code and it's declared as private: > > *private

Re: [h2] Any plan to move issues on googlecode to github ?

Hi, There was a problem migrating the Google Code issues to Github. Maybe this can still be resolved, but maybe its simpler to just keep the old issues in Google Code and not migrate them. For now, I would prefer if you just send an email with the issue report to this group instead of using the i

Re: [h2] NULL Geometry index problem

source.html?file=org/h2/mvstore/db/MVSpatialIndex.java&line=103&build=186>) > > at org.h2.mvstore.db.MVTable.addIndex(MVTable.java:433 > <http://h2database.com/html/source.html?file=org/h2/mvstore/db/MVTable.java&line=433&build=186>) > > at org.h2.com

[h2] How to extract the where clause from a Select object?

ke SQL queries from any standard industry reporting > tool like Birt, jasperReports, etc. > > I've provided a bit large answer because I think this is an interesting > business case for H2 as it can be used to wrap any custom language (even > Lucene queries, for instance) into stand

[h2] jvm memory leak issue

Hi, Could you tell us, what database URL and what options do you use? Which version was the database created with? Regards, Thomas On Thu, Apr 16, 2015 at 9:05 AM, Noel Grandin > wrote: > There are various possibilities: > > (1) Don't use SET LARGE_TRANSACTIONS TRUE > > (2) Very large result s

Re: [h2] Support to "EXTERNAL" table type

Hi, I will push the commit shortly. Regards, Thomas On Wednesday, April 15, 2015, bocher wrote: > > Hi, > > Please read https://github.com/h2database/h2database/pull/2. > > Erwan > > > Le mardi 14 avril 2015 19:31:09 UTC+2, wener a écrit : >> >> Any explain of "EXTERNAL" table type ? Glad to

[h2] H2 database is corrupt suddenly after a huge number of records is inserted

Hi, Do you have a reproducible test case that I could run? What is the database URL? Is this an old database or a fresh one? Regards, Thomas On Thu, Apr 16, 2015 at 8:27 AM, Sourav Mandal > wrote: > Hi, > We have been using H2 databases in our production, recently due to > one activity so

Re: [h2] NULL Geometry index problem

java:174) > at org.h2.mvstore.db.MVTable.removeRow(MVTable.java:611) > at org.h2.command.dml.Delete.update(Delete.java:94) > at org.h2.command.CommandContainer.update(CommandContainer.java:78) > at org.h2.command.Command.executeUpdate(Command.java:254) > at org.h2.jdbc.JdbcStatement.executeIn

Re: [h2] Database.allocateObjectId() performance degrades over time.

Hi, Thanks a lot for your help! I have merged the pull requests. I agree the bit field should not be needed. It is currently needed mainly for the PageStore storage mechanism; I think this can be removed once we only need to support the MVStore. Regards, Thomas On Wed, Apr 15, 2015 at 11:38 AM

Re: [h2] Guthub pull requests

Hi, I have merged the pull requests. > Next few months me and probably my colleagues from Apache Ignite will be contributing to H2 often That's great! By the way I'm an Apache committer as well (Apache Jackrabbit Oak). > it would be nice if pull requests will be processed faster. Unfortunately

Re: [h2] Update query performance - looking for ways to speed up

Hi, The problem seems to be that you use a slow algorithm, kind of like bubble sort instead of quicksort. Your algorithm seems to take quadratic time (twice the number of rows results in four times slower performance). Why don't you use just one update? update table XYZ set a_id = userDefine

Re: [h2] Don't add FK single column index if column is leading key of existing index

Hi, Yes, I think there was a change in this area because of a bug, but I don't fully remember. Could you please create a simple test case that shows the problem? I mean something like: drop all objects; create table parent(id int primary key); create table child(id int primary key, parent_id int

[h2] case insensitive query with case sensitive index

Hi, > You can have indexed column lower_x which will contain lower(x) and do queries like > ... where lower_x = lower(?) Yes. One addition: the column "lower_x" can be a computed column, so you don't have to update it yourself: create table test(x varchar, lower_x varchar as lower(x)); i

[h2] Database.allocateObjectId() performance degrades over time.

it does not make sense for non-snapshotable datastores. > > I assume your answer will be related to MVStore maturity, right? > > Sergi > > 2015-04-16 21:20 GMT+03:00 Thomas Mueller >: > >> Hi, >> >> Thanks a lot for your help! I have merged the pull reques

[h2] jvm memory leak issue

Hi, Most of those settings are dangerous, so I would expect you get a corrupt database (at least with the PageStore). But if it's just a cache, then that might be OK. I have to say that for others reading this email. Version 1.4.x (the MVStore) doesn't use that many temp files. The only situation

Re: [h2] NULL Geometry index problem

hanks again > John > > > > On 16 April 2015 at 12:07, Thomas Mueller > wrote: > >> Hi, >> >> You are right, this is not yet working. I will committed a fix for it >> shortly. However I'm not sure performance is good with many null entries (I >> didn

Re: [h2] find the last inserted/modified records on h2 database

Hi, I don't know what's wrong, but maybe your class is in a different package? Regards, Thomas On Tuesday, April 14, 2015, blu10 wrote: > Thanks!... > > Trying to test now > I created a Trigger class that implements the Trigger interface. I > compiled this to a class file and into a jar a

Re: [h2] jvm memory leak issue

Hi, I suspect we will have to do something similar to ImageIO and do our > own management. > I would like to avoid that. Instead, I would like to avoid temp files at all. With the MVStore, there is only one case where temp files are used (that I know of): very large transactions (updates, deletes

Re: [h2] Don't add FK single column index if column is leading key of existing index

Script attached. If you run in the browser console, >> you can browse the schema and see the two indexes. >> >> On Thursday, April 16, 2015 at 10:43:47 PM UTC-7, Thomas Mueller wrote: >>> >>> Hi, >>> >>> Yes, I think there was a change in this are

Re: [h2] "rename column" Oracle compatibility

Hi, As documented, for H2 the syntax is: ALTER TABLE ALTER COLUMN x RENAME TO y I'm not sure if Oracle supports that as well. As for rename, only renaming the columns is currently supported: ALTER TABLE tableName RENAME TO newName Patches are welcome! Regards, Thomas On Monday, Apri

Re: [h2] NPE while creating DBCP connection pool

Hi, That's strange. I see that a null password, salt, or hash results in a NPE, and I will fix that. But an existing database shouldn't have such users. Could you send me the database file? Regards, Thomas On Tuesday, April 21, 2015, Wes Clark wrote: > I am using the latest build 1.4.187. I a

Re: [h2] Update query performance - looking for ways to speed up

Hi, We cannot set A_ID to correct value (as part of insert) because this is an > ID column for the actual value column "A". > For example , column A could be "Customer Name" column. > The A_ID column for this column would be "Customer_ID". > I would probably try to combine those steps, so that yo

Re: [h2] Don't add FK single column index if column is leading key of existing index

> On Tue, Apr 21, 2015 at 10:59 PM, Thomas Mueller < > thomas.tom.muel...@gmail.com > > wrote: > >> Hi, >> >> Thanks a lot! Yes, I think it is a bug. I have a fix for it now. This is >> related to a bugfix in version 1.4.179, change log "Referential int

Re: [h2] MVSTORE and concurrent read/write

Hi, Yes, I will update the documentation. Regards, Thomas On Saturday, April 18, 2015, sim wrote: > Hi Noel, > > You was right, multi_threaded=true works fine. I can't see a thread > blocking any more, > but then h2 documentation has to be edited. > > Thank you. > > On Saturday, April 18, 201

Re: [h2] LinkedTable error when function-based index is present (Oracle)

Hi, Thanks for the patch! It looks good, I will commit it. Regards, Thomas On Saturday, April 18, 2015, Jared White wrote: > Greetings, > > When a LinkedTable is defined to point to a table in Oracle with a > function-based index, H2 throws a NullPointerException when attempting to > model th

[h2] MVStore issue

Hi, Could you post the error message and stack trace please? Regards, Thomas On Thu, Apr 23, 2015 at 1:25 PM, Rami Ojares > wrote: > Hi, > > I have reported a related issue but maybe I can give now more clues. > I am using 1.4.187 with mvstore and multithreaded true. > However this issue I am

[h2] GRANT SCHEMA Feature

Hi, Thanks a lot! The patch looks good. It's great to have good test cases! I did make the following changes: * Source code formatting / spaces: "} else {" instead of "}else{" and ") {" instead of "){". To automatically find those places, I use Checkstyle, with the configuration at src/installer

Re: [h2] GRANT SCHEMA Feature

to tests things (testGrantSchema, at the end), I fixed that. I added an entry in the change log. I updated the SQL syntax in the help.csv file. Regards, Thomas On Thursday, April 23, 2015, Thomas Mueller wrote: > Hi, > > Thanks a lot! The patch looks good. It's great to have good test cases!

Re: [h2] Use travis in H2

Hi, Using Travis is a good idea, I will have a look at it. In the past, I configured a Windows laptop to do a build (lasting about 3 hours, including code coverage) per night. This stopped working with Windows 7, because automated "waking up from suspend" no longer works. Currently, the automate

Re: [h2] request takes too much time

Hi, Do you have any indexes? Did you read http://h2database.com/html/performance.html ? Regards, Thomas On Sun, Apr 26, 2015 at 6:52 PM, sim wrote: > Hi, > > Let's assume I have two tables > > table clients > = > cl_id bigint primary key, > cl_name varchar > > table requests > ===

Re: [h2] Re: Serialization issue

Hi Sim, > Can't you create your own topic? I don't understand. As far as I see, it _is_ a separate topic (email subject). > I have set a custom serializer for Java object contained in columns of type OTHER Why can't you use the default serialization mechanism? What problem do you want to solve?

Re: [h2] NULL Geometry index problem

; indexes. > I fixed them and I created a push request for the change on Friday. > If you have time would you be able to take a look at it? > > Thanks > John > > > > On 17 April 2015 at 12:11, Thomas Mueller > wrote: > >> Hi, >> >> That's

Re: [h2] Timeline for Next Stable Release

Hi, Yes. The MVStore is what is beta. For that to be marked stable, I think we would need at least a few weeks where no issues are found with this storage. I would say were are almost there. The next release will still be beta, and then I think the MVStore can be marked as stable (unless something

Re: [h2] H2 error [90011-187] - Need a way to use relative dir

Hi, Many users ran into problems because they used something like "jdbc:h2:test" and then either didn't find the database file, or created a second database when running the application in a different directory. That's why in version 1.4.x, now relative path only work when using ".", as in "jdb:h2

Re: [h2] Problem with referential integrity

Hi, H2 simply drops the constraint as well in this case. I understand this is not how other databases work, this should be changed. H2 supports "drop ... restrict" and "cascade", but currently ignores it. Patches are welcome! Regards, Thomas On Monday, April 27, 2015, cmarquesumu wrote: > I am

Re: [h2] Patch: Session information, timestamps, and failed queries (Trace Log)

Hi, Thanks for the patch! I wonder, why do you need to log the session user, and not just the session id? I think I understand the problem you want to solve, but the patch is larger than necessary: logAndConvert could be overriden for example, which should make the patch a lot smaller. The patch

Re: [h2] SQL query not produce proper out put.

Hi, I wonder why the conditions are in "having" and not in "where". Also, I would probably use "module in (...)" instead of that many "or" conditions. But that shouldn't change the result. We would need to have a complete test case, including "create table" and "insert" statements. Regards, Thom

Re: [h2] H2 corrupted DB

Hi, The database is trying to read past the end of the file... Would it be possible to send me the database file to investigate? Regards, Thomas On Wednesday, April 29, 2015, Osvaldas Ziukas wrote: > This happend with newest H2 version i got and updated programs. h2-1.4.187.jar > > In 3 Days i

Re: [h2] Re: H2 seems to create a huge number of orphan lobs since 1.4.183.

Hi, > But already for many years the spatial support was provided by a combination of geodb + hatbox libraries and integration in GeoTools world Yes. However, those don't use the built-in R tree. Do they use an external R tree? > All these was done on BLOB type where a geometry WKB is stored.

Re: [h2] Single element array-literal?

Hi, The following should work for an empty, and single element array: select (); select (1,); But I agree it looks like a hack. Regards, Thomas On Mon, May 4, 2015 at 12:07 PM, wrote: > Hi Noel, > > your suggestion leads to the same result as cast (1 as ARRAY), the type of > the array e

Re: [h2] Don't add FK single column index if column is leading key of existing index

I get " > java.lang.UnsupportedClassVersionError: > org/h2/Driver : Unsupported major.minor version 52.0" trying to load the H2 > driver. Is there a Java compiler mismatch? We're using Java 1.7 64-bit. > > >> On Apr 22, 2015 10:44 PM, "Thomas Mueller" > &g

Re: [h2] Smallest disk space possible.

Hi, I would probably use INT. Small values use less space than large values, as variable size coding is used. Performance is not affected much; INT should be a bit faster but not much. Regards, Thomas On Saturday, May 2, 2015, Stig Christensen wrote: > Hi and thanks for a great database. I'm u

Re: [h2] H2 corrupted DB

Hi, That's strange. The last part of the file is missing. Looking at the H2 source code, the file truncate code is very simple and conservative (MVStore.shrinkFileIfPossible, which is calling getFileLengthInUse). It looks unlikely that there is a bug in this area. Could you describe what you did

[h2] Smallest disk space possible.

Hi, I think "smallint" doesn't use variable size coding, so with small values (1, 2, 3), using "int" actually saves space. If you have randomly distributed values within the range of smallint, then smallint uses less space. Regards, Thomas On Tue, May 5, 2015 at 7:45 A

Re: [h2] Bug in class org.h2.value.DataType (regarding type RESULT_SET)

Hi, Yes, I think this is a bug. I'm still working on a test case. Regards, Thomas On Tuesday, April 28, 2015, wrote: > Hi, > > in my opinion, the code below contains a bug in the last line. Shouldn't > it be > > *return ValueResultSet.get(x); * > > instead of > > *return ValueResultSet.get(rs

Re: [h2] JdbcPreparedStatement in Oracle mode don't honor treatEmptyStringsAsNull

Hi, Sorry I don't understand. What is the problem exactly? Where is the behavior of H2 different from Oracle? Regards, Thomas On Monday, May 4, 2015, Peter Fich wrote: > While using H2 as a replacement for Oracle in test, I have come across > this problem. > > Searching the group I have found

Re: [h2] Suitability of mvstore (stand-alone) in Android : robustness, processes killed, etc

Hi, The MVStore should work well with Android. The main differences to SQLite are: * SQLite overwrites / writes blocks of the size 4 KB. With flash or solid state disks this is not that great, as internally (by the firmware or OS) those writes are translated to much larger writes, for example 128

Re: [h2] Using index to speed up order by in joins

Hi, No, I'm sorry, I think there is currently no way to influence this. Regards, Thomas On Monday, May 4, 2015, Peter wrote: > I am having some problems with indices and order by in H2 1.3.176. I > managed to get it to work when I only query one table by: > * making sure the index has DESC s

Re: [h2] Performances of nested queries

Hi, I understand. However, I'm afraid I will not have time to work on this issues. I think those uses cases are not that common. Patches or ideas on how to fix this are welcome! Regards, Thomas On Sunday, May 3, 2015, Vitali wrote: > I would add also my case here. > > Seems a query like > >

Re: [h2] MVCC + Multithreaded

Hi, Yes this could explain the problem. See also the change log. Regards, Thomas On Monday, May 4, 2015, Rami Ojares wrote: > It seems that the database was running 187 but my webserver (and dev > client) was running 186. > Could that explain the problem? > > - Rami > > On 4.5.2015 15:54, Noel

Re: [h2] Don't add FK single column index if column is leading key of existing index

015 10:45 PM, Thomas Mueller > wrote: > > Hi, > > The nightly build is currently created with Java 8 (on a Raspberry Pi by > the way). I will switch to Java 7. > > Regards, > Thomas > > > On Friday, May 1, 2015, Wes Clark > wrote: > >> I am using t

Re: [h2] NPE in at org.h2.store.LobStorageBackend.copyLob(LobStorageBackend.java:453) becuase of TRIGGER initialization..

Hi, There were some changes in this area, and an important bugfix in version 1.4.187. If the LOB data was already removed before that, then I'm afraid the data can not be restored easily. See also the change log for details. Regards, Thomas On Sunday, May 3, 2015, Vitali wrote: > Hi. > > > H2

Re: [h2] Bug in class org.h2.value.DataType (regarding type RESULT_SET)

Hi, This should be fixed now, see https://github.com/h2database/h2database/commit/cfb2cc373854f39fe8e0511fd22ca248c48f662f Regards, Thomas On Wednesday, May 6, 2015, Thomas Mueller wrote: > Hi, > > Yes, I think this is a bug. I'm still working on a test case. > > Regard

Re: [h2] Backup & mvcc+multithreaded

Hi, > Should I still take my database offline when doing a backup? Either this, or use the "backup" SQL statement. With the MVStore storage, this should work very well. With the PageStore, it should also work, but I didn't test as much. Regards, Thomas On Friday, May 8, 2015, Ryan How wrote:

Re: [h2] Suitability of mvstore (stand-alone) in Android : robustness, processes killed, etc

Hi, I would like clarification on one item:* can I use mvstore reliably without > calling .close().* > Yes, that should work. However, please note that this scenario is not fully tested yet (as much as with SQLite). At the moment, I would either ensure it works for you with your own tests, or don

Re: [h2] MVCC + Multithreaded

mi > > On 6.5.2015 10:46, Rami Ojares wrote: > > Ok, I will put the multithreaded back on making sure all clients are also > using version 187. > I will report if the corruption turns up again after that. > > - Rami > > On 6.5.2015 9:21, Thomas Mueller wrote: >

Re: [h2] NPE in at org.h2.store.LobStorageBackend.copyLob(LobStorageBackend.java:453) becuase of TRIGGER initialization..

gt; initialized earlier than LOB storage is initialized in Database class. > > > > Vitali. > > On Wednesday, May 6, 2015 at 9:21:48 AM UTC+3, Thomas Mueller wrote: >> >> Hi, >> >> There were some changes in this area, and an important bugfix in version &g

[h2] Database corrupt after computer power failure.

Hi, Thanks a lot! I have analyzed the database file, and I think I know what the problem is. It looks like the disk (or operating system) re-ordered write operations, so that changes later in time (and later in the file) were written, but one earlier change (both in time and in the file) was not w

Re: [h2] Moving from H2 1.3.176 to 1.4.187 results in sporadic ArrayIndexOutOfBoundsExceptions?

Hi, I don't know what the problem could be. There were no changes in this area. What is strange is: The exception says it is trying to read past the end of a page that is 2048 bytes long. The default page size is 4096 bytes, did you set it manually to 2048 bytes? According to the database URL it

Re: [h2] How to display the output of the "EXPLAIN ANALYZE" command?

Hi, Do you mean, how to get the information without having to change the SQL statements (without adding "explain analyze")? You can't. Regards, Thomas On Friday, May 8, 2015, Kriss Lu wrote: > I am tracing the performance of a program with "explain analyze" command. > I run this command in H2

[h2] JdbcPreparedStatement in Oracle mode don't honor treatEmptyStringsAsNull

Hi, Ah sorry, I thought the test already passes... You are right, this is unexpected. I have fixed it now. However, this is a tricky area. If I was you, I would avoid relying on this behavior of Oracle, because no other database works like this. Regards, Thomas On Wednesday, May 6, 2015, Peter

Re: [h2] Database corrupt after computer power failure.

ble on that PC. > (The affected PC runs Windows 7, and uses a Samsung 850 EVO SSD drive if > that matters.) > > /Mikael > > > Den fredag 8 maj 2015 kl. 18:12:07 UTC+2 skrev Thomas Mueller: >> >> Hi, >> >> Thanks a lot! I have analyzed the database file,

Re: [h2] Re: Recover failed

Hi, There were quite a few bugfixes since version 1.4.181, but it's hard to say what the reason is. Could you send me the database file? I would be interested to analyze it, and (hopefully) I can improve the recover tool so that it can process it. Regards, Thomas On Thu, May 14, 2015 at 3:12 AM

[h2] Re: Accessing H2 via PostgreSQL ODBC driver

Hi, This should be documented under http://h2database.com/html/advanced.html#odbc_driver Regards, Thomas On Friday, May 8, 2015, syed usman wrote: > Hi Victor, > > Can you please list me the steps you use to connect h2 server via > postgresql odbc driver. > I am actually trying to connect Ru

Re: [h2] Unable to create trace.db file in case of in memory database

Hi, Yes, you can't log to a file when using the in-memory mode. You would need to use the persistent mode (save the database file on disk). Or, you could use Slf4J, as documented here: http://www.h2database.com/html/features.html?highlight=SLF4J&search=slf4j#other_logging Regards, Thomas On Mo

Re: [h2] Triggers, finding the table name that trigger fired against?

Hi, > I see them on the method signature for the init method but this is hit when the triggers are set up not when the trigger is actually fired... Yes. If you need to know the table name, you could keep that in a field within the trigger class. Regards, Thomas On Mon, May 11, 2015 at 11:1

Re: [h2] Slow insert on index vs hsqldb

Hi, I think in this case, HSQLDB keeps the index on disk. I ran the test on my machine and it looks like there is a problem in H2 here when using the PageStore (which is the default for the version of H2 you are using). With a recent version of H2 (with the MVStore), it is much better, even thoug

Re: [h2] Erroraccessingdatabase

Hi, I think this issue was resolved in version 1.4.179, see the changelog entry: - Databases created with version 1.3.175 and earlier that contained foreign keys in combination with multi-column indexes could not be opened in some cases. This was due to a bugfix in version 1.3.176: Refer

Re: [h2] Unique index or primary key violation: "PRIMARY KEY ON """".PAGE_INDEX" error

Hi, I think this issue was resolved in version 1.4.179, see the changelog entry: - Databases created with version 1.3.175 and earlier that contained foreign keys in combination with multi-column indexes could not be opened in some cases. This was due to a bugfix in version 1.3.176: Refer

Re: [h2] Missing jar file in maven repository

Hi, It looks like there is a wrong pom file on maven.org. I'm afraid I can't fix that on my side. The original file are here: http://hsql.sourceforge.net/m2-repo/com/h2database/h2/1.4.187/h2-1.4.187.jar http://hsql.sourceforge.net/m2-repo/com/h2database/h2/1.4.187/h2-1.4.187.pom http://h2database

Re: [h2] Strange NoClassDefFoundError with 1.4.178

ot just > a local configuration issue. > > Please see also: > > http://stackoverflow.com/questions/23572460/h2-database-in-tomcat-with-server-mode-and-automatic-mixed-mode-when-using-activ > > Grüße, > Aydin > > > Am Freitag, 13. Juni 2014 15:20:11 UTC+2 schrieb Thomas Mu

Re: [h2] Slow insert on index vs hsqldb

Hi, Why is it that MVStore ends up using 10 timers more disk space in this test? > By default, the MVStore keeps the data of the last 45 seconds. After that, the disk space is re-used. The database file size will usually shrink when you close the database. Regards, Thomas -- You received this

[h2] Re: Auto number next value of identity column skips numbers

Hi, Could you provide a simple, small, reproducible test case please? Regards, Thomas On Monday, May 25, 2015, Meni Hillel wrote: > Thanks Jose. > > I saw this issue and I did not think it applied to me. In my case, it does > not skip in 32, there was no crash. I think the cause in my case is

[h2] Re: Auto number next value of identity column skips numbers

that a multi-threaded transactions that attempts to create the same > record in a table would reproduce it. > > Meni > > On Mon, May 25, 2015 at 10:43 PM, Thomas Mueller < > thomas.tom.muel...@gmail.com> wrote: > >> Hi, >> >> Could you provide a simple,

Re: [h2] Negative zero of DOUBLE type

Hi, ABS(0.0) is negative zero. > I think this is a bug, I will fix it. -0.0 is allowed and not turned into 0.0. > Yes, this is how Java behaves. > -0.0 is not zero. > This is somewhat unexpected, but I think it is reasonable. H2 uses Double.compare(x, y), which first checks the sign. ABS(-0

Re: [h2] Error after encryption (H2 1.4.186)

Hi, You would need to describe the exact steps (what did you do exactly, how did you do it). Regards, Thomas On Thu, May 28, 2015 at 10:29 AM, z161 < harael...@hotmail.com> wrote: > Hello, > > > i'm a newcomer to H2 and i want to use it either with a Java application > or with

Re: [h2] Oracle TRUNC(date, datepart) support

Hi, > I can also create a patch and contribute. That would be great! A patch would be very welcome. Regards, Thomas On Thu, May 28, 2015 at 10:37 AM, Václav Tregner wrote: > Do you plan to add Oracle's TRUNC(date, datepart) function? I will very > appriciate it. I can also create a patch an

Re: [h2] Suitability of mvstore (stand-alone) in Android : robustness, processes killed, etc

; > Nicolas Fortin > IRSTV FR CNRS 2488 > GIShttp://orbisgis.org > Spatial DB http://h2gis.org > Noise http://noisemap.orbisgis.org > > > > Le vendredi 8 mai 2015 07:42:36 UTC+2, Thomas Mueller a écrit : >> >> Hi, >> >> I would like clarifica

Re: [h2] Any plan to move to maven ?

Hi, I'm not really interested to "Mavenize" everything. It would be nice to have a Maven build for the _default_ setup, to simplify setting up the IDE. I personally didn't have much trouble importing H2 into Eclipse, but I understand it could be easier. But building the installer or the docs or e

Re: [h2] out of memory with big db

Hi, I'm sorry, but H2 does not work well if you have thousands of tables. Regards, Thomas On Tuesday, June 2, 2015, Ryan How wrote: > Maybe you are better off with a different database for each "book", and > open and close them 1 at a time? > > It really depends on your application... > > >

<    6   7   8   9   10   11   12   13   14   15   >