jpa SQL Error: 17006, SQLState: null

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 * ,错误消失

原文地址:https://www.cnblogs.com/firstdream/p/2380882.html