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

2017-02-23 Thread Christian MICHON
on point 2: it can be easily done with spark (sparkjava.com not apache spark) + jooq You'll need to ensure security, using json web tokens for example. On Thursday, February 23, 2017 at 3:47:33 AM UTC+1, Adam McMahon wrote: > > Hi Group, > > i am considering a project that may require me to conn

Re: [h2] Table function not case insensitive

2017-02-23 Thread Thomas Mueller Graf
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 that comparison is case >

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

2017-02-23 Thread Nicolas Humeau
Hi, I'm using version 1.4.193. What do you mean by create a test case? I'm not sure I understand. By the way I ran several test on linux rather 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 : > >

Re: [h2] H2

2017-02-23 Thread Thomas Mueller Graf
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 > see earlier. Ok i

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

2017-02-23 Thread Thomas Mueller Graf
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) EclipseLink 2.6 > 4) H2 1.4.1

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

2017-02-23 Thread Thomas Mueller Graf
Hi, Well I can't reproduce the problem. I understand creating a unit test might be complicated. Could you provide the following info? * File size * Run the MVStore tool with "-info " (java -jar ... org.h2.mvstore.MVStoreTool -info <...>) and provide the output (possibly attached if it's large)

[h2] Re: Connection Properties

2017-02-23 Thread Thomas Mueller Graf
Hi, If you have a patch (with test case) then we can have a look at it. Regards, Thomas On Monday, January 23, 2017, Jon Freedman wrote: > A few years later, but more details: > > My property is passed into org.h2.Driver#connect inside the info > Properties object. > org.h2.engine.ConnectionIn

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

2017-02-23 Thread Thomas Mueller Graf
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 READ_COMMITTED transaction

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

2017-02-23 Thread Adam McMahon
>>You'll need to ensure security, using json web tokens for example I have never used spark, looks fun (bad name for a project considering apache spark dominates the "spark" name). I was thinking Jetty would be pretty ideal, and/or restlet. I also like Grizzly. Vertx. is great, but maybe over

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

2017-02-23 Thread Christian MICHON
Spark contains an embedded jetty out of the box, and it's compatible with SSL and keystores. I might contribute code if you open a github project. I usually handle this "proxy" access to H2 using jruby, but it's straight forward to make the concept you described in java. Christian On Thursday

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

2017-02-23 Thread Adam McMahon
Hi, How does jRuby help in this situation? Is there a particually nice jRuby http server that you use to wrap h2? -Adam On Thursday, February 23, 2017 at 4:56:23 PM UTC-5, Christian MICHON wrote: > > Spark contains an embedded jetty out of the box, and it's compatible with > SSL and keystore

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

2017-02-23 Thread Christian MICHON
Jruby was used to write an proxy data API server using Sequel and Roda. Since it's ruby inside java, connections to H2 are fully supported via Sequel. For the container, I used Puma. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscrib