{急}hibernate报错，ora00903

Question

基本代码
String sql = "from OdsYyYybbJlWsc t where 1=1 ";
Query query = getHibernateTemplate().getSessionFactory().getCurrentSession().createSQLQuery(sql);
List list = query.list();
错误信息
15:42:28,218  WARN JDBCExceptionReporter:71 - SQL Error: 903, SQLState: 42000
15:42:28,218 ERROR JDBCExceptionReporter:72 - ORA-00903: 表名无效15:42:28,234 ERROR DefaultExceptionHandler:60 - Intercepted Exception:
org.hibernate.exception.SQLGrammarException: could not execute query
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j
ava:67)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
er.java:43)
        at org.hibernate.loader.Loader.doList(Loader.java:2148)
        at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
        at org.hibernate.loader.Loader.list(Loader.java:2024)
        at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:111)
        at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1655)        at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:
142)
        at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:164)
        at com.wondersgroup.stpt.yunying.report.dao.impl.YybbListDAOImpl.selectW
SBReport(YybbListDAOImpl.java:39)
        at com.wondersgroup.stpt.yunying.report.service.impl.YyReportServiceImpl
.selectWSBReport(YyReportServiceImpl.java:294)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
on(AopUtils.java:304)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
inpoint(ReflectiveMethodInvocation.java:182)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:149)
        at org.springframework.transaction.interceptor.TransactionInterceptor.in
voke(TransactionInterceptor.java:106)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:171)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
cAopProxy.java:204)
        at $Proxy74.selectWSBReport(Unknown Source)
        at com.wondersgroup.stpt.yunying.report.action.YyReportListAction.ListWS
BReport(YyReportListAction.java:92)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at com.opensymphony.xwork.DefaultActionInvocation.invokeAction(DefaultAc
tionInvocation.java:358)
        at com.opensymphony.xwork.DefaultActionInvocation.invokeActionOnly(Defau
ltActionInvocation.java:218)
        at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionIn
vocation.java:192)
        at com.wondersgroup.framework.core.web.action.xwork.interceptor.UniExcep
tionInterceptor.intercept(UniExceptionInterceptor.java:85)
        at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionIn
vocation.java:190)
        at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(Around
Interceptor.java:31)
        at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionIn
vocation.java:190)
        at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(Around
Interceptor.java:31)
        at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionIn
vocation.java:190)
        at com.opensymphony.xwork.interceptor.I18nInterceptor.intercept(I18nInte
rceptor.java:151)
        at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionIn
vocation.java:190)
        at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(Around
Interceptor.java:31)
        at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionIn
vocation.java:190)
        at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.
java:116)
        at com.opensymphony.webwork.dispatcher.DispatcherUtils.serviceAction(Dis
patcherUtils.java:273)
        at com.opensymphony.webwork.dispatcher.FilterDispatcher.doFilter(FilterD
ispatcher.java:202)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:186)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:157)
        at com.opensymphony.webwork.dispatcher.ActionContextCleanUp.doFilter(Act
ionContextCleanUp.java:88)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:186)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:157)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:214)
        at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv
eContext.java:104)
        at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
a:520)
        at org.apache.catalina.core.StandardContextValve.invokeInternal(Standard
ContextValve.java:198)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:152)
        at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv
eContext.java:104)
        at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
a:520)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:137)
        at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv
eContext.java:104)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:118)
        at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv
eContext.java:102)
        at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
a:520)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:109)
        at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv
eContext.java:104)
        at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
a:520)
        at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)        at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:16
0)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:799)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
ssConnection(Http11Protocol.java:705)
        at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java
:577)
        at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadP
ool.java:683)
        at java.lang.Thread.run(Thread.java:619)

Answer 1

OdsYyYybbJlWsc 写的不会是表名吧？一定是类名的。

Answer 2

hibernate用的是hql语句，和sql是不同的，你语句有问题

Answer 3

迩這样寫试试：
                   return this.getHibernateTemplate().executeFind(new HibernateCallback(){
public List doInHibernate(Session session) throws HibernateException, SQLException {

Query query=session.createQuery(sql);
return query.list();
}
});上面是我以前自己寫的一段代码，因为不知道迩具体的程序是什么情况，有些地方迩自己改下，然后试试看行不行！

Answer 4

OdsYyYybbJlWsc 肯定是类名
会不会使哪里配置错误？

Answer 5

15:42:28,218  WARN JDBCExceptionReporter:71 - SQL Error: 903, SQLState: 42000 
15:42:28,218 ERROR JDBCExceptionReporter:72 - ORA-00903: 表名无效 hibernate无法解析你的类，应该是在mapping里面配置错误了，检查一下。