[h2] Re: Anybody actively working on support for ROW_NUMBER() OVER ([PARTITION BY])?

2017-03-19 Thread Philippe Marschall
On Friday, March 17, 2017 at 8:09:09 PM UTC+1, Charles Woerner wrote: > > Hi, > > Thank you for your great work on H2. I work at Quantcast and we use it > extensively for unit testing. I'm just wondering whether anyone has > actually ever taken (or is currently taking) a stab at the Priority 2

[h2] Re: H2 database how to use external library like apache.commons

2017-01-07 Thread Philippe Marschall
AFAIK you can only create aliases for static methods. You would have to create static method that instantiates StandardDeviation, invokes the method and return the result. Then you would create an alias for this static method. Cheers Philippe On Friday, January 6, 2017 at 8:03:55 PM UTC+1,

[h2] Re: Errors in the DBMS comparison

2016-10-23 Thread Philippe Marschall
On Tuesday, August 30, 2016 at 11:56:31 PM UTC+2, Thomas Kellerer wrote: > > I think there are some errors in the DBMS comparison at: > http://www.h2database.com/html/features.html#comparison > > Postgres has "Linked tables" through Foreign Data Wrappers: >

Re: [h2] Re: Update from 1.4.191 to 1.4.192 leads to unit test failure

2016-10-03 Thread Philippe Marschall
On Thursday, September 29, 2016 at 8:06:20 AM UTC+2, Wim Deblauwe wrote: > > Good to hear that there is a fix. For now, I replaced: > > jdbcTemplate.queryForObject("SELECT image_id FROM game", Object.class) > > with: > > jdbcTemplate.queryForObject("SELECT image_id FROM game", byte[].class) >

Re: [h2] Re: Update from 1.4.191 to 1.4.192 leads to unit test failure

2016-10-03 Thread Philippe Marschall
On Wednesday, September 28, 2016 at 8:43:22 AM UTC+2, Noel Grandin wrote: > > That is unfortunate. > > Luckily Philippe Marschall has already implemented that method properly, > so if you build a jar from our repository, that should fix your bug. > Well byte[] was one of the

Re: [h2] org.h2.api.TimestampWithTimeZone questions

2016-09-21 Thread Philippe Marschall
On Tuesday, September 20, 2016 at 9:24:03 AM UTC+2, Noel Grandin wrote: > > > > On 20 September 2016 at 08:13, Philippe Marschall <philippe@gmail.com > > wrote: > >> Hi >> >> I'm looking at org.h2.api.TimestampWithTimeZone in the master branch &

[h2] org.h2.api.TimestampWithTimeZone questions

2016-09-20 Thread Philippe Marschall
Hi I'm looking at org.h2.api.TimestampWithTimeZone in the master branch compared to the 1.4.192 release and have a few questions - Why return getYear(), getMonth() and getDay() longs instead of ints? - timeNanos appears to be in the timeZone rather than UTC, am I understanding this

[h2] Patch for getObject

2016-09-15 Thread Philippe Marschall
Hi I submitted a patch for getObject(int, Class) and getObject(String, Class) for both JdbcResultSet and JdbcCallableStatement [1]. I wrote the code, it's mine, and I'm contributing it to H2 for distribution multiple-licensed under the MPL 2.0, and the EPL 1.0

Thanks for Oracle Sequence Support

2010-09-01 Thread Philippe Marschall
Hi I just wanted to say thank you for Oracle sequence support: SELECT foo.nextval FROM dual It's a big help to us. Cheers Philippe -- You received this message because you are subscribed to the Google Groups H2 Database group. To post to this group, send email to