notice the generated column names for each session factory are different, is there any way to make the column names the same ?
SELECT lstnumeric0_.mpr_id as mpr1___2_, lstnumeric0_.mpr_id as mpr1_2_, lstnumeric0_.attribute_id as attribute2_2_, lstnumeric0_.mpr_id as mpr1_3281_1_,
SELECT lstnumeric0_.mpr_id as mpr1___2_, lstnumeric0_.mpr_id as mpr1_2_, lstnumeric0_.attribute_id as attribute2_2_, lstnumeric0_.mpr_id as mpr1_249_1_,
Basically we have several servers each server will have a session factory that is loaded once, when it generates the SQL statements based on the same mapping files they get different column names causing SQL server to generate differ-ant cache plans for each ..
Any work around this .. please help/advice.
Thanks Anil
|