Return-Path: Delivered-To: apmail-cayenne-dev-archive@www.apache.org Received: (qmail 7952 invoked from network); 21 Oct 2010 14:37:03 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 21 Oct 2010 14:37:03 -0000 Received: (qmail 23331 invoked by uid 500); 21 Oct 2010 14:37:03 -0000 Delivered-To: apmail-cayenne-dev-archive@cayenne.apache.org Received: (qmail 23273 invoked by uid 500); 21 Oct 2010 14:37:03 -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 23265 invoked by uid 99); 21 Oct 2010 14:37:03 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 21 Oct 2010 14:37:03 +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 (athena.apache.org: local policy) Received: from [209.85.161.43] (HELO mail-fx0-f43.google.com) (209.85.161.43) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 21 Oct 2010 14:36:58 +0000 Received: by fxm20 with SMTP id 20so97909fxm.16 for ; Thu, 21 Oct 2010 07:36:35 -0700 (PDT) Received: by 10.204.177.79 with SMTP id bh15mr725144bkb.121.1287671795680; Thu, 21 Oct 2010 07:36:35 -0700 (PDT) MIME-Version: 1.0 Received: by 10.204.63.71 with HTTP; Thu, 21 Oct 2010 07:36:15 -0700 (PDT) In-Reply-To: <2F36953D-8D36-4E72-9959-84D5E767BD57@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> <2F36953D-8D36-4E72-9959-84D5E767BD57@objectstyle.org> From: Michael Gentry Date: Thu, 21 Oct 2010 10:36:15 -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 Dare we switch? :-) On Thu, Oct 21, 2010 at 10:31 AM, Andrus Adamchik wrote: > Nice! > > On Oct 21, 2010, at 5:29 PM, Michael Gentry wrote: > >> FWIW, the H2 people fixed the bug for us and 3.1 builds and the tests >> successfully run with with H2 1.2.144. >> >> mrg >> >> >> On Sat, Oct 9, 2010 at 7:13 PM, Michael Gentry w= rote: >>> Sure, I'll take care of that. =A0I 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 wrote: >>>> 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 imp= rovements. >>>> >>>> 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 (hopef= ully) find a version that is free of that bug but still supports auto-incre= ment. 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/CayenneT= est) >>>>>>> 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(25= 4) >>>>>>> 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; >>>>>>> >>>>>> >>>>>> >>>>> >>>> >>>> >>> >> > >