Hibernate Community • View topic - [ query ] inner/outer join

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

[ query ] inner/outer join

Page 1 of 1

[ 4 posts ]

Previous topic | Next topic

Author

Message

hcm

Post subject: [ query ] inner/outer join

Posted: Sun May 23, 2004 1:03 pm

Beginner

Joined: Fri Apr 23, 2004 6:39 pm
Posts: 23

hello,

I try to use sql inner/outer join with Hibernate:

Code:

String query = 
   select rlox, products 
                from Rlox as rlox left outer join Products as products 
    on rlox.latitude=products.id; 

without declared relationship many to one in the mapping file:

Code:

 <many-to-one class="hibernate.test.Rlox"> 
   <column name="latitude"/> 
 </many-to-one> 

It is possible?

Thanks

Top

michael

Post subject:

Posted: Sun May 23, 2004 1:08 pm

Hibernate Team

Joined: Tue Sep 09, 2003 2:10 pm
Posts: 3246
Location: Passau, Germany

Top

hcm

Post subject:

Posted: Sun May 23, 2004 1:35 pm

Beginner

Joined: Fri Apr 23, 2004 6:39 pm
Posts: 23

Thanks for reply,

but how to create the relationship in the mapping for outer join on rlox.latitude and products.id.

Top

umarabdullah

Post subject:

Posted: Tue May 25, 2004 12:24 pm

Newbie

Joined: Fri May 21, 2004 8:02 pm
Posts: 4

Try,

select xxx from Rlox as rlox left outer join rlox.products as products

Umar

Top

Page 1 of 1

[ 4 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum