注册

hibernate3.1.3无效的表或视图名

DM_001242 2021/05/10 1800 12

依赖如下:
image.png
sql以及执行情况如下:

String strHql = "FROM Catalog t WHERE t.status not in('1', '2', '3', '4', '5', '6') ORDER BY t.orderNum, t.id";
HibernateTemplate.execute( new HibernateCallback() {
   public Object doInHibernate(Session session) throws 
      HibernateException, SQLException {
      Query query = session.createQuery(strHql);
      ArrayList arrayList = (ArrayList) query.list();
      return arrayList;
}});

报错如下:

WARN [(hibernate.util.JDBCExceptionReporter)] SQL Error: -2106, SQLState: 22000
ERROR [(hibernate.util.JDBCExceptionReporter)] 第1 行附近出现错误:
无效的表或视图名[CATALOG]
org.springframework.dao.DataIntegrityViolationException: could not execute query; nested exception is org.hibernate.exception.DataException: could not execute query
回答 0
暂无回答
扫一扫
联系客服