JPA + Hibernate: optimizing queries on a many-to-many relationship

Following up a discussion (in Russian) on a developers' forum on advanced querying against many-to-many mapping in JPA I have compiled all my findings in this post. I intentionally leave all object and database names close to the original maybe with minor changes.

Splitting the blog in two

Finally this is the time to sort out the mess of English and Russian posts in the same blog. I feel much easier when writing about IT and related technologies in English. So I will split the blog and go on posting in English here. All posts in Russian are moving to yegodm-ru.blogspot.com.