Yes it did.
Is there a best practice instead? I can do it via straight jdbc, but I would
really like to use Hibernate for everything if there is a valid way to do
so.
It didn't work however when I tried to do 'and y.auditInfo.lastUpdated is
null'
Got:
net.sf.hibernate.QueryException: dereferenced:
upcasin1_.auditInfo.lastUpdated
Troy
----- Original Message -----
From: "Gavin King" <[EMAIL PROTECTED]>
To: "Troy McKinnon" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Saturday, November 08, 2003 2:10 AM
Subject: Re: [Hibernate] Outer join question - apologies
> Actually you can't. Did this work? I wouldn't rely upon it...
>
> Troy McKinnon wrote:
>
> > Sorry everyone - I didn't realize you could use straight sql in the
> > createQuery() method.
> >
> > Anyway for those who might not know:
> >
> > Query q = session.createQuery(
> > "select count(x.name) from Table_1 x, Table_2 y "+
> > " where length (x.name) > 11 and x.name= y.name(+) and
y.type
> > is null");
> > result = q.list();
> > for(Iterator iterator = result.iterator();
iterator.hasNext();)
> > {
> > Object result = (Object) iterator.next();
> > System.out.println("result = " + result);
> > }
> >
> > Will work similar to using straight JDBC.
> >
> >
> > Again my apologies!
> >
> > Troy
> >
> > ----- Original Message -----
> > From: "Troy McKinnon" <[EMAIL PROTECTED]>
> > Cc: <[EMAIL PROTECTED]>
> > Sent: Saturday, November 08, 2003 1:46 AM
> > Subject: [Hibernate] Outer join question
> >
> >
> >
> >>I have been reading thru the documentation on the hibernate query
language
> >>regarding joins and other 'sql' queries.
> >>
> >>I noticed that in every case of a join the 2 tables have an association.
> >>(constraint)
> >>
> >>I was wondering if it is still possible to do the join without the
> >
> > relation.
> >
> >>This example is trivial but it gets my point across:
> >>select x.name from Table_One x, Table_Two y
> >>
> >>where x.name = y.name (+)
> >>
> >>and y.type is null
> >>
> >>Or similarly:
> >>
> >>select x.name from Table_One x, Table_Two y
> >>
> >>where x.name = y.someothername (+)
> >>
> >>and y.type is null
> >>
> >>
> >>
> >>I don't want to 'force' the mapping as in:
> >>
> >><class Table_one>
> >> <id>
> >> <one-to-one ... class=Table_2>
> >><..>
> >>
> >>Because I feel that that would limit me from doing a similar join on say
> >>Table_3.yetanothername
> >>
> >>This is probably a very simple answer and I just am not getting it. But
I
> >>would appreciate your help in understanding.
> >>
> >>
> >>
> >>Thanks
> >>
> >>Troy
> >>
> >>
> >>-------------------------------------------------------
> >>This SF.Net email sponsored by: ApacheCon 2003,
> >>16-19 November in Las Vegas. Learn firsthand the latest
> >>developments in Apache, PHP, Perl, XML, Java, MySQL,
> >>WebDAV, and more! http://www.apachecon.com/
> >>_______________________________________________
> >>hibernate-devel mailing list
> >>[EMAIL PROTECTED]
> >>https://lists.sourceforge.net/lists/listinfo/hibernate-devel
> >>
> >
> >
> >
> > -------------------------------------------------------
> > This SF.Net email sponsored by: ApacheCon 2003,
> > 16-19 November in Las Vegas. Learn firsthand the latest
> > developments in Apache, PHP, Perl, XML, Java, MySQL,
> > WebDAV, and more! http://www.apachecon.com/
> > _______________________________________________
> > hibernate-devel mailing list
> > [EMAIL PROTECTED]
> > https://lists.sourceforge.net/lists/listinfo/hibernate-devel
>
> --
> Gavin King
> JBoss Group
> +61 410534454
> http://hibernate.org
>
>
>
> -------------------------------------------------------
> This SF.Net email sponsored by: ApacheCon 2003,
> 16-19 November in Las Vegas. Learn firsthand the latest
> developments in Apache, PHP, Perl, XML, Java, MySQL,
> WebDAV, and more! http://www.apachecon.com/
> _______________________________________________
> hibernate-devel mailing list
> [EMAIL PROTECTED]
> https://lists.sourceforge.net/lists/listinfo/hibernate-devel
>
-------------------------------------------------------
This SF.Net email sponsored by: ApacheCon 2003,
16-19 November in Las Vegas. Learn firsthand the latest
developments in Apache, PHP, Perl, XML, Java, MySQL,
WebDAV, and more! http://www.apachecon.com/
_______________________________________________
hibernate-devel mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/hibernate-devel
