[h2] Re: csvread varbinary "Hexadecimal string with odd number of characters"

2014-03-14 Thread Brian Craft
Nevermind... the file wasn't being flushed, so the line was truncated. On Friday, March 14, 2014 6:26:43 PM UTC-7, Brian Craft wrote: > > Is there a way to csvread a varbinary column? I tried dumping it as hex > (from another source), but h2 barfs about half way through. It seems to be > doing

[h2] csvread varbinary "Hexadecimal string with odd number of characters"

2014-03-14 Thread Brian Craft
Is there a way to csvread a varbinary column? I tried dumping it as hex (from another source), but h2 barfs about half way through. It seems to be doing the hex conversion, but then exits with Hexadecimal string with odd number of characters: "444C444C444C444C444C444C43

[h2] Re: GEOMETRY documentation

2014-03-14 Thread bocher
Hi, Have a look at http://www.h2gis.org/ Erwan --- RISING team CNRS - Ecole Centrale de Nantes BP 92101 1 rue de la Noë, 44321 NANTES Cedex 3 France Tél : 02 40 37 68 67 http://www.ec-nantes.fr/ Le vendredi 14 mars 2014 20:31:34 UTC+1, Sergi Vladykin a écrit : > > Guys, > > As I see currently

[h2] GEOMETRY documentation

2014-03-14 Thread Sergi Vladykin
Guys, As I see currently H2 supports spatial type GEOMETRY but documentation about it really scarce. It just says that it is a string in WKT format, but nothing about how to use in from SQL. Which operators it supports? What are current limitations? It should be nice to see some examples as we

[h2] shared read lock messages

2014-03-14 Thread Brian Craft
Doing a data load, I notice in the trace file (level 3) it's writing about 5000 of these per second: 03-14 11:10:03 lock: 2 shared read lock requesting for PROBEMAPS 03-14 11:10:03 lock: 2 shared read lock requesting for PROBEMAPS 03-14 11:10:03 lock: 2 shared read lock requesting for PROBEMAPS 0

Re: [h2] State of DDL compatibility for MySQL

2014-03-14 Thread Peter Jentsch
Ok, thanks for the quick response. I'll try to hack up a patch then :-) Peter Am Freitag, 14. März 2014 08:17:19 UTC+1 schrieb Noel Grandin: > > > Other than reading the source code, unfortunately not. > > However, we are always open to patches to improve the situation :-) > > On 2014-03-13 12:

[h2] OSGi Manifest for H2 snapshot

2014-03-14 Thread Nicolas Fortin (OrbisGIS)
Hi, I work on how to define a valid snapshot release manifest for H2. It should be used in the release of h2-latest.jar The result is here: Manifest-Version: 1.0 > Implementation-Title: H2 Database Engine > Implementation-URL: http://www.h2database.com > Implementation-Version: 1.3.176-SNAPSHO

Re: [h2] DB growth when using TEMPORARY TABLE NOT PERSISTENT?

2014-03-14 Thread Uli
The test case is attached to my post 9:07 AM. Thanks! On Friday, March 14, 2014 9:55:17 AM UTC+1, Noel Grandin wrote: > > Sorry, then I don't know what is going on. > > If you can generate a standalone test-case I could take a look at it. > > On 2014-03-14 10:45, Uli wrote: > > I am using 1.3.

Re: [h2] DB growth when using TEMPORARY TABLE NOT PERSISTENT?

2014-03-14 Thread Noel Grandin
Sorry, then I don't know what is going on. If you can generate a standalone test-case I could take a look at it. On 2014-03-14 10:45, Uli wrote: I am using 1.3.175 -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this grou

Re: [h2] DB growth when using TEMPORARY TABLE NOT PERSISTENT?

2014-03-14 Thread Uli
I am using 1.3.175 -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@goog

Re: [h2] DB growth when using TEMPORARY TABLE NOT PERSISTENT?

2014-03-14 Thread Noel Grandin
What version are you using? That sounds like a bug we had a few versions ago. On 2014-03-14 10:07, Uli wrote: The DB grows to > 1 GB when I have added all in all around 3 rows. It seems to me that the pages used for handling the resultset are not reused by the database. -- You received th

Re: [h2] change h2 order criteria

2014-03-14 Thread Thomas Mueller
Hi, > In Oracle the order will be: > a124sb > bb1234 > 1bbe42 This is not what I get when testing with http://sqlfiddle.com. I get the same order as H2 (and all other databases I tested with). Maybe you are using EBCDIC encoding? Regards, Thomas On Fri, Mar 14, 2014 at 8:24 AM, Noel Grandin

Re: [h2] DB growth when using TEMPORARY TABLE NOT PERSISTENT?

2014-03-14 Thread Uli
Hi Noel, that sounds reasonable. I just wonder why the database grows continously to > 1GB. I have changed the test program as follows: In case a db growth is detected (after the memory table is larger than 1 rows) the memory table is shrinked to 9000 items. Inserting rows continues and I

Re: [h2] NPE using FILE mode with 1.3.175

2014-03-14 Thread Thomas Mueller
Hi, To find out what version of H2 you are using, could you post the complete stack trace including error message and error codes? Regards, Thomas On Thu, Mar 13, 2014 at 11:15 PM, Wes Clark wrote: > The JDBC URL being used is > > jdbc:h2:file:/tmp/guidewire/emerald/px;MVCC=TRUE > > > On Thu

Re: [h2] NPE preparing a SELECT on 1.3.175

2014-03-14 Thread Thomas Mueller
Hi, > Should I wait for the next build? You can try the latest jar file: http://h2database.com/html/build.html#automated > Will this be fixed in I fall back to Version 1.3.174? Yes, version 1.3.174 shouldn't have this problem. Regards, Thomas On Thu, Mar 13, 2014 at 6:32 PM, Wes Clark wro

Re: [h2] DB growth when using TEMPORARY TABLE NOT PERSISTENT?

2014-03-14 Thread Noel Grandin
That sounds like you are managing to trigger the creation of a temporary table to handle a resultset larger than 1 rows. You can tweak that setting here: http://h2database.com/html/grammar.html#set_max_memory_rows On 2014-03-05 11:39, Uli wrote: Hi, After inserting 10002 rows the database

Re: [h2] change h2 order criteria

2014-03-14 Thread Noel Grandin
You could define a custom collator using: http://h2database.com/html/grammar.html#set_collation But I suspect it would be a little tricky. On 2014-03-13 19:11, David Melo wrote: in oracle the "letters" goes first, and H2 the "numbers" go first. -- You received this message because you are

Re: [h2] State of DDL compatibility for MySQL

2014-03-14 Thread Noel Grandin
Other than reading the source code, unfortunately not. However, we are always open to patches to improve the situation :-) On 2014-03-13 12:51, Peter Jentsch wrote: Hi, we're currently using H2 as embedded database for unit tests for as system that runs on MySQL in production. The DDL is ver