Re: [h2] What is the best way to persist data to disk using H2 as an embedded in-mem database?

Hi, > what we would like is be able to snapshot only the incremental changes. Well, it sounds like what you really want is a persisted database with a very large cache. Did you try that? > for the same amount of data, does loading from an equivalent csv file faster than this way? There is no de

[h2] Re: H2 database and Excel VBA

Hi all, im new to this topic and h2, do you know a good way to connect c# code to h2 database? > > I would like to use it together with an entity data model. My connection string looks like this: protected const string ConnectionFormatString = "metadata=res://{0}/{1}LocalDatabase

Re: [h2] H2 more detailed Syntax Exception

On 2013-08-02 16:59, Nicolas Fortin (OrbisGIS) wrote: Hi, I'm currently writing a add-on on RSyntaxText Area in order to underline in red syntax error in sql window, and also to autocomplete sql. In order to do that I was thinking about using H2 explain statements, catch exception and parse

[h2] H2 more detailed Syntax Exception

Hi, I'm currently writing a add-on on RSyntaxText Area in order to underline in red syntax error in sql window, and also to autocomplete sql. In order to do that I was thinking about using H2 explain statements, catch exception and parse it. Parse String message is really crap, then I think abo

Re: [h2] Searching for words

2013/8/2 Noel Grandin : > > On 2013-08-02 15:10, Cecil Westerhof wrote: >> >> 2013/8/2 Noel Grandin : >>> >>> On 2013-08-02 14:27, Cecil Westerhof wrote: I had to search for an article containing fish. Just using LIKE '%fish%' resulted in much to many. So I used '% fish %', but did n

Re: [h2] Searching for words

On 2013-08-02 15:10, Cecil Westerhof wrote: 2013/8/2 Noel Grandin : On 2013-08-02 14:27, Cecil Westerhof wrote: I had to search for an article containing fish. Just using LIKE '%fish%' resulted in much to many. So I used '% fish %', but did not find, what I knew existed. Turns out fish was at

Re: [h2] Searching for words

2013/8/2 Noel Grandin : > > On 2013-08-02 14:27, Cecil Westerhof wrote: >> >> I had to search for an article containing fish. Just using LIKE >> '%fish%' resulted in much to many. So I used '% fish %', but did not >> find, what I knew existed. Turns out fish was at the end of he >> sentence and I f

Re: [h2] Searching for words

On 2013-08-02 14:27, Cecil Westerhof wrote: I had to search for an article containing fish. Just using LIKE '%fish%' resulted in much to many. So I used '% fish %', but did not find, what I knew existed. Turns out fish was at the end of he sentence and I found it with '% fish%'. Is there a way

[h2] Searching for words

I had to search for an article containing fish. Just using LIKE '%fish%' resulted in much to many. So I used '% fish %', but did not find, what I knew existed. Turns out fish was at the end of he sentence and I found it with '% fish%'. Is there a way to search for whole words? -- Cecil Westerhof

Re: [h2] Embedded db with multiple client connections = Error message on trace files

Hi, It could be a problem of the "serialized" access mode in combination with your networked file system. Which file system do you use, and which operating system(s)? How many clients? If the file system is NFS, what are parameters? I know networked file systems are problematic, would it be possi

Re: [h2] Database-level custom serialization for columns of type OTHER: patch proposal

On 2013-08-02 12:31, davide.cavestro wrote: Hi Noel, I ventured into implementing the /JAVA_OBJECT_SERIALIZER/ command... just to try :-). So I would end up with three ways to set a serializer: 1. at jvm level 2. at db level through the jdbc url 3. at db level in a persistent way through the /SE

Re: [h2] Database-level custom serialization for columns of type OTHER: patch proposal

Hi Noel, I ventured into implementing the /JAVA_OBJECT_SERIALIZER/ command... just to try :-). So I would end up with three ways to set a serializer: 1. at jvm level 2. at db level through the jdbc url 3. at db level in a persistent way through the /SET JAVA_OBJECT_SERIALIZER/ command. That makes

Re: [h2] TableEngine DBase

Hi, > It should be good to find a generic interface that file drivers must implements What about something similar to MVRTreeMap? We could define an interface. Then, I guess we might be able to create an "adapter" that internally uses both DBF/SHP files and the MVRTreeMap, overlaid, like UnionFS

Re: [h2] Re: execute() with stored procedures that don't return a ResultSet

Hi, > Are there other "SQL statement types" in H2 that a CallableStatement can represent? Sure. Within H2, you can execute all SQL statements (select, update, create,...) with a CallableStatement. And you can execute any SQL statement with PreparedStatement and Statement. Regards, Thomas On

Re: [h2] H2 restart functionality

Hi, What is your database URL? Also, it would be great if you have a small, reproducible test case. Regards, Thomas On Wed, Jul 31, 2013 at 10:36 AM, Noel Grandin wrote: > It should be synchronous, we join() all of the threads. > But it sounds like we're missing a thread somewhere. > > Could y