[h2] Multi Return Fields in Generated Keys

2017-04-18 Thread Juan Ismael Vasquez
Hi. I am using H2 in some JUnit. In production, the Data Access Objects are connected to an Oracle. And I have the following table: CREATE TABLE "USER"( "ID" NUMBER, "PASSWORD" NVARCHAR2(50), "EMAIL" NVARCHAR2(50), "GUID" RAW(16) DEFAULT RANDOM_UUID() . . ); I h

Re: [h2] Multi Return Fields in Generated Keys

2017-04-18 Thread Kerry Sainsbury
On 19 April 2017 at 03:37, Juan Ismael Vasquez wrote: > getGeneratedKeys I wonder how Oracle is deciding that "GUID" RAW(16) DEFAULT RANDOM_UUID() is a key -- it's doing quite a bit of introspection and making of assumptions. I would've thought that H2 was behaving quite sensibly. That said, a

Re: [h2] Multi Return Fields in Generated Keys

2017-04-28 Thread Juan Ismael Vasquez
Hi Kerry. I don't know what are Oracle doing too. At first, I thought that the problem was an index in the H2 database, but the GUID field has not an index in the Oracle. And I tested with indexes in both databases and the behavior is the same. I changed the code and tested the following: Str