i met a promble when i was using EJB3.0.
i'd like to search a part of values from the table, so i used em.createNativeQuery() and the sql statement is
"select cifno,cifname,idnum from cr_personinfo where rownum <50".
but it can not run properly .here is the error message:
"can not read column value from result set"
so i change the sql statement "select * cr_personinfo where rownum <50"
it can run properly .
why ?
thanks!
i have solute it by myself