Question

java代码报错： SQL Error: 942, SQLState: 42000 ORA-00942: 表或视图不存在

public List<Object> getStreetInfo(){
StringBuilder hqlStr = new StringBuilder("select GRID_SYSDB.MNG_JD_M.CODE as CODE FROM GRID_SYSDB.MNG_JD_M");
List<Object> list = new ArrayList<Object>();
Session session = null;

try {
session = hibernateHelper.getSession();
SQLQuery query = session.createSQLQuery(hqlStr.toString());
query.addScalar("CODE", Hibernate.STRING);
list = query.list();
} catch (Exception ex) {
ex.printStackTrace();
}
return list;
}

数据库中用同样查询语句可以查到值的。

Answer 1

你数据库工具登录的用户跟hibernate登录的用户是一个？