Here is the problem description:-

When i am trying to Join a table more than two times on basis of certain conditions [i.e on/with clause]

It is joining on the tables in order[ascending] of the name of those entities[Here subjects] given in the main entity [Here Student]

Firstly it is not joining in order of the sub criteria list.

Secondly it is keeping the with clause arguments [here subject ids] order same, which is resulting in wrong data.

Try to see the query created by the test case given.
You will understand what i am trying to convey.

I am using :

Java : java version "1.6.0_20"
Hibernate : hibernate 4.3.3 Final
Database : Mysql