Re: [Hibernate-devel] Bug in cirrus.hibernate.impl.ByIDQuery?

[Christian M. <vc...@cl...>]

LEFT OUTER JOIN is the correct syntax and should be correctly handled by
database which support outer join.

Chris

----- Original Message -----
From: "Urberg, John" <ju...@ve...>
To: <hib...@li...>
Sent: Wednesday, July 31, 2002 10:16 PM
Subject: [Hibernate-devel] Bug in cirrus.hibernate.impl.ByIDQuery?


> I setup my first many-to-one association today without outer-join set to
> "true".  My Sybase ASA database didn't much care for the query generated.
> It used "LEFT JOIN" instead of "LEFT OUTER JOIN".  I made changed the
> following in the constructor of ByIdQuery...
>
>   buf.append(" LEFT JOIN ")
>
>          to
>
>   buf.append(" LEFT OUTER JOIN ")
>
> ...and all is well.  Should it be this way for all databases, or does this
> need to be factored out to the dialect classes?
>
> Regards,
> John
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by: Dice - The leading online job board
> for high-tech professionals. Search and apply for tech jobs today!
> http://seeker.dice.com/seeker.epl?rel_code=31
> _______________________________________________
> Hibernate-devel mailing list
> Hib...@li...
> https://lists.sourceforge.net/lists/listinfo/hibernate-devel
>
>