[h2] h2 database to Core Data

Hi everyone, does anybody know if it is somehow possible to migrate the data from H2 Database to Core Data database system. Background: We have mac app in app store. The app is java application, using H2 database and we're going to rework the app to native one, using Core Data. H2 is java DB,

Re: [h2] Negative zero of DOUBLE type

Hi Thomas, A patch with simple test cases would be nice (maybe a simple SQL script with a few cases). I would like to test this with other databases as well. A simple test case where all columns should be TRUE: SELECT (CAST('-0.0' AS DOUBLE)) = (CAST('0.0' AS DOUBLE)), ((CAST('-0.0' AS

Re: [h2] H2 Server Start from Java code.

Hi Thomas, Thanks for all the suggestions. Since the latest MV store is not there with the stable release, i cannot use it in the dev environment. However, there is a new problem now. As told by you to specifically mention the port number while instantiating the Server as 9092. I did try

Re: [h2] Cast to array

On 2015-06-18 12:23 PM, christoff.schm...@finaris.de wrote: Is there a specific reason why the expression *CAST**(**5 **AS **ARRAY**)* results in an array containing a VARCHAR value instead of a numeric value? Or might this be a bug? It's probably like this because it was the simplest

Re: [h2] Order by is broken in 1.4.186 (2015-03-02), Beta

Thanks for sticking with it and solving the puzzle for me (and all of us), Thomas! That’s a lot of bits to combine, and so many of us use H2 for testing, where this would show up. Dave On Jun 18, 2015, at 1:51 AM, Thomas Mueller thomas.tom.muel...@gmail.com wrote: Hi, Thanks a lot! I

[h2] H2: embedded multiple connections and multiple threads

I've read this http://www.h2database.com/html/features.html#connection_modes and this http://www.h2database.com/html/features.html#multiple_connections and anyway it's not quite clear for me. I have GUI application which uses h2 database in embedded mode. Application is multi threaded. Every

Re: [h2] H2: embedded multiple connections and multiple threads

On 2015-06-18 04:43 PM, iJava wrote: I've read this http://www.h2database.com/html/features.html#connection_modes and this http://www.h2database.com/html/features.html#multiple_connections and anyway it's not quite clear for me. I have GUI application which uses h2 database in embedded mode.

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

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

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

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

Re: [h2] MVStore with MVCC performance degradation

Hi, The missing lob entry sounds like you try to access LOB after it has been deleted or updated, or after the result set has been closed. Do you know if that's possible? Please note the stack trace is missing in your error message. Regards, Thomas On Wednesday, June 17, 2015, Wes Clark

Re: [h2] Negative zero of DOUBLE type

Hi, Changing ValueFloat.get and ValueDouble.get should be enough, but I didn't test it yet. By the way, I will be on vacation for the next two weeks. I hope I can review patches then, but I don't think I will be able to work in it much. Regards, Thomas On Thursday, June 18, 2015, Christopher

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

Hi, Such questions are best asked at StackOverflow.com, because they apply to SQL in general and not to a specific product. I guess I would convert null to empty string or empty string to null. Regards, Thomas On Thursday, June 18, 2015, Rinse Lemstra r.lems...@xso.nl wrote: The resultset

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

The resultset contains fields from two joined tables. The result field from the joined table is a varchar. a) If there is a match on ID between the two tables and the field has a value, the value is returned b) If there is a match on ID between the two tables and the field has no value, the

[h2] Database Grows Rapidly

Hi, I am exploring H2 as a candidate for embedded data storage in our application. I like a lot of the features it offers. However, the database seems to grow very large, very quick. I have read a lot of forum threads and such about how this is typically caused by uncommitted transactions. I

[h2] Cast to array

Hi, Is there a specific reason why the expression CAST(5 AS ARRAY) results in an array containing a VARCHAR value instead of a numeric value? Or might this be a bug? Kind regards, Christoff Schmitz