jpa SQL Error: 17006, SQLState: null

could not read column value from result set: ID; 列名无效

 

查询语句：

String sql = "select A.SOURCE_CODE from  TB_PROSPECT_SOURCES A where Lower(A.SOURCE_CODE) = Lower('"+code+"')";

  Query query = this.getEntityManager().createNativeQuery(sql);

  List l = new ArrayList();

  l.add(query.getResultList());

将sql表的指段写全，或者 select * ，错误消失