求助：tomcat已经启动了，但是进不了页面，报404
[问题点数：40分，结帖人f513228]
求助：tomcat已经启动了，但是进不了页面，报404
[问题点数：40分，结帖人f513228]
不显示删除回复
显示所有回复
显示星级回复
显示得分回复
只显示楼主
相关帖子推荐：
本帖子已过去太久远了，不再提供回复功能。求助使用alibaba dubbo是启动tomcat报错
[问题点数：40分]
求助使用alibaba dubbo是启动tomcat报错
[问题点数：40分]
不显示删除回复
显示所有回复
显示星级回复
显示得分回复
只显示楼主
相关帖子推荐：
匿名用户不能发表回复！|
每天回帖即可获得10分可用分！小技巧：
你还可以输入10000个字符
(Ctrl+Enter)
请遵守CSDN，不得违反国家法律法规。
转载文章请注明出自“CSDN（www.csdn.net）”。如是商业用途请联系原作者。51CTO视频课程推荐：
查看:2539|回复：5
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'quartzScheduler' defined in class path resource [applicationContext-scheduler.xml]: Invocation o nested exception is org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception: org.quartz.JobPersistenceException: Couldn't clean volatile data: ORA-00942: 表或视图不存在
[See nested exception: java.sql.SQLException: ORA-00942: 表或视图不存在
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1455)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
at org.springframework.context.support.DefaultLifecycleProcessor.getLifecycleBeans(DefaultLifecycleProcessor.java:274)
at org.springframework.context.support.DefaultLifecycleProcessor.startBeans(DefaultLifecycleProcessor.java:125)
at org.springframework.context.support.DefaultLifecycleProcessor.onRefresh(DefaultLifecycleProcessor.java:108)
at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:926)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:467)
at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:384)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:283)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:111)
at com.hp.boss3.core.portal.driver.PortalStartupListener.contextInitialized(PortalStartupListener.java:101)
at com.hp.boss3.core.listener.StartupListener.contextInitialized(StartupListener.java:60)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4206)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4705)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601)
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1079)
at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:1002)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:506)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1065)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:840)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)
at org.apache.catalina.core.StandardService.start(StandardService.java:525)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:754)
at org.apache.catalina.startup.Catalina.start(Catalina.java:595)
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:592)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
Caused by: org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception: org.quartz.JobPersistenceException: Couldn't clean volatile data: ORA-00942: 表或视图不存在
[See nested exception: java.sql.SQLException: ORA-00942: 表或视图不存在
at org.quartz.impl.jdbcjobstore.JobStoreSupport.initialize(JobStoreSupport.java:607)
at org.quartz.impl.jdbcjobstore.JobStoreCMT.initialize(JobStoreCMT.java:142)
at org.springframework.scheduling.quartz.LocalDataSourceJobStore.initialize(LocalDataSourceJobStore.java:151)
at org.quartz.impl.StdSchedulerFactory.instantiate(StdSchedulerFactory.java:1260)
at org.quartz.impl.StdSchedulerFactory.getScheduler(StdSchedulerFactory.java:1451)
at org.springframework.scheduling.quartz.SchedulerFactoryBean.createScheduler(SchedulerFactoryBean.java:598)
at org.springframework.scheduling.quartz.SchedulerFactoryBean.afterPropertiesSet(SchedulerFactoryBean.java:479)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1514)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1452)
... 40 more
Caused by: org.quartz.JobPersistenceException: Couldn't clean volatile data: ORA-00942: 表或视图不存在
[See nested exception: java.sql.SQLException: ORA-00942: 表或视图不存在
at org.quartz.impl.jdbcjobstore.JobStoreSupport.cleanVolatileTriggerAndJobs(JobStoreSupport.java:790)
at org.quartz.impl.jdbcjobstore.JobStoreSupport$1.execute(JobStoreSupport.java:751)
at org.quartz.impl.jdbcjobstore.JobStoreSupport$41.execute(JobStoreSupport.java:3729)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3763)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3725)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.cleanVolatileTriggerAndJobs(JobStoreSupport.java:747)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.initialize(JobStoreSupport.java:605)
... 48 more
Caused by: java.sql.SQLException: ORA-00942: 表或视图不存在
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:877)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3628)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1205)
at mons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at mons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.selectVolatileTriggers(StdJDBCDelegate.java:3491)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.cleanVolatileTriggerAndJobs(JobStoreSupport.java:768)
... 54 more
那位大神给看下，谢谢了！！！
你的数据库中没有数据表与model的类相对应
引用:原帖由 梦朝思夕 于
21:03 发表
你的数据库中没有数据表与model的类相对应 不是这个错误
14:40:36,250 INFO&&[WithName(481)] Portlet Container [rm-portal-driver]: Container initialized successfully.
14:40:36,390 INFO&&[SchedulerFactoryBean.initSchedulerFactory(552)] Loading Quartz config from [class path resource [quartz.properties]]
14:40:36,578 INFO&&[SchedulerSignalerImpl.&init&(60)] Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
14:40:36,578 INFO&&[QuartzScheduler.&init&(219)] Quartz Scheduler v.1.8.0 created.
14:40:36,625 INFO&&[LocalDataSourceJobStore.initialize(592)] Using db table-based data access locking (synchronization).
14:40:37,203 INFO&&[QuartzScheduler.shutdown(613)] Scheduler quartzScheduler_$_NON_CLUSTERED shutting down.
14:40:37,203 INFO&&[QuartzScheduler.standby(534)] Scheduler quartzScheduler_$_NON_CLUSTERED paused.
14:40:37,203 INFO&&[QuartzScheduler.shutdown(667)] Scheduler quartzScheduler_$_NON_CLUSTERED shutdown complete.
14:40:37,203 INFO&&[DefaultListableBeanFactory.destroySingletons(433)] Destroying singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@bafdff: defining beans [dataSource,org.springframework.dao.annotation.PersistenceExceptionTranslationPostProcessor#0,sessionFactory,transactionManager,org.springframework.context.annotation.internalConfigurationAnnotationProcessor,org.springframework.context.annotation.internalAutowiredAnnotationProcessor,org.springframework.context.annotation.internalRequiredAnnotationProcessor,org.springframework.context.annotation.internalCommonAnnotationProcessor,org.springframework.context.annotation.internalPersistenceAnnotationProcessor,CMCCTaskContentDAO,CmccReqDAO,CmccTaskContactDAO,CmccTaskDAO,CmccTaskDevResultDAO,cmccManager,formalInstanceVenderFeedBackDAO,onlineExperienceDAO,reviewDAO,ReviewItemDAO,ReviewQuesDAO,ReviewUserDAO,reviewManager,formalInstanceVenderFeedBackImportManager,onlineExperienceManager,kpiDAO,kpiJobDAO,kpiJobService,kpiService,menuManager,authenticationManager,lookupDAOHibernate,roleDAO,userDAO,lookupManager,roleManager,userManager,compass,compassTemplate,compassSearchHelper,compassGps,org.springframework.aop.config.internalAutoProxyCreator,userManagerTx,userManagerSecurity,managerTx,org.springframework.transaction.annotation.AnnotationTransactionAttributeSource#0,org.springframework.transaction.interceptor.TransactionInterceptor#0,org.springframework.transaction.config.internalTransactionAdvisor,txAdvice,userManagerTxAdvice,userSecurityAdvice,mailEngine,mailSender,velocityEngine,mailMessage,passwordEncoder,jobLogListener,quartzScheduler,schedulerEngine,quartzDAO,schedulerManager,cxf,org.apache.cxf.bus.spring.BusWiringBeanFactoryPostProcessor,org.apache.cxf.bus.spring.Jsr250BeanPostProcessor,org.apache.cxf.bus.spring.BusExtensionPostProcessor,org.apache.cxf.binding.soap.SoapBindingFactory,org.apache.cxf.binding.soap.SoapTransportFactory,org.apache.cxf.binding.soap.customEditorConfigurer,formaInstanceServiceEP,formaInstanceWebService,knowledgeWebServiceEP,knowledgeWebService,notificationWebServiceEP,notificationWebService,draftInsatcneBIWebServiceEP,draftInsatcneBIWebService,draftInsatcneBIWebServiceByTodayEP,draftInsatcneBIWebServiceByToday,dozer,taskExecutor,processService,springContextUtil,PortletContainer,PlutoServices,PortalDriverServices,PortalContext,DriverConfiguration,AdminConfiguration,ResourceConfigFactory,PortalURLParser,RenderConfigService,SupportedModesService,SupportedWindowStatesService,PortletRequestContextService,EventCoordinationService,FilterManagerService,PortletURLListenerService,PortletContextService,RequestDispatcherService,org.springframework.context.annotation.ConfigurationClassPostProcessor$ImportAwareBeanPostProcessor#0]; root of factory hierarchy
14:40:37,250 INFO&&[AnnotationSessionFactoryBean.destroy(246)] Closing Hibernate SessionFactory
14:40:37,250 INFO&&[SessionFactoryImpl.close(927)] closing
14:40:37,250 ERROR [ContextLoader.initWebApplicationContext(307)] Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'quartzScheduler' defined in class path resource [applicationContext-scheduler.xml]: Invocation o nested exception is org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception: org.quartz.JobPersistenceException: Couldn't clean volatile data: ORA-00942: 表或视图不存在
[See nested exception: java.sql.SQLException: ORA-00942: 表或视图不存在
这是前面的几句
应该是你的配置出错了
引用:原帖由 梦朝思夕 于
15:59 发表
应该是你的配置出错了 看了下，少表了:Q ，建好表，再看tomcat启动报错,无法创建 bean listenerStatusChangeDealHandler, no queue 'STOCK.NOTIFY_CHANGE.INTER.CACHE.QUEUE' in vhost从启动日志来看，有时候仅会看到内存泄漏，而没有与queue相关的日志，很容易走错方向。按照 &的方法可以看到详细日志，从而确定报错原因tomcat启动报错,无法创建 bean listenerStatusChangeDealHandler, no queue 'STOCK.NOTIFY_CHANGE.INTER.CACHE.QUEUE' in vhostJun 5, :42 PM org.apache.catalina.core.StandardContext listenerStartSEVERE: Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoaderListenerorg.springframework.context.ApplicationContextException: Failed to start bean 'listenerStatusChangeDealHandler'; nested exception is org.springframework.amqp.AmqpIllegalStateException: Fatal exception on listener startup at org.springframework.context.support.DefaultLifecycleProcessor.doStart(DefaultLifecycleProcessor.java:169) ...Caused by: org.springframework.amqp.AmqpIllegalStateException: Fatal exception on listener startup at org.springframework.amqp.rabbit.listener.SimpleMessageListenerContainer.doStart(SimpleMessageListenerContainer.java:339) at org.springframework.amqp.rabbit.listener.AbstractMessageListenerContainer.start(AbstractMessageListenerContainer.java:363) at org.springframework.context.support.DefaultLifecycleProcessor.doStart(DefaultLifecycleProcessor.java:166) ... 33 moreCaused by: org.springframework.amqp.rabbit.listener.FatalListenerStartupException: Cannot prepare queue for listener. Either the queue doesn't exist or the broker will not allow us to use it. at org.springframework.amqp.rabbit.listener.BlockingQueueConsumer.start(BlockingQueueConsumer.java:228) at org.springframework.amqp.rabbit.listener.SimpleMessageListenerContainer$AsyncMessageProcessingConsumer.run(SimpleMessageListenerContainer.java:524) at java.lang.Thread.run(Thread.java:662)Caused by: com.rabbitmq.client.ShutdownSignalException: reason: {#method&channel.close&(reply-code=404, reply-text=NOT_FOUND - no queue 'STOCK.NOTIFY_CHANGE.INTER.CACHE.QUEUE' in vhost '/', class-id=50, method-id=10), null, &&} at com.rabbitmq.utility.ValueOrException.getValue(ValueOrException.java:67) at com.rabbitmq.utility.BlockingValueOrException.uninterruptibleGetValue(BlockingValueOrException.java:33) at com.rabbitmq.client.impl.AMQChannel$BlockingRpcContinuation.getReply(AMQChannel.java:343) at com.rabbitmq.client.impl.AMQChannel.privateRpc(AMQChannel.java:216) at com.rabbitmq.client.impl.AMQChannel.exnWrappingRpc(AMQChannel.java:118) ... 11 moreCaused by: com.rabbitmq.client.ShutdownSignalException: reason: {#method&channel.close&(reply-code=404, reply-text=NOT_FOUND - no queue 'STOCK.NOTIFY_CHANGE.INTER.CACHE.QUEUE' in vhost '/', class-id=50, method-id=10), null, &&} at com.rabbitmq.client.impl.ChannelN.asyncShutdown(ChannelN.java:454) at com.rabbitmq.client.impl.ChannelN.processAsync(ChannelN.java:294) at com.rabbitmq.client.impl.AMQChannel.handleCompleteInboundCommand(AMQChannel.java:144) at com.rabbitmq.client.impl.AMQChannel.handleFrame(AMQChannel.java:91) at com.rabbitmq.client.impl.AMQConnection$MainLoop.run(AMQConnection.java:526)Jun 5, :42 PM org.apache.catalina.core.StandardContext startSEVERE: Error listenerStartJun 5, :42 PM org.apache.catalina.core.StandardContext startSEVERE: Context [/TravelHubPkgStock] startup failed due to previous errorsJun 5, :42 PM org.apache.catalina.core.ApplicationContext logINFO: Closing Spring root WebApplicationContextJun 5, :42 PM org.apache.catalina.loader.WebappClassLoader clearReferencesJdbcSEVERE: The web application [/TravelHubPkgStock] registered the JDBC driver [oracle.jdbc.driver.OracleDriver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.Jun 5, :42 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreadsSEVERE: The web application [/TravelHubPkgStock] appears to have started a thread named [Thread-2] but has failed to stop it. This is very likely to create a memory leak.Jun 5, :42 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreadsSEVERE: The web application [/TravelHubPkgStock] appears to have started a thread named [Thread-3] but has failed to stop it. This is very likely to create a memory leak.Jun 5, :47 PM org.apache.coyote.http11.Http11Protocol startINFO: Starting Coyote HTTP/1.1 on http-8080Jun 5, :48 PM org.mon.ChannelSocket initINFO: JK: ajp13 listening on /0.0.0.0:9090Jun 5, :48 PM org.apache.jk.server.JkMain startINFO: Jk running ID=0 time=0/121
config=nullJun 5, :48 PM org.apache.catalina.startup.Catalina startINFO: Server startup in 324602 ms经过排查和测试，发现项目中使用rabbitmq服务，而rabbitmq于昨天被重装了，从而里面的队列全部没有了，导致项目启动时初始化bean时候报错。有趣的是，之前rabbitmq停止服务时，该项目启动正常，而rabbitmq服务提供服务，且某一指定队列不存在时，项目却无法正常启动，由此可见，代码的健壮性有待改进哪。Oracle删除表时报错:表或视图不存在_数据库技术_Linux公社-Linux系统门户网站
你好，游客
Oracle删除表时报错:表或视图不存在
来源：Linux社区&
作者：Oracle
明明该表是存在的,删除时报:表或视图不存在~!
第 1 行出现错误:ORA-00942: 表或视图不存在
后来终于找出原因是因为我的表名是小写的，而是大写的则不会出现这个问题。
正常情况下....数据字典里面的数据都是大写,,,,动态视图都是小写的........在用关键字做表或其它对象的名时用""
所以表名用""引起来就行了
如何删除表时用了CASCADE CONSTRAINTS则会把与它相关的约束一起删除
相关资讯 & & &
& (02/03/:05)
& (07/26/:48)
& (07/12/:30)
& (07/31/:18)
& (07/20/:05)
图片资讯 & & &
　　　同意评论声明
　　　发表
尊重网上道德，遵守中华人民共和国的各项有关法律法规
承担一切因您的行为而直接或间接导致的民事或刑事法律责任
本站管理人员有权保留或删除其管辖留言中的任意内容
本站有权在网站内转载或引用您的评论
参与本评论即表明您已经阅读并接受上述条款
gj 发表于 sx