使用Hibernate的 原生SQL 查询报错,求大神
上代码:Example是我的实体类
String sql="select 1 ,2 from example";
SQLQuery q=sessionFactory.getCurrentSession().createSQLQuery(sql).addEntity("", Example.class);
return q.list();
如果我把sql改成:“ select 1,2 from dual ”; 就不会报错。
如果我 改成HQL 查询 也不会报错: Query q=sessionFactory.getCurrentSession().createQuery("from Example");也不会报错,
我就日了 狗了!
报错信息:
Struts Problem Report
Struts has detected an unhandled exception:
Messages:
Table 'mysql.example' doesn't exist
could not execute query
File: org/hibernate/exception/SQLStateConverter.java
Line number: 92
Stacktraces
org.hibernate.exception.SQLGrammarException: could not execute query
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
org.hibernate.loader.Loader.doList(Loader.java:2452)
org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2192)
org.hibernate.loader.Loader.list(Loader.java:2187)
org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:316)
org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1832)
org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165)
org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:179)
cn.hjw.oa.dao.impl.ExamplDaoImpl.selAll(ExamplDaoImpl.java:63)
cn.hjw.oa.dao.impl.ExamplDaoImpl$$FastClassByCGLIB$$f9a596c5.invoke()
net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:700)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:635)
cn.hjw.oa.dao.impl.ExamplDaoImpl$$EnhancerByCGLIB$$a921a677.selAll()
cn.hjw.oa.service.impl.ExampleServiceImpl.selAllService(ExampleServiceImpl.java:34)
cn.hjw.oa.action.ExampleAction.selAllAc(ExampleAction.java:39)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)