Question

org.hibernate.exception.GenericJDBCException: could not execute query

root cause

java.sql.SQLException: Can not issue data manipulation statements with executeQuery().

代码: public List updateset(String kch){
Session session=getHibernateTemplate().getSessionFactory().openSession();
Query query=session.createSQLQuery("update Kcb set flag='已选' where kch="+kch+" order by kch");
query.executeUpdate();
List list=query.list();
session.close();
session=null;
return list;

}
public List updateset2(String kch){
Session session=getHibernateTemplate().getSessionFactory().openSession();
Query query=session.createSQLQuery("update Kcb set flag='未选' where kch="+kch+" order by kch");
query.executeUpdate();
List list=query.list();
session.close();
session=null;
return list;

}
更新是成功的，但是会跳出那个异常。。求解

Answer 1

Query query=session.createSQLQuery("update Kcb set flag='已选' where kch="+kch+" order by kch");
query.executeUpdate();
List list=query.list();
query是SQLQuery
前面指定了update语句，紧接着又调用query的list方法，当然无法执行