Return-Path: Delivered-To: apmail-openjpa-dev-archive@www.apache.org Received: (qmail 1640 invoked from network); 2 Jun 2008 20:16:41 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 2 Jun 2008 20:16:41 -0000 Received: (qmail 46576 invoked by uid 500); 2 Jun 2008 20:16:43 -0000 Delivered-To: apmail-openjpa-dev-archive@openjpa.apache.org Received: (qmail 46548 invoked by uid 500); 2 Jun 2008 20:16:43 -0000 Mailing-List: contact dev-help@openjpa.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@openjpa.apache.org Delivered-To: mailing list dev@openjpa.apache.org Received: (qmail 46537 invoked by uid 99); 2 Jun 2008 20:16:43 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 02 Jun 2008 13:16:43 -0700 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of timh@mousetech.com designates 216.199.14.29 as permitted sender) Received: from [216.199.14.29] (HELO mail2.mousetech.com) (216.199.14.29) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 02 Jun 2008 20:15:48 +0000 Received: from [192.168.10.2] (www2 [216.199.14.19]) (authenticated bits=0) by mail2.mousetech.com (8.13.8/8.13.8) with ESMTP id m52KIAjU005322 for ; Mon, 2 Jun 2008 16:18:10 -0400 Subject: JoinColumn annotation broken in openjpa-1.2.0-SNAPSHOT? From: Tim Holloway To: dev@openjpa.apache.org Content-Type: text/plain Date: Mon, 02 Jun 2008 16:16:09 -0400 Message-Id: <1212437769.3066.23.camel@a64.camera.mousetech.com> Mime-Version: 1.0 X-Mailer: Evolution 2.10.3 (2.10.3-9.fc7) Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org @ManyToOne(fetch=FetchType.EAGER, cascade=CascadeType.MERGE) @JoinColumn(name="bus_stop_id") private BusStops busStop; Works in release 1.0.2: SELECT t0.schedule_stop_id, t1.stop_id, t1.description, t1.elevation, t1.in_ service_date, t1.inbound, t1.latitude, t1.longitude, t1.out_service_date, t1.sheltered, t1.street1_block, t2.street_direction_id, t2.description, t1.street1_name, t1.street1 _qualifier, t3.street_type_id, t3.description, t1.street2_block, t4.street_direction_id, t4.description, t1.street2_name, t1.street2_qualifier, t5.street_type_id, t5.descrip tion, t1.waypoint, t0.clock_point, t0.comments, t0.in_service, t0.in_service_date, t0.inbound, t0.out_service_date, t0.outbound, t0.schedule_id, t0.stop_sequence, t0.terminu s, t0.transfer_point FROM public.schedule_stops t0 LEFT OUTER JOIN public.bus_stops t1 ON t0.bus_stop_id = t1.stop_id LEFT OUTER JOIN public.lk_street_directions t2 ON t1.st reet1_direction = t2.street_direction_id LEFT OUTER JOIN public.lk_street_types t3 ON t1.street1_type = t3.street_type_id LEFT OUTER JOIN public.lk_street_directions t4 ON t 1.street2_direction = t4.street_direction_id LEFT OUTER JOIN public.lk_street_types t5 ON t1.street2_type = t5.street_type_id WHERE t0.schedule_id = ? ORDER BY t0.stop_seque nce ASC [params=(int) 50] Uses synthesized column name instead of declared name in today's CVS snapshot: ERROR: column t0.busstop_stop_id does not exist {prepstmnt 17939164 SELECT t0.schedule_stop_id, t1.stop_id, t1.description, t1.elevation, t1.in_service_date, t1.inbound, t1.latitude, t1.longitude, t1.out_service_date, t1.sheltered, t1.street1_block, t2.street_direction_id, t2.description, t1.street1_name, t1.street1_qualifier, t3.street_type_id, t3.description, t1.street2_block, t4.street_direction_id, t4.description, t1.street2_name, t1.street2_qualifier, t5.street_type_id, t5.description, t1.waypoint, t0.clock_point, t0.comments, t0.in_service, t0.in_service_date, t0.inbound, t0.out_service_date, t0.outbound, t0.SCHEDULE_SCHEDULE_ID, t0.stop_sequence, t0.terminus, t0.transfer_point FROM public.schedule_stops t0 LEFT OUTER JOIN public.bus_stops t1 ON t0.BUSSTOP_STOP_ID = t1.stop_id LEFT OUTER JOIN public.lk_street_directions t2 ON t1.street1_direction = t2.street_direction_id LEFT OUTER JOIN public.lk_street_types t3 ON t1.street1_type = t3.street_type_id LEFT OUTER JOIN public.lk_street_directions t4 ON t1.street2_direction = t4.street_direction_id LEFT OUTER JOIN public.lk_street_types t5 ON t1.street2_type = t5.street_type_id WHERE t0.SCHEDULE_SCHEDULE_ID = ? ORDER BY t0.stop_sequence ASC [params=(int) 50]} [code=0, state=42703]