hi-
see <below>
in hibernate when i look at dynamic sql output, the description field is named something else.
category0_.ACTION_as col_3_0_ should be category0_.description as col_3_0_
i get the dreaded error 42X04 error. i cant figure it out. i can tell you that when i stay away
from this field name in my hql editor all the hql is ok.
any assistance would be really cool. i am really stuck.
thanks,
3rdshiftcoder
dynamic: sql output from hibernate
0: short, short, integer,
string
-----------------
select
category0_.categoryid as col_0_0_,
category0_.parentid as col_1_0_,
category0_.accountnum as col_2_0_,
category0_.ACTION_ as col_3_0_
from
USER1.Category category0_
where
category0_.categoryid<10