Hibernate Community • View topic - Single Criteria for transitive dependency

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Single Criteria for transitive dependency

Page 1 of 1

[ 1 post ]

Previous topic | Next topic

Author

Message

sonyg

Post subject: Single Criteria for transitive dependency

Posted: Mon Mar 07, 2011 6:54 am

Newbie

Joined: Mon Mar 07, 2011 6:32 am
Posts: 3

TableA
A_id primarykey
A_field

TableB
B_id primarykey
A_id
B_field

TableC
C_id primarykey
B_id
C_field

There is many to 1 relationship from Table A to Table B
Similary, there is many to 1 relationship from Table B to Table C

Say if I want to retrieve C_field using A_id, how can I do that using a single Criteria statement?

Corresponsing MySQL statement: SELECT c.C_field FROM TableC c JOIN TableB b ON c.B_id = b.B_id JOIN TableA a on b.A_id = a.A_id

Many thanks
Sony G

Top

Page 1 of 1

[ 1 post ]

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