1 Reply Latest reply on Mar 17, 2008 1:06 AM by zhiqiang.wang

    a little prombel about using EJB3.0

    zhiqiang.wang Newbie

      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!