openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kevin Sutter" <kwsut...@gmail.com>
Subject Re: JoinColumn annotation broken in openjpa-1.2.0-SNAPSHOT?
Date Thu, 05 Jun 2008 14:13:40 GMT
Hi Tim,
>From your description, this looks to be a valid concern.  I just did a quick
search of our testcases and found several cases of the @JoinColumn
annotation, so I am surprised that you're hitting a problem.  But, I did
notice in several of the cases that although we used the "name" element, we
didn't change the expected generated name, so I'm not sure of the benefit in
those cases...  But, there were several other scenarios where the name was
unique and different.

I'll continue to take a look, but in the mean time, you might want to open a
JIRA Issue.  If possible, a simple testcase would also help define the
problem (since our testcase must not be finding it).  There must be
something slightly unique with your application as compared to the ones used
in our testing.

Thanks,
Kevin

On Thu, Jun 5, 2008 at 6:10 AM, Tim Holloway <timh@mousetech.com> wrote:

> No comments?
>
> On Mon, 2008-06-02 at 16:16 -0400, Tim Holloway wrote:
> >       @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]
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message