Hibernate 求救 遇到查询找不到表或视图

[donna0215]

SSH，通过注解的方式注入，启动日志都描述了已经将实体BEAN扫描注入，但是一到查询，就报这个错，查一天的问题了，都没有找到问题。启动日志如下

2015-5-2 15:58:06 org.apache.catalina.core.ApplicationContext log
信息: Initializing Spring root WebApplicationContext
- Root WebApplicationContext: initialization started
- Refreshing Root WebApplicationContext: startup date [Sat May 02 15:58:06 CST 2015]; root of context hierarchy
- Loading XML bean definitions from class path resource [resources/applicationContext.xml]
- JSR-250 'javax.annotation.ManagedBean' found and supported for component scanning
- Loading XML bean definitions from class path resource [resources/spring-hibernate.xml]
- Overriding bean definition for bean 'baseDao': replacing [Generic bean: class [com.miaxis.hibernate.dao.BaseDao]; scope=singleton; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null; defined in file [E:\miaxis\jxglpt\WebRoot\WEB-INF\classes\com\miaxis\hibernate\dao\BaseDao.class]] with [Generic bean: class [com.miaxis.hibernate.dao.BaseDao]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null; defined in class path resource [resources/spring-hibernate.xml]]
- MLog clients using log4j logging.
- Initializing c3p0-0.9.0 [built 11-July-2005 00:43:29 -0400; debug? true; trace: 10]
- Properties {cache.algorithm=com.opensymphony.oscache.base.algorithm.LRUCache, cache.blocking=false, cache.persistence.overflow.only=true, cache.key=__oscache_cache, cache.capacity=1000, cache.memory=true}
- Constructed GeneralCacheAdministrator()
- Creating new cache
- Hibernate Commons Annotations 3.2.0.Final
- Hibernate 3.6.0.Final
- hibernate.properties not found
- Bytecode provider name : javassist
- using JDK 1.4 java.sql.Timestamp handling
- Binding entity from annotated class: com.miaxis.hibernate.domain.MsgInfo
- Bind entity com.miaxis.hibernate.domain.MsgInfo on table miaxis_msg_info
- Binding entity from annotated class: com.miaxis.hibernate.domain.MsgModelInfo
- Bind entity com.miaxis.hibernate.domain.MsgModelInfo on table MIAXIS_MSG_MODEL
- Binding entity from annotated class: com.miaxis.hibernate.domain.PayCenter
- Bind entity com.miaxis.hibernate.domain.PayCenter on table MIAXIS_PAY_CENTER
- Binding entity from annotated class: com.miaxis.hibernate.domain.PayInfo
- Bind entity com.miaxis.hibernate.domain.PayInfo on table MIAXIS_PAY_INFO
- Binding entity from annotated class: com.miaxis.hibernate.domain.VehicleAccident
- Bind entity com.miaxis.hibernate.domain.VehicleAccident on table MIAXIS_VEHICLE_ACCIDENT
- Binding entity from annotated class: com.miaxis.hibernate.domain.VehicleCheck
- Bind entity com.miaxis.hibernate.domain.VehicleCheck on table MIAXIS_VEHICLE_CHECK
- Binding entity from annotated class: com.miaxis.hibernate.domain.VehicleInfo
- Bind entity com.miaxis.hibernate.domain.VehicleInfo on table MIAXIS_VEHICLE_INFO
- Binding entity from annotated class: com.miaxis.hibernate.domain.VehicleInsurance
- Bind entity com.miaxis.hibernate.domain.VehicleInsurance on table MIAXIS_VEHICLE_INSURANCE
- Binding entity from annotated class: com.miaxis.hibernate.domain.VehicleMaintain
- Bind entity com.miaxis.hibernate.domain.VehicleMaintain on table MIAXIS_VEHICLE_MAINTAIN
- Binding entity from annotated class: com.miaxis.hibernate.domain.VehicleOil
- Bind entity com.miaxis.hibernate.domain.VehicleOil on table MIAXIS_VEHICLE_OIL
- Binding entity from annotated class: com.miaxis.hibernate.domain.VehicleRepair
- Bind entity com.miaxis.hibernate.domain.VehicleRepair on table MIAXIS_VEHICLE_REPAIR
- Hibernate Validator not found: ignoring
- Hibernate Validator 4.2.0.Final
- Building new Hibernate SessionFactory
- Unable to find org.hibernate.search.event.FullTextIndexEventListener on the classpath. Hibernate Search is not enabled.
- Initializing connection provider: org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider
- Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource@65b1fd9c[ acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, description -> null, driverClass -> oracle.jdbc.driver.OracleDriver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 65b1fd9c, idleConnectionTestPeriod -> 60, initialPoolSize -> 3, jdbcUrl -> jdbc:oracle:thin:@110.87.98.115:1522:orcl, loginTimeout -> 0, maxIdleTime -> 0, maxPoolSize -> 15, maxStatements -> 50, maxStatementsPerConnection -> 0, minPoolSize -> 10, numHelperThreads -> 3, preferredTestQuery -> null, properties -> {user=******, password=******}, propertyCycle -> 300, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, usesTraditionalReflectiveProxies -> false ]
- Database ->
       name : Oracle
    version : Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
      major : 11
      minor : 2
- Driver ->
       name : Oracle JDBC driver
    version : 11.2.0.2.0
      major : 11
      minor : 2
- Using dialect: org.hibernate.dialect.Oracle10gDialect
- Disabling contextual LOB creation as createClob() method threw error : java.lang.reflect.InvocationTargetException
- Transaction strategy: org.springframework.orm.hibernate3.SpringTransactionFactory
- No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
- Automatic flush during beforeCompletion(): disabled
- Automatic session close at end of transaction: disabled
- JDBC batch size: 15
- JDBC batch updates for versioned data: disabled
- Scrollable result sets: enabled
- JDBC3 getGeneratedKeys(): disabled
- Connection release mode: auto
- Default batch fetch size: 1
- Generate SQL with comments: disabled
- Order SQL updates by primary key: disabled
- Order SQL inserts for batching: disabled
- Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
- Using ASTQueryTranslatorFactory
- Query language substitutions: {}
- JPA-QL strict compliance: disabled
- Second-level cache: enabled
- Query cache: disabled
- Cache region factory : org.hibernate.cache.impl.NoCachingRegionFactory
- Optimize cache for minimal puts: disabled
- Structured second-level cache entries: disabled
- Statistics: disabled
- Deleted entity synthetic identifier rollback: disabled
- Default entity-mode: pojo
- Named query checking : enabled
- Check Nullability in Core (should be disabled when Bean Validation is on): disabled
- building session factory
- Not binding factory to JNDI, no JNDI name configured
- - Mapped URL path [/msg/sendList] onto handler 'msgController'
- Mapped URL path [/msg/sendList.*] onto handler 'msgController'
- Mapped URL path [/msg/sendList/] onto handler 'msgController'
系统启动加载静态数据到缓存中开始-----
- Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource@6bd1f967[ acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, description -> null, driverClass -> oracle.jdbc.driver.OracleDriver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 6bd1f967, idleConnectionTestPeriod -> 30, initialPoolSize -> 3, jdbcUrl -> jdbc:oracle:thin:@110.87.98.115:1522:orcl, loginTimeout -> 0, maxIdleTime -> 0, maxPoolSize -> 15, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 10, numHelperThreads -> 3, preferredTestQuery -> null, properties -> {user=******, password=******}, propertyCycle -> 300, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, usesTraditionalReflectiveProxies -> false ]
Sat May 02 15:58:13 CST 2015
Sat May 02 15:58:13 CST 2015
Sat May 02 15:58:15 CST 2015
Sat May 02 15:58:17 CST 2015
系统启动加载静态数据到缓存中结束-----
- Root WebApplicationContext: initialization completed in 10716 ms
2015-5-2 15:58:17 org.apache.catalina.core.ApplicationContext log
信2015-5-2 15:58:18 org.apache.catalina.startup.Catalina start
信息: Server startup in 16775 ms

中日志如下：

[donna0215]

打开ACTION后打的错如下：： /jxgl/msg/sendList.action 2015-5-2 16:44:10 org.apache.catalina.core.StandardWrapperValve invoke 严重: Servlet.service() for servlet [SpringMVC] in context with path [/jxgl] threw exception [Request processing failed; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query] with root cause java.sql.SQLException: ORA-00942: 表或视图不存在 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:219) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:813) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1049) at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:854) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1154) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3370) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3415) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208) at org.hibernate.loader.Loader.getResultSet(Loader.java:1953) at org.hibernate.loader.Loader.doQuery(Loader.java:802) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274) at org.hibernate.loader.Loader.doList(Loader.java:2533) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276) at org.hibernate.loader.Loader.list(Loader.java:2271) at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:316) at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1842) at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165) at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:157) at com.miaxis.hibernate.dao.BaseDao.getPageListBySql(BaseDao.java:194) at com.miaxis.hibernate.service.impl.MsgServiceImpl.queryMsgInfos(MsgServiceImpl.java:46) at com.miaxis.hibernate.controller.MsgController.sendList(MsgController.java:38) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176) at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:426) at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:414) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:790) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:719) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:644) at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:549) at javax.servlet.http.HttpServlet.service(HttpServlet.java:624) at javax.servlet.http.HttpServlet.service(HttpServlet.java:731) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.miaxis.filter.AuthorizerFilter.doFilter(AuthorizerFilter.java:55) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:620) at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2476) at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2465) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:662)