[h2] Sponsorship/funding for issue #156 - Support getGeneratedKeys() for batches

2016-01-07 Thread Rob Bygrave
Hi, I have just added a comment on #156 saying that I would like to try and organise sponsorship/funding for #156. I don't know what the correct way to go about this is so I'm looking for guidance on that. Someone can contact me directly via robin.bygave (at) gmail dot com if you wish to discu

Re: [h2] Failing Daylight savings test with 1.4.182 ... was working on 1.3.153

2014-12-15 Thread Rob Bygrave
gt; difference -360 > > So I don't consider this a bug of H2. You could call it a bug of the Java > date / time processing, or at least unexpected behavior. > > With H2, if you _don't_ use java.sql.Timestamp, but instead use String > (even with "timestamp"

Re: [h2] like ? escape'' ... not working in 1.4.182 but was in 1.3.153

2014-11-28 Thread Rob Bygrave
Yes I can do that. I'll look to do that tomorrow night now as it is a bit late here now. Cheers, Rob. On 28 November 2014 at 23:39, Noel Grandin wrote: > Can you create a standalone sequence of SQL commands? > > i.e. CREATE TABLE ... > INSERT... > SELECT > > and then I can test thi

[h2] Failing Daylight savings test with 1.4.182 ... was working on 1.3.153

2014-11-28 Thread Rob Bygrave
Hi, So I have a test that is now failing when upgrading from 1.3.153 to 1.4.182 The test code is: @Test public void testDirect() throws SQLException { // For it to fail, the time has to match the time at which the daylight saving changes // are applied in that time zone. Therefor

[h2] like ? escape'' ... not working in 1.4.182 but was in 1.3.153

2014-11-28 Thread Rob Bygrave
Hi, I suspect there is an issue with 1.4.182 using escape'' (I have been using escape'' with the view to disabling the escaping of backslash) // these first 3 queries return count = 10 which is expected int *count0* = select t0.id c0 from uuone t0 where t0.name *like ?* order by t0.nam

Re: DECRYPT requiring UTF8TOSTRING and TRIM functions

2010-01-28 Thread Rob Bygrave
Thanks - just what I was after. I haven't had a chance to try it yet but I'm sure that will be just what I was after. Thanks, Rob. On Jan 26, 8:22 am, Thomas Mueller wrote: > Hi, > > > I am wondering if/how I can make the syntax cleaner. To be closer to > > that of Postgres pgp_sym_decrypt, MyS

Re: Encryption using java PreparedStatement

2010-01-24 Thread Rob Bygrave
Hmmm, not sure what you are trying to achieve but... - You are using CALL ... so should be using a CallableStatement rather than a PreparedStatement ? - You are using STRINGTOUTF8(?) ... on a byte[] (which is not a string) Note: I'm using ENCRYPT(...) with insert/update statements. Maybe that h

DECRYPT requiring UTF8TOSTRING and TRIM functions

2010-01-23 Thread Rob Bygrave
Hi, I'm adding encryption/decryption support to Ebean ORM. Currently with H2 I am combining DECRYPT UTF8TOSTRING and TRIM functions. An example query ends up like: select e.id c0, e.name c1, TRIM(CHAR(0) FROM UTF8TOSTRING(DECRYPT ('AES', STRINGTOUTF8(?), e.description))) c2, e.last_update c3 fro