Return-Path: Delivered-To: apmail-cayenne-dev-archive@www.apache.org Received: (qmail 43114 invoked from network); 9 Oct 2010 23:14:09 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 9 Oct 2010 23:14:09 -0000 Received: (qmail 66226 invoked by uid 500); 9 Oct 2010 23:14:09 -0000 Delivered-To: apmail-cayenne-dev-archive@cayenne.apache.org Received: (qmail 66205 invoked by uid 500); 9 Oct 2010 23:14:09 -0000 Mailing-List: contact dev-help@cayenne.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@cayenne.apache.org Delivered-To: mailing list dev@cayenne.apache.org Received: (qmail 66197 invoked by uid 99); 9 Oct 2010 23:14:09 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 09 Oct 2010 23:14:09 +0000 X-ASF-Spam-Status: No, hits=0.7 required=10.0 tests=RCVD_IN_DNSWL_NONE,SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (nike.apache.org: local policy) Received: from [209.85.214.43] (HELO mail-bw0-f43.google.com) (209.85.214.43) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 09 Oct 2010 23:14:02 +0000 Received: by bwz11 with SMTP id 11so1002291bwz.16 for ; Sat, 09 Oct 2010 16:13:42 -0700 (PDT) Received: by 10.204.160.146 with SMTP id n18mr3666059bkx.116.1286666022465; Sat, 09 Oct 2010 16:13:42 -0700 (PDT) MIME-Version: 1.0 Received: by 10.204.63.71 with HTTP; Sat, 9 Oct 2010 16:13:22 -0700 (PDT) In-Reply-To: <731B9E57-D8E0-4647-B602-39BFCC25D6E2@objectstyle.org> References: <1985669668.4551285679983408.JavaMail.hudson@aegis> <0473B2D0-944F-4890-BF4B-0ACD935BCDF7@objectstyle.org> <5C2C556C-D67D-4E6B-805C-0C5F0E60492B@objectstyle.org> <27173C39-44D9-4894-B876-08A45398BA86@objectstyle.org> <731B9E57-D8E0-4647-B602-39BFCC25D6E2@objectstyle.org> From: Michael Gentry Date: Sat, 9 Oct 2010 19:13:22 -0400 Message-ID: Subject: =?ISO-8859-1?Q?Re=3A_Build_failed_in_Hudson=3A_Cayenne=2Dtrunk_=BB_h2=2CJDK_?= =?ISO-8859-1?Q?1=2E5_=28latest=29=2CUbuntu_=23372?= To: dev@cayenne.apache.org Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Checked: Checked by ClamAV on apache.org Sure, I'll take care of that. I also filed a bug for the H2 people. Maybe they'll fix it, but at least we are back to building now. mrg On Sat, Oct 9, 2010 at 4:24 PM, Andrus Adamchik wr= ote: > Awesome. It worked. > > Can we possibly log a Jira about H2 auto increment feature and record it = in RELEASE-NOTES? It should help us down the line in documenting 3.1 improv= ements. > > Andrus > > > On Oct 9, 2010, at 7:05 PM, Michael Gentry wrote: > >> H2 1.1.119 ran tests successfully locally, so I've committed the POM >> and hopefully Hudson will build cleanly now. >> >> mrg >> >> >> On Sat, Oct 9, 2010 at 11:29 AM, Andrus Adamchik wrote: >>> I suggest filing a bug with H2 and downgrading down, until we (hopefull= y) find a version that is free of that bug but still supports auto-incremen= t. If that doesn't work, we can switch tests to file-based URLs. >>> >>> Andrus >>> >>> >>> On Oct 9, 2010, at 6:23 PM, Michael Gentry wrote: >>>> Hi, >>>> >>>> I just did an experiment. =A0Using H2 against a file (/tmp/CayenneTest= ) >>>> it worked fine (returned one record). =A0Against an in memory DB it >>>> failed (returned 3 records). =A0Seems like there is a bug in H2 >>>> somewhere. =A0Thoughts on how we should handle this? >>>> >>>> Thanks, >>>> >>>> mrg >>>> >>>> PS. Here is the SQL: >>>> >>>> >>>> CREATE TABLE ARTIST (ARTIST_ID BIGINT NOT NULL, ARTIST_NAME CHAR(254) >>>> NOT NULL, DATE_OF_BIRTH DATE NULL, PRIMARY KEY (ARTIST_ID)); >>>> CREATE TABLE PAINTING (ARTIST_ID BIGINT NULL, ESTIMATED_PRICE >>>> DECIMAL(10, 2) NULL, GALLERY_ID INTEGER NULL, PAINTING_DESCRIPTION >>>> VARCHAR(255) NULL, PAINTING_ID INTEGER NOT NULL, PAINTING_TITLE >>>> VARCHAR(255) NOT NULL, PRIMARY KEY (PAINTING_ID)); >>>> >>>> INSERT INTO ARTIST (ARTIST_ID, ARTIST_NAME) VALUES (33001, 'B'); >>>> INSERT INTO ARTIST (ARTIST_ID, ARTIST_NAME) VALUES (33002, 'A'); >>>> INSERT INTO ARTIST (ARTIST_ID, ARTIST_NAME) VALUES (33003, 'D'); >>>> INSERT INTO PAINTING (PAINTING_ID, ARTIST_ID, PAINTING_TITLE, >>>> ESTIMATED_PRICE) VALUES (33009, 33001, 'X', 5000); >>>> INSERT INTO PAINTING (PAINTING_ID, ARTIST_ID, PAINTING_TITLE, >>>> ESTIMATED_PRICE) VALUES (33010, 33001, 'Y', 5000); >>>> INSERT INTO PAINTING (PAINTING_ID, ARTIST_ID, PAINTING_TITLE, >>>> ESTIMATED_PRICE) VALUES (33011, 33002, 'Z', 5000); >>>> >>>> SELECT t0.DATE_OF_BIRTH AS ec0_0, t0.ARTIST_ID AS ec0_2, >>>> t0.ARTIST_NAME AS ec0_1 FROM ARTIST t0 LEFT OUTER JOIN PAINTING t1 ON >>>> (t0.ARTIST_ID =3D t1.ARTIST_ID) WHERE t1.PAINTING_ID IS NULL; >>>> >>> >>> >> > >