Hibernate Community • View topic - Using Criteria for Multiple Table Queries

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Using Criteria for Multiple Table Queries

Page 1 of 1

[ 1 post ]

Previous topic | Next topic

Author

Message

mitchpsmith

Post subject: Using Criteria for Multiple Table Queries

Posted: Fri Aug 17, 2012 10:07 am

Newbie

Joined: Fri Aug 17, 2012 7:02 am
Posts: 1

Hi,

I have the following statement:

Code:

executeQuery("SELECT  ai.label ,ai.id" +
            " FROM my_function fun , my_function_action fa, my_action_item ai "+
            "WHERE fun.menu_id=" +menuId+
            " AND fun.ID=fa.function_id AND fa.action_id=ai.id AND ai.privilege_id="+id);

Is it possible to re-create this using hibernate criteria? I use criteria for all single table queries, but cannot find any documentation or detail on if it is possible to do this for mulltiple table queries.

I am using Release 4.1

Thanks

Mitchell

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