Hi All,

I am working hibernate from past 8 months.Recnetly i am facing one issue on production server.Hibernate sending empty value(?)
to database(My sql 5.0).Below sql,we got from my sql server sql and it was generated by hibernate hql query...this was casuing
performance issues

select rolemodule?_.module_code as col_?_?_, modulecode?_.module_name as col_?_?_, modulecode?_.module_link as col_?_?_, modulecode?_.tree_link as col_?_?_, modulecode?_.nav_flag as col_?_?_, modulelink?_.module_parent_code as col_?_?_, modulecode?_.module_name as col_?_?_, modulecode?_.tree_link as col_?_?_, modulelink?_.level as col_?_?_ from trole_module_privilege_link rolemodule?_ inner join tmodule_code modulecode?_ on rolemodule?_.module_code=modulecode?_.module_code inner join tmodule_link modulelink?_ on modulecode?_.module_code=modulelink?_.module_code, tmodule_code modulecode?_ where modulelink?_.module_parent_code=modulecode?_.module_code and (rolemodule?_.role_code in (select rolelink?_.role_code from temp_role_link rolelink?_ where rolelink?_.emp_num in (?))) and (rolemodule?_.module_code not in (? , ? , ?)) group by rolemodule?_.module_code;

From this query i have observed two points

1)table alias and colum alias having ? values Ex:col_?_?_, col_?_?_.
2)sql parametes having ? values Ex: emp_num in (?).

Here my doubts was why sql was genetating with ? symbols instead of values.

could you help me why hibernate sending sql querys to my sql with out any values...

pelase reply to me if any one knows the reason,

URGENT....

jar:
hibernate 3.2.0 ga


Thanks
subbu