Springmvc_hibernate_postgreSql架构:org.postgresql.util.PSQLException: 错误: 关系 “xxxx“ 不存在 及 postgresql不存在dual如何解决
* 博客文章部分截图及内容来自于学习的书本及相应培训课程以及网络其他博客,仅做学习讨论之用,不做商业用途。
* 如有侵权,马上联系我,我立马删除对应链接。
* @author Alan
* @Email no008@foxmail.com
正文
postgresql不存在dual如何解决
说明:本项目的架构是Springmvc_hibernate_oracle 的大体架构。因客户实际服务器情况需要,导致本项目的的 数据由 oracel改为 postgresql数据库了。
故在改造项目过程中出现了一下相关问题:
1:变更maven 的pom数据库驱动配置:
1 <!--<dependency> 2 <groupId>com.oracle</groupId> 3 <artifactId>ojdbc6</artifactId> 4 <version>11.2.0.4.0-atlassian-hosted</version> 5 </dependency>--> 6 <!--数据库相关--> 7 <!-- https://mvnrepository.com/artifact/org.postgresql/postgresql --> 8 <dependency> 9 <groupId>org.postgresql</groupId> 10 <artifactId>postgresql</artifactId> 11 <version>42.2.2</version> 12 </dependency>
2:jdbc 数据库配置连接内容;
1 #------------------------------------------------------------------------------- 2 # ORACLE Settings 3 #jdbc.driverClassName=oracle.jdbc.OracleDriver 4 #jdbc.url=jdbc:oracle:thin:@127.0.0.1:1521:orcl 5 #jdbc.username=POST_STADY_TX 6 #jdbc.password=POST_STADY_TX 7 8 # PostgreSQL Settings 9 jdbc.driverClassName=org.postgresql.Driver 10 jdbc.url=jdbc:postgresql://127.0.0.1:5432/postStady 11 jdbc.username=post_stady 12 jdbc.password=post_stady 13 14
3:启动项目出现的错误:
1 H:\SoftCodes\Tomcat\Tomcat_idea_202001\apache-tomcat-9.0.22_fsb2021\bin\catalina.bat run 2 [2021-11-02 09:36:10,095] Artifact fsb:war exploded: Waiting for server connection to start artifact deployment... 3 Using CATALINA_BASE: "C:\Users\Admin\AppData\Local\JetBrains\IntelliJIdea2020.3\tomcat\Unnamed_zhpfds_2" 4 Using CATALINA_HOME: "H:\SoftCodes\Tomcat\Tomcat_idea_202001\apache-tomcat-9.0.22_fsb2021" 5 Using CATALINA_TMPDIR: "H:\SoftCodes\Tomcat\Tomcat_idea_202001\apache-tomcat-9.0.22_fsb2021\temp" 6 Using JRE_HOME: "D:\SoftWare\Develop_SoftWare\Java\jdk1.8.0_221" 7 Using CLASSPATH: "H:\SoftCodes\Tomcat\Tomcat_idea_202001\apache-tomcat-9.0.22_fsb2021\bin\bootstrap.jar;H:\SoftCodes\Tomcat\Tomcat_idea_202001\apache-tomcat-9.0.22_fsb2021\bin\tomcat-juli.jar" 8 02-Nov-2021 09:36:14.154 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Server.服务器版本: Apache Tomcat/9.0.22 9 02-Nov-2021 09:36:14.160 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Server.构建: Jul 4 2019 14:20:06 UTC 10 02-Nov-2021 09:36:14.160 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Server version number: 9.0.22.0 11 02-Nov-2021 09:36:14.161 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name: Windows 10 12 02-Nov-2021 09:36:14.161 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log OS.版本: 10.0 13 02-Nov-2021 09:36:14.161 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log 结.造: amd64 14 02-Nov-2021 09:36:14.162 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Java 环境变量: D:\SoftWare\Develop_SoftWare\Java\jdk1.8.0_221\jre 15 02-Nov-2021 09:36:14.162 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log JVM 版本: 1.8.0_221-b11 16 02-Nov-2021 09:36:14.162 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log JVM.供应商: Oracle Corporation 17 02-Nov-2021 09:36:14.165 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE: C:\Users\Admin\AppData\Local\JetBrains\IntelliJIdea2020.3\tomcat\Unnamed_zhpfds_2 18 02-Nov-2021 09:36:14.165 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME: H:\SoftCodes\Tomcat\Tomcat_idea_202001\apache-tomcat-9.0.22_fsb2021 19 02-Nov-2021 09:36:14.166 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.config.file=C:\Users\Admin\AppData\Local\JetBrains\IntelliJIdea2020.3\tomcat\Unnamed_zhpfds_2\conf\logging.properties 20 02-Nov-2021 09:36:14.166 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager 21 02-Nov-2021 09:36:14.167 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Xms512m 22 02-Nov-2021 09:36:14.167 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Xmx1024m 23 02-Nov-2021 09:36:14.167 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -XX:PermSize=256m 24 02-Nov-2021 09:36:14.168 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -XX:MaxPermSize=256m 25 02-Nov-2021 09:36:14.168 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dfile.encoding=utf-8 26 02-Nov-2021 09:36:14.168 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcom.sun.management.jmxremote= 27 02-Nov-2021 09:36:14.168 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcom.sun.management.jmxremote.port=1998 28 02-Nov-2021 09:36:14.169 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcom.sun.management.jmxremote.ssl=false 29 02-Nov-2021 09:36:14.169 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcom.sun.management.jmxremote.password.file=C:\Users\Admin\AppData\Local\JetBrains\IntelliJIdea2020.3\tomcat\Unnamed_zhpfds_2\jmxremote.password 30 02-Nov-2021 09:36:14.169 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcom.sun.management.jmxremote.access.file=C:\Users\Admin\AppData\Local\JetBrains\IntelliJIdea2020.3\tomcat\Unnamed_zhpfds_2\jmxremote.access 31 02-Nov-2021 09:36:14.169 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.rmi.server.hostname=127.0.0.1 32 02-Nov-2021 09:36:14.169 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djdk.tls.ephemeralDHKeySize=2048 33 02-Nov-2021 09:36:14.170 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.protocol.handler.pkgs=org.apache.catalina.webresources 34 02-Nov-2021 09:36:14.170 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dignore.endorsed.dirs= 35 02-Nov-2021 09:36:14.170 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.base=C:\Users\Admin\AppData\Local\JetBrains\IntelliJIdea2020.3\tomcat\Unnamed_zhpfds_2 36 02-Nov-2021 09:36:14.170 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.home=H:\SoftCodes\Tomcat\Tomcat_idea_202001\apache-tomcat-9.0.22_fsb2021 37 02-Nov-2021 09:36:14.170 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.io.tmpdir=H:\SoftCodes\Tomcat\Tomcat_idea_202001\apache-tomcat-9.0.22_fsb2021\temp 38 02-Nov-2021 09:36:14.170 信息 [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent Loaded APR based Apache Tomcat Native library [1.2.23] using APR version [1.7.0]. 39 02-Nov-2021 09:36:14.171 信息 [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent APR capabilities: IPv6 [true], sendfile [true], accept filters [false], random [true]. 40 02-Nov-2021 09:36:14.171 信息 [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent APR/OpenSSL configuration: useAprConnector [false], useOpenSSL [true] 41 02-Nov-2021 09:36:14.184 信息 [main] org.apache.catalina.core.AprLifecycleListener.initializeSSL OpenSSL successfully initialized [OpenSSL 1.1.1c 28 May 2019] 42 02-Nov-2021 09:36:14.816 信息 [main] org.apache.coyote.AbstractProtocol.init 初始化协议处理器 ["http-nio-8083"] 43 02-Nov-2021 09:36:14.915 信息 [main] org.apache.coyote.AbstractProtocol.init 初始化协议处理器 ["ajp-nio-8009"] 44 02-Nov-2021 09:36:14.921 信息 [main] org.apache.catalina.startup.Catalina.load 服务器在[1,230]毫秒内初始化 45 02-Nov-2021 09:36:14.987 信息 [main] org.apache.catalina.core.StandardService.startInternal Starting service [Catalina] 46 02-Nov-2021 09:36:14.988 信息 [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet engine: [Apache Tomcat/9.0.22] 47 02-Nov-2021 09:36:15.018 信息 [main] org.apache.coyote.AbstractProtocol.start 开始协议处理句柄["http-nio-8083"] 48 02-Nov-2021 09:36:15.052 信息 [main] org.apache.coyote.AbstractProtocol.start 开始协议处理句柄["ajp-nio-8009"] 49 02-Nov-2021 09:36:15.060 信息 [main] org.apache.catalina.startup.Catalina.start Server startup in [138] milliseconds 50 Connected to server 51 [2021-11-02 09:36:15,493] Artifact fsb:war exploded: Artifact is being deployed, please wait... 52 02-Nov-2021 09:36:37.510 信息 [RMI TCP Connection(5)-127.0.0.1] org.apache.jasper.servlet.TldScanner.scanJars 至少有一个JAR被扫描用于TLD但尚未包含TLD。 为此记录器启用调试日志记录,以获取已扫描但未在其中找到TLD的完整JAR列表。 在扫描期间跳过不需要的JAR可以缩短启动时间和JSP编译时间。 53 2021-11-02 09:36:51 - WARN PropertyOverrideConfigurer( 200 ) - Could not load properties from class path resource [context.core.bean.properties]: class path resource [context.core.bean.properties] cannot be opened because it does not exist 54 2021-11-02 09:36:56 - INFO AnnotationSessionFactoryBean( 777 ) - Building new Hibernate SessionFactory 55 2021-11-02 09:36:57 - WARN RootClass( 253 ) - composite-id class does not override equals(): com.todaytech.pwp.acl.model.RoleDetailPK 56 2021-11-02 09:36:57 - WARN RootClass( 258 ) - composite-id class does not override hashCode(): com.todaytech.pwp.acl.model.RoleDetailPK 57 2021-11-02 09:37:03 - WARN JDBCExceptionReporter( 233 ) - SQL Error: 0, SQLState: null 58 2021-11-02 09:37:03 - ERROR JDBCExceptionReporter( 234 ) - Cannot create PoolableConnectionFactory (错误: 关系 "dual" 不存在 59 位置:15) 60 2021-11-02 09:37:03 - WARN SettingsFactory( 147 ) - Could not obtain connection to query metadata 61 org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (错误: 关系 "dual" 不存在 62 位置:15) 63 at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549) 64 at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388) 65 at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) 66 at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81) 67 at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:113) 68 at org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2863) 69 at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2859) 70 at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1870) 71 at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:860) 72 at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:779) 73 at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFactoryBean.java:211) 74 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1514) 75 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1452) 76 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519) 77 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456) 78 at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294) 79 at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225) 80 at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291) 81 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193) 82 at org.springframework.beans.factory.support.DefaultListableBeanFactory.findAutowireCandidates(DefaultListableBeanFactory.java:848) 83 at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:790) 84 at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:707) 85 at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredMethodElement.inject(AutowiredAnnotationBeanPostProcessor.java:551) 86 at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:87) 87 at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:284) 88 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1106) 89 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517) 90 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456) 91 at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294) 92 at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225) 93 at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291) 94 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193) 95 at org.springframework.beans.factory.support.DefaultListableBeanFactory.findAutowireCandidates(DefaultListableBeanFactory.java:848) 96 at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:790) 97 at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:707) 98 at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.autowireResource(CommonAnnotationBeanPostProcessor.java:438) 99 at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.getResource(CommonAnnotationBeanPostProcessor.java:416) 100 at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor$ResourceElement.getResourceToInject(CommonAnnotationBeanPostProcessor.java:549) 101 at org.springframework.beans.factory.annotation.InjectionMetadata$InjectedElement.inject(InjectionMetadata.java:150) 102 at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:87) 103 at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.postProcessPropertyValues(CommonAnnotationBeanPostProcessor.java:303) 104 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1106) 105 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517) 106 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456) 107 at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294) 108 at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225) 109 at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291) 110 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197) 111 at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.autowireResource(CommonAnnotationBeanPostProcessor.java:442) 112 at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.getResource(CommonAnnotationBeanPostProcessor.java:416) 113 at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor$ResourceElement.getResourceToInject(CommonAnnotationBeanPostProcessor.java:549) 114 at org.springframework.beans.factory.annotation.InjectionMetadata$InjectedElement.inject(InjectionMetadata.java:150) 115 at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:87) 116 at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.postProcessPropertyValues(CommonAnnotationBeanPostProcessor.java:303) 117 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1106) 118 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517) 119 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456) 120 at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294) 121 at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225) 122 at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291) 123 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193) 124 at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:585) 125 at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:913) 126 at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:464) 127 at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:139) 128 at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:83) 129 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) 130 at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) 131 at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) 132 at java.lang.reflect.Constructor.newInstance(Constructor.java:423) 133 at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:147) 134 at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:110) 135 at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:280) 136 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1035) 137 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:939) 138 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:485) 139 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456) 140 at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294) 141 at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225) 142 at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291) 143 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197) 144 at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1097) 145 at org.springframework.beans.factory.access.SingletonBeanFactoryLocator.useBeanFactory(SingletonBeanFactoryLocator.java:394) 146 at org.springframework.web.context.ContextLoader.loadParentContext(ContextLoader.java:521) 147 at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:375) 148 at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:283) 149 at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:111) 150 at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4682) 151 at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5143) 152 at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) 153 at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:717) 154 at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:690) 155 at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:705) 156 at org.apache.catalina.startup.HostConfig.manageApp(HostConfig.java:1728) 157 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 158 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) 159 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 160 at java.lang.reflect.Method.invoke(Method.java:498) 161 at org.apache.tomcat.util.modeler.BaseModelMBean.invoke(BaseModelMBean.java:289) 162 at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:819) 163 at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:801) 164 at org.apache.catalina.mbeans.MBeanFactory.createStandardContext(MBeanFactory.java:457) 165 at org.apache.catalina.mbeans.MBeanFactory.createStandardContext(MBeanFactory.java:406) 166 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 167 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) 168 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 169 at java.lang.reflect.Method.invoke(Method.java:498) 170 at org.apache.tomcat.util.modeler.BaseModelMBean.invoke(BaseModelMBean.java:289) 171 at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:819) 172 at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:801) 173 at com.sun.jmx.remote.security.MBeanServerAccessController.invoke(MBeanServerAccessController.java:468) 174 at javax.management.remote.rmi.RMIConnectionImpl.doOperation(RMIConnectionImpl.java:1468) 175 at javax.management.remote.rmi.RMIConnectionImpl.access$300(RMIConnectionImpl.java:76) 176 at javax.management.remote.rmi.RMIConnectionImpl$PrivilegedOperation.run(RMIConnectionImpl.java:1309) 177 at java.security.AccessController.doPrivileged(Native Method) 178 at javax.management.remote.rmi.RMIConnectionImpl.doPrivilegedOperation(RMIConnectionImpl.java:1408) 179 at javax.management.remote.rmi.RMIConnectionImpl.invoke(RMIConnectionImpl.java:829) 180 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 181 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) 182 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 183 at java.lang.reflect.Method.invoke(Method.java:498) 184 at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:357) 185 at sun.rmi.transport.Transport$1.run(Transport.java:200) 186 at sun.rmi.transport.Transport$1.run(Transport.java:197) 187 at java.security.AccessController.doPrivileged(Native Method) 188 at sun.rmi.transport.Transport.serviceCall(Transport.java:196) 189 at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:573) 190 at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:834) 191 at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.lambda$run$0(TCPTransport.java:688) 192 at java.security.AccessController.doPrivileged(Native Method) 193 at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:687) 194 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) 195 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) 196 at java.lang.Thread.run(Thread.java:748) 197 Caused by: org.postgresql.util.PSQLException: 错误: 关系 "dual" 不存在 198 位置:15 199 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2433) 200 at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2178) 201 at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:306) 202 at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441) 203 at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365) 204 at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307) 205 at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293) 206 at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270) 207 at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:224) 208 at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) 209 at org.apache.commons.dbcp.PoolableConnectionFactory.validateConnection(PoolableConnectionFactory.java:658) 210 at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1558) 211 at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545) 212 ... 133 more 213 2021-11-02 09:37:04 - WARN ConfigurationFactory( 134 ) - No configuration found. Configuring ehcache from ehcache-failsafe.xml found in the classpath: jar:file:/H:/SoftCodes/GDFS2021/BaseFrame2021/target/fsb/WEB-INF/lib/ehcache-core-2.5.0.jar!/ehcache-failsafe.xml 214 2021-11-02 09:37:06 - WARN EhCacheProvider( 93 ) - Could not find configuration [org.hibernate.cache.UpdateTimestampsCache]; using defaults. 215 2021-11-02 09:37:06 - WARN EhCacheProvider( 93 ) - Could not find configuration [org.hibernate.cache.StandardQueryCache]; using defaults. 216 2021-11-02 09:37:08 - INFO AnnotationSessionFactoryBean( 246 ) - Closing Hibernate SessionFactory 217 2021-11-02 09:37:08 - ERROR ContextLoader( 307 ) - Context initialization failed 218 org.springframework.beans.factory.access.BootstrapException: Unable to return specified BeanFactory instance: factory key [com.todaytech.pwp.context], from group with resource name [classpath*:beanRefContext.xml]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'com.todaytech.pwp.context' defined in URL [jar:file:/H:/SoftCodes/GDFS2021/BaseFrame2021/target/fsb/WEB-INF/lib/pwp-core-2.0.1.20171009.18.jar!/beanRefContext.xml]: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [org.springframework.context.support.ClassPathXmlApplicationContext]: Constructor threw exception; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'authCtrl': Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'authSrv': Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'organizationRep': Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'defaultDao': Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sequence' defined in URL [jar:file:/H:/SoftCodes/GDFS2021/BaseFrame2021/target/fsb/WEB-INF/lib/pwp-core-2.0.1.20171009.18.jar!/conf/context.core.xml]: Invocation of init method failed; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (错误: 关系 "dual" 不存在 219 位置:15) 220 at org.springframework.beans.factory.access.SingletonBeanFactoryLocator.useBeanFactory(SingletonBeanFactoryLocator.java:402) 221 at org.springframework.web.context.ContextLoader.loadParentContext(ContextLoader.java:521) 222 at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:375) 223 at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:283) 224 at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:111) 225 at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4682) 226 at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5143) 227 at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) 228 at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:717) 229 at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:690) 230 at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:705) 231 at org.apache.catalina.startup.HostConfig.manageApp(HostConfig.java:1728) 232 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 233 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) 234 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 235 at java.lang.reflect.Method.invoke(Method.java:498) 236 at org.apache.tomcat.util.modeler.BaseModelMBean.invoke(BaseModelMBean.java:289) 237 at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:819) 238 at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:801) 239 at org.apache.catalina.mbeans.MBeanFactory.createStandardContext(MBeanFactory.java:457) 240 at org.apache.catalina.mbeans.MBeanFactory.createStandardContext(MBeanFactory.java:406) 241 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 242 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) 243 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 244 at java.lang.reflect.Method.invoke(Method.java:498) 245 at org.apache.tomcat.util.modeler.BaseModelMBean.invoke(BaseModelMBean.java:289) 246 at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:819) 247 at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:801) 248 at com.sun.jmx.remote.security.MBeanServerAccessController.invoke(MBeanServerAccessController.java:468) 249 at javax.management.remote.rmi.RMIConnectionImpl.doOperation(RMIConnectionImpl.java:1468) 250 at javax.management.remote.rmi.RMIConnectionImpl.access$300(RMIConnectionImpl.java:76) 251 at javax.management.remote.rmi.RMIConnectionImpl$PrivilegedOperation.run(RMIConnectionImpl.java:1309) 252 at java.security.AccessController.doPrivileged(Native Method) 253 at javax.management.remote.rmi.RMIConnectionImpl.doPrivilegedOperation(RMIConnectionImpl.java:1408) 254 at javax.management.remote.rmi.RMIConnectionImpl.invoke(RMIConnectionImpl.java:829) 255 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 256 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) 257 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 258 at java.lang.reflect.Method.invoke(Method.java:498) 259 at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:357) 260 at sun.rmi.transport.Transport$1.run(Transport.java:200) 261 at sun.rmi.transport.Transport$1.run(Transport.java:197) 262 at java.security.AccessController.doPrivileged(Native Method) 263 at sun.rmi.transport.Transport.serviceCall(Transport.java:196) 264 at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:573) 265 at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:834) 266 at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.lambda$run$0(TCPTransport.java:688) 267 at java.security.AccessController.doPrivileged(Native Method) 268 at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:687) 269 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) 270 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) 271 at java.lang.Thread.run(Thread.java:748) 272 Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'com.todaytech.pwp.context' defined in URL [jar:file:/H:/SoftCodes/GDFS2021/BaseFrame2021/target/fsb/WEB-INF/lib/pwp-core-2.0.1.20171009.18.jar!/beanRefContext.xml]: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [org.springframework.context.support.ClassPathXmlApplicationContext]: Constructor threw exception; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'authCtrl': Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'authSrv': Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'organizationRep': Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'defaultDao': Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sequence' defined in URL [jar:file:/H:/SoftCodes/GDFS2021/BaseFrame2021/target/fsb/WEB-INF/lib/pwp-core-2.0.1.20171009.18.jar!/conf/context.core.xml]: Invocation of init method failed; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (错误: 关系 "dual" 不存在 273 位置:15) 274 at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:288) 275 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1035) 276 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:939) 277 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:485) 278 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456) 279 at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294) 280 at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225) 281 at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291) 282 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197) 283 at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1097) 284 at org.springframework.beans.factory.access.SingletonBeanFactoryLocator.useBeanFactory(SingletonBeanFactoryLocator.java:394) 285 ... 51 more 286 Caused by: org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [org.springframework.context.support.ClassPathXmlApplicationContext]: Constructor threw exception; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'authCtrl': Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'authSrv': Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'organizationRep': Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'defaultDao': Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sequence' defined in URL [jar:file:/H:/SoftCodes/GDFS2021/BaseFrame2021/target/fsb/WEB-INF/lib/pwp-core-2.0.1.20171009.18.jar!/conf/context.core.xml]: Invocation of init method failed; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (错误: 关系 "dual" 不存在 287 位置:15) 288 at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:162) 289 at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:110) 290 at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:280) 291 ... 61 more 292 Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'authCtrl': Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'authSrv': Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'organizationRep': Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'defaultDao': Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sequence' defined in URL [jar:file:/H:/SoftCodes/GDFS2021/BaseFrame2021/target/fsb/WEB-INF/lib/pwp-core-2.0.1.20171009.18.jar!/conf/context.core.xml]: Invocation of init method failed; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (错误: 关系 "dual" 不存在 293 位置:15) 294 at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.postProcessPropertyValues(CommonAnnotationBeanPostProcessor.java:306) 295 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1106) 296 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517) 297 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456) 298 at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294) 299 at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225) 300 at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291) 301 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193) 302 at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:585) 303 at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:913) 304 at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:464) 305 at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:139) 306 at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:83) 307 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) 308 at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) 309 at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) 310 at java.lang.reflect.Constructor.newInstance(Constructor.java:423) 311 at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:147) 312 ... 63 more 313 Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'authSrv': Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'organizationRep': Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'defaultDao': Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sequence' defined in URL [jar:file:/H:/SoftCodes/GDFS2021/BaseFrame2021/target/fsb/WEB-INF/lib/pwp-core-2.0.1.20171009.18.jar!/conf/context.core.xml]: Invocation of init method failed; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (错误: 关系 "dual" 不存在 314 位置:15) 315 at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.postProcessPropertyValues(CommonAnnotationBeanPostProcessor.java:306) 316 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1106) 317 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517) 318 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456) 319 at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294) 320 at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225) 321 at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291) 322 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197) 323 at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.autowireResource(CommonAnnotationBeanPostProcessor.java:442) 324 at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.getResource(CommonAnnotationBeanPostProcessor.java:416) 325 at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor$ResourceElement.getResourceToInject(CommonAnnotationBeanPostProcessor.java:549) 326 at org.springframework.beans.factory.annotation.InjectionMetadata$InjectedElement.inject(InjectionMetadata.java:150) 327 at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:87) 328 at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.postProcessPropertyValues(CommonAnnotationBeanPostProcessor.java:303) 329 ... 80 more 330 Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'organizationRep': Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'defaultDao': Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sequence' defined in URL [jar:file:/H:/SoftCodes/GDFS2021/BaseFrame2021/target/fsb/WEB-INF/lib/pwp-core-2.0.1.20171009.18.jar!/conf/context.core.xml]: Invocation of init method failed; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (错误: 关系 "dual" 不存在 331 位置:15) 332 at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.postProcessPropertyValues(CommonAnnotationBeanPostProcessor.java:306) 333 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1106) 334 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517) 335 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456) 336 at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294) 337 at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225) 338 at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291) 339 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197) 340 at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.autowireResource(CommonAnnotationBeanPostProcessor.java:442) 341 at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.getResource(CommonAnnotationBeanPostProcessor.java:416) 342 at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor$ResourceElement.getResourceToInject(CommonAnnotationBeanPostProcessor.java:549) 343 at org.springframework.beans.factory.annotation.InjectionMetadata$InjectedElement.inject(InjectionMetadata.java:150) 344 at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:87) 345 at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.postProcessPropertyValues(CommonAnnotationBeanPostProcessor.java:303) 346 ... 93 more 347 Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'defaultDao': Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sequence' defined in URL [jar:file:/H:/SoftCodes/GDFS2021/BaseFrame2021/target/fsb/WEB-INF/lib/pwp-core-2.0.1.20171009.18.jar!/conf/context.core.xml]: Invocation of init method failed; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (错误: 关系 "dual" 不存在 348 位置:15) 349 at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.postProcessPropertyValues(CommonAnnotationBeanPostProcessor.java:306) 350 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1106) 351 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517) 352 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456) 353 at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294) 354 at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225) 355 at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291) 356 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197) 357 at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.autowireResource(CommonAnnotationBeanPostProcessor.java:442) 358 at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.getResource(CommonAnnotationBeanPostProcessor.java:416) 359 at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor$ResourceElement.getResourceToInject(CommonAnnotationBeanPostProcessor.java:549) 360 at org.springframework.beans.factory.annotation.InjectionMetadata$InjectedElement.inject(InjectionMetadata.java:150) 361 at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:87) 362 at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.postProcessPropertyValues(CommonAnnotationBeanPostProcessor.java:303) 363 ... 106 more 364 Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sequence' defined in URL [jar:file:/H:/SoftCodes/GDFS2021/BaseFrame2021/target/fsb/WEB-INF/lib/pwp-core-2.0.1.20171009.18.jar!/conf/context.core.xml]: Invocation of init method failed; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (错误: 关系 "dual" 不存在 365 位置:15) 366 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1455) 367 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519) 368 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456) 369 at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294) 370 at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225) 371 at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291) 372 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197) 373 at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.autowireResource(CommonAnnotationBeanPostProcessor.java:442) 374 at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.getResource(CommonAnnotationBeanPostProcessor.java:416) 375 at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor$ResourceElement.getResourceToInject(CommonAnnotationBeanPostProcessor.java:549) 376 at org.springframework.beans.factory.annotation.InjectionMetadata$InjectedElement.inject(InjectionMetadata.java:150) 377 at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:87) 378 at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.postProcessPropertyValues(CommonAnnotationBeanPostProcessor.java:303) 379 02-Nov-2021 09:37:08.689 严重 [RMI TCP Connection(5)-127.0.0.1] org.apache.catalina.core.StandardContext.startInternal One or more listeners failed to start. Full details will be found in the appropriate container log file 380 02-Nov-2021 09:37:08.691 严重 [RMI TCP Connection(5)-127.0.0.1] org.apache.catalina.core.StandardContext.startInternal Context [/fsb2021] startup failed due to previous errors 381 ... 119 more 382 Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (错误: 关系 "dual" 不存在 383 位置:15) 384 at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80) 385 at org.springframework.jdbc.core.support.JdbcDaoSupport.getConnection(JdbcDaoSupport.java:133) 386 at com.todaytech.pwp.core.no.SequenceDao.getAllNo(SequenceDao.java:70) 387 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 388 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) 389 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 390 at java.lang.reflect.Method.invoke(Method.java:498) 391 at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309) 392 at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:196) 393 at com.sun.proxy.$Proxy29.getAllNo(Unknown Source) 394 at com.todaytech.pwp.core.no.DefaultSequence.afterPropertiesSet(DefaultSequence.java:127) 395 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1514) 396 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1452) 397 ... 131 more 398 Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (错误: 关系 "dual" 不存在 399 位置:15) 400 at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549) 401 at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388) 402 at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) 403 at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111) 404 at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77) 405 ... 143 more 406 Caused by: org.postgresql.util.PSQLException: 错误: 关系 "dual" 不存在 407 位置:15 408 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2433) 409 at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2178) 410 at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:306) 411 at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441) 412 at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365) 413 at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307) 414 at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293) 415 at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270) 416 at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:224) 417 at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) 418 at org.apache.commons.dbcp.PoolableConnectionFactory.validateConnection(PoolableConnectionFactory.java:658) 419 at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1558) 420 at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545) 421 ... 147 more 422 02-Nov-2021 09:37:08.774 警告 [RMI TCP Connection(5)-127.0.0.1] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesJdbc Web应用程序 [fsb2021] 注册了JDBC驱动程序 [org.postgresql.Driver],但在Web应用程序停止时无法注销它。 为防止内存泄漏,JDBC驱动程序已被强制取消注册。 423 [2021-11-02 09:37:08,892] Artifact fsb:war exploded: Error during artifact deployment. See server log for details. 424
4:处理该问题的方法:
1 CREATE OR REPLACE VIEW dual AS 2 SELECT NULL::"unknown" 3 WHERE 1 = 1; 4 5 ALTER TABLE dual OWNER TO post_stady; 6 GRANT ALL ON TABLE dual TO public ; 7 GRANT SELECT ON TABLE dual TO public;
5:重新启动项目:
org.postgresql.util.PSQLException: 错误: 关系 “xxxx“ 不存在
1:问题描述
1 H:\SoftCodes\Tomcat\Tomcat_idea_202001\apache-tomcat-9.0.22_fsb2021\bin\catalina.bat run 2 [2021-11-02 09:48:14,579] Artifact fsb:war exploded: Waiting for server connection to start artifact deployment... 3 Using CATALINA_BASE: "C:\Users\Admin\AppData\Local\JetBrains\IntelliJIdea2020.3\tomcat\Unnamed_zhpfds_2" 4 Using CATALINA_HOME: "H:\SoftCodes\Tomcat\Tomcat_idea_202001\apache-tomcat-9.0.22_fsb2021" 5 Using CATALINA_TMPDIR: "H:\SoftCodes\Tomcat\Tomcat_idea_202001\apache-tomcat-9.0.22_fsb2021\temp" 6 Using JRE_HOME: "D:\SoftWare\Develop_SoftWare\Java\jdk1.8.0_221" 7 Using CLASSPATH: "H:\SoftCodes\Tomcat\Tomcat_idea_202001\apache-tomcat-9.0.22_fsb2021\bin\bootstrap.jar;H:\SoftCodes\Tomcat\Tomcat_idea_202001\apache-tomcat-9.0.22_fsb2021\bin\tomcat-juli.jar" 8 02-Nov-2021 09:48:18.671 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Server.服务器版本: Apache Tomcat/9.0.22 9 02-Nov-2021 09:48:18.676 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Server.构建: Jul 4 2019 14:20:06 UTC 10 02-Nov-2021 09:48:18.676 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Server version number: 9.0.22.0 11 02-Nov-2021 09:48:18.676 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name: Windows 10 12 02-Nov-2021 09:48:18.676 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log OS.版本: 10.0 13 02-Nov-2021 09:48:18.676 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log 结.造: amd64 14 02-Nov-2021 09:48:18.676 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Java 环境变量: D:\SoftWare\Develop_SoftWare\Java\jdk1.8.0_221\jre 15 02-Nov-2021 09:48:18.676 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log JVM 版本: 1.8.0_221-b11 16 02-Nov-2021 09:48:18.676 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log JVM.供应商: Oracle Corporation 17 02-Nov-2021 09:48:18.676 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE: C:\Users\Admin\AppData\Local\JetBrains\IntelliJIdea2020.3\tomcat\Unnamed_zhpfds_2 18 02-Nov-2021 09:48:18.677 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME: H:\SoftCodes\Tomcat\Tomcat_idea_202001\apache-tomcat-9.0.22_fsb2021 19 02-Nov-2021 09:48:18.677 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.config.file=C:\Users\Admin\AppData\Local\JetBrains\IntelliJIdea2020.3\tomcat\Unnamed_zhpfds_2\conf\logging.properties 20 02-Nov-2021 09:48:18.678 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager 21 02-Nov-2021 09:48:18.678 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Xms512m 22 02-Nov-2021 09:48:18.679 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Xmx1024m 23 02-Nov-2021 09:48:18.679 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -XX:PermSize=256m 24 02-Nov-2021 09:48:18.680 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -XX:MaxPermSize=256m 25 02-Nov-2021 09:48:18.680 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dfile.encoding=utf-8 26 02-Nov-2021 09:48:18.680 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcom.sun.management.jmxremote= 27 02-Nov-2021 09:48:18.680 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcom.sun.management.jmxremote.port=1998 28 02-Nov-2021 09:48:18.681 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcom.sun.management.jmxremote.ssl=false 29 02-Nov-2021 09:48:18.681 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcom.sun.management.jmxremote.password.file=C:\Users\Admin\AppData\Local\JetBrains\IntelliJIdea2020.3\tomcat\Unnamed_zhpfds_2\jmxremote.password 30 02-Nov-2021 09:48:18.681 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcom.sun.management.jmxremote.access.file=C:\Users\Admin\AppData\Local\JetBrains\IntelliJIdea2020.3\tomcat\Unnamed_zhpfds_2\jmxremote.access 31 02-Nov-2021 09:48:18.682 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.rmi.server.hostname=127.0.0.1 32 02-Nov-2021 09:48:18.682 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djdk.tls.ephemeralDHKeySize=2048 33 02-Nov-2021 09:48:18.683 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.protocol.handler.pkgs=org.apache.catalina.webresources 34 02-Nov-2021 09:48:18.683 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dignore.endorsed.dirs= 35 02-Nov-2021 09:48:18.683 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.base=C:\Users\Admin\AppData\Local\JetBrains\IntelliJIdea2020.3\tomcat\Unnamed_zhpfds_2 36 02-Nov-2021 09:48:18.683 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.home=H:\SoftCodes\Tomcat\Tomcat_idea_202001\apache-tomcat-9.0.22_fsb2021 37 02-Nov-2021 09:48:18.684 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.io.tmpdir=H:\SoftCodes\Tomcat\Tomcat_idea_202001\apache-tomcat-9.0.22_fsb2021\temp 38 02-Nov-2021 09:48:18.684 信息 [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent Loaded APR based Apache Tomcat Native library [1.2.23] using APR version [1.7.0]. 39 02-Nov-2021 09:48:18.685 信息 [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent APR capabilities: IPv6 [true], sendfile [true], accept filters [false], random [true]. 40 02-Nov-2021 09:48:18.688 信息 [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent APR/OpenSSL configuration: useAprConnector [false], useOpenSSL [true] 41 02-Nov-2021 09:48:18.699 信息 [main] org.apache.catalina.core.AprLifecycleListener.initializeSSL OpenSSL successfully initialized [OpenSSL 1.1.1c 28 May 2019] 42 02-Nov-2021 09:48:19.592 信息 [main] org.apache.coyote.AbstractProtocol.init 初始化协议处理器 ["http-nio-8083"] 43 02-Nov-2021 09:48:19.664 信息 [main] org.apache.coyote.AbstractProtocol.init 初始化协议处理器 ["ajp-nio-8009"] 44 02-Nov-2021 09:48:19.674 信息 [main] org.apache.catalina.startup.Catalina.load 服务器在[1,689]毫秒内初始化 45 02-Nov-2021 09:48:19.743 信息 [main] org.apache.catalina.core.StandardService.startInternal Starting service [Catalina] 46 02-Nov-2021 09:48:19.743 信息 [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet engine: [Apache Tomcat/9.0.22] 47 02-Nov-2021 09:48:19.796 信息 [main] org.apache.coyote.AbstractProtocol.start 开始协议处理句柄["http-nio-8083"] 48 02-Nov-2021 09:48:19.856 信息 [main] org.apache.coyote.AbstractProtocol.start 开始协议处理句柄["ajp-nio-8009"] 49 02-Nov-2021 09:48:19.861 信息 [main] org.apache.catalina.startup.Catalina.start Server startup in [185] milliseconds 50 Connected to server 51 [2021-11-02 09:48:20,300] Artifact fsb:war exploded: Artifact is being deployed, please wait... 52 02-Nov-2021 09:48:37.713 信息 [RMI TCP Connection(5)-127.0.0.1] org.apache.jasper.servlet.TldScanner.scanJars 至少有一个JAR被扫描用于TLD但尚未包含TLD。 为此记录器启用调试日志记录,以获取已扫描但未在其中找到TLD的完整JAR列表。 在扫描期间跳过不需要的JAR可以缩短启动时间和JSP编译时间。 53 2021-11-02 09:48:49 - WARN PropertyOverrideConfigurer( 200 ) - Could not load properties from class path resource [context.core.bean.properties]: class path resource [context.core.bean.properties] cannot be opened because it does not exist 54 2021-11-02 09:48:52 - INFO AnnotationSessionFactoryBean( 777 ) - Building new Hibernate SessionFactory 55 2021-11-02 09:48:52 - WARN RootClass( 253 ) - composite-id class does not override equals(): com.todaytech.pwp.acl.model.RoleDetailPK 56 2021-11-02 09:48:52 - WARN RootClass( 258 ) - composite-id class does not override hashCode(): com.todaytech.pwp.acl.model.RoleDetailPK 57 2021-11-02 09:48:57 - WARN ConfigurationFactory( 134 ) - No configuration found. Configuring ehcache from ehcache-failsafe.xml found in the classpath: jar:file:/H:/SoftCodes/GDFS2021/BaseFrame2021/target/fsb/WEB-INF/lib/ehcache-core-2.5.0.jar!/ehcache-failsafe.xml 58 2021-11-02 09:48:58 - WARN EhCacheProvider( 93 ) - Could not find configuration [org.hibernate.cache.UpdateTimestampsCache]; using defaults. 59 2021-11-02 09:48:59 - WARN EhCacheProvider( 93 ) - Could not find configuration [org.hibernate.cache.StandardQueryCache]; using defaults. 60 2021-11-02 09:49:00 - INFO AnnotationSessionFactoryBean( 246 ) - Closing Hibernate SessionFactory 61 2021-11-02 09:49:00 - ERROR ContextLoader( 307 ) - Context initialization failed 62 org.springframework.beans.factory.access.BootstrapException: Unable to return specified BeanFactory instance: factory key [com.todaytech.pwp.context], from group with resource name [classpath*:beanRefContext.xml]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'com.todaytech.pwp.context' defined in URL [jar:file:/H:/SoftCodes/GDFS2021/BaseFrame2021/target/fsb/WEB-INF/lib/pwp-core-2.0.1.20171009.18.jar!/beanRefContext.xml]: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [org.springframework.context.support.ClassPathXmlApplicationContext]: Constructor threw exception; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'authCtrl': Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'authSrv': Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'organizationRep': Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'defaultDao': Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sequence' defined in URL [jar:file:/H:/SoftCodes/GDFS2021/BaseFrame2021/target/fsb/WEB-INF/lib/pwp-core-2.0.1.20171009.18.jar!/conf/context.core.xml]: Invocation of init method failed; nested exception is java.lang.RuntimeException: org.postgresql.util.PSQLException: 错误: 关系 "pwp_no" 不存在 63 位置:92 64 at org.springframework.beans.factory.access.SingletonBeanFactoryLocator.useBeanFactory(SingletonBeanFactoryLocator.java:402) 65 at org.springframework.web.context.ContextLoader.loadParentContext(ContextLoader.java:521) 66 at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:375) 67 at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:283) 68 at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:111) 69 at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4682) 70 at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5143) 71 at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) 72 at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:717) 73 at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:690) 74 at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:705) 75 at org.apache.catalina.startup.HostConfig.manageApp(HostConfig.java:1728) 76 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 77 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) 78 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 79 at java.lang.reflect.Method.invoke(Method.java:498) 80 at org.apache.tomcat.util.modeler.BaseModelMBean.invoke(BaseModelMBean.java:289) 81 at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:819) 82 at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:801) 83 at org.apache.catalina.mbeans.MBeanFactory.createStandardContext(MBeanFactory.java:457) 84 at org.apache.catalina.mbeans.MBeanFactory.createStandardContext(MBeanFactory.java:406) 85 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 86 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) 87 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 88 at java.lang.reflect.Method.invoke(Method.java:498) 89 at org.apache.tomcat.util.modeler.BaseModelMBean.invoke(BaseModelMBean.java:289) 90 at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:819) 91 at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:801) 92 at com.sun.jmx.remote.security.MBeanServerAccessController.invoke(MBeanServerAccessController.java:468) 93 at javax.management.remote.rmi.RMIConnectionImpl.doOperation(RMIConnectionImpl.java:1468) 94 at javax.management.remote.rmi.RMIConnectionImpl.access$300(RMIConnectionImpl.java:76) 95 at javax.management.remote.rmi.RMIConnectionImpl$PrivilegedOperation.run(RMIConnectionImpl.java:1309) 96 at java.security.AccessController.doPrivileged(Native Method) 97 at javax.management.remote.rmi.RMIConnectionImpl.doPrivilegedOperation(RMIConnectionImpl.java:1408) 98 at javax.management.remote.rmi.RMIConnectionImpl.invoke(RMIConnectionImpl.java:829) 99 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 100 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) 101 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 102 at java.lang.reflect.Method.invoke(Method.java:498) 103 at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:357) 104 at sun.rmi.transport.Transport$1.run(Transport.java:200) 105 at sun.rmi.transport.Transport$1.run(Transport.java:197) 106 at java.security.AccessController.doPrivileged(Native Method) 107 at sun.rmi.transport.Transport.serviceCall(Transport.java:196) 108 at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:573) 109 at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:834) 110 at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.lambda$run$0(TCPTransport.java:688) 111 at java.security.AccessController.doPrivileged(Native Method) 112 at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:687) 113 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) 114 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) 115 at java.lang.Thread.run(Thread.java:748) 116 Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'com.todaytech.pwp.context' defined in URL [jar:file:/H:/SoftCodes/GDFS2021/BaseFrame2021/target/fsb/WEB-INF/lib/pwp-core-2.0.1.20171009.18.jar!/beanRefContext.xml]: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [org.springframework.context.support.ClassPathXmlApplicationContext]: Constructor threw exception; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'authCtrl': Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'authSrv': Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'organizationRep': Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'defaultDao': Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sequence' defined in URL [jar:file:/H:/SoftCodes/GDFS2021/BaseFrame2021/target/fsb/WEB-INF/lib/pwp-core-2.0.1.20171009.18.jar!/conf/context.core.xml]: Invocation of init method failed; nested exception is java.lang.RuntimeException: org.postgresql.util.PSQLException: 错误: 关系 "pwp_no" 不存在 117 位置:92 118 at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:288) 119 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1035) 120 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:939) 121 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:485) 122 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456) 123 at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294) 124 at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225) 125 at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291) 126 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197) 127 at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1097) 128 at org.springframework.beans.factory.access.SingletonBeanFactoryLocator.useBeanFactory(SingletonBeanFactoryLocator.java:394) 129 ... 51 more 130 Caused by: org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [org.springframework.context.support.ClassPathXmlApplicationContext]: Constructor threw exception; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'authCtrl': Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'authSrv': Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'organizationRep': Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'defaultDao': Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sequence' defined in URL [jar:file:/H:/SoftCodes/GDFS2021/BaseFrame2021/target/fsb/WEB-INF/lib/pwp-core-2.0.1.20171009.18.jar!/conf/context.core.xml]: Invocation of init method failed; nested exception is java.lang.RuntimeException: org.postgresql.util.PSQLException: 错误: 关系 "pwp_no" 不存在 131 位置:92 132 at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:162) 133 at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:110) 134 at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:280) 135 ... 61 more 136 Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'authCtrl': Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'authSrv': Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'organizationRep': Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'defaultDao': Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sequence' defined in URL [jar:file:/H:/SoftCodes/GDFS2021/BaseFrame2021/target/fsb/WEB-INF/lib/pwp-core-2.0.1.20171009.18.jar!/conf/context.core.xml]: Invocation of init method failed; nested exception is java.lang.RuntimeException: org.postgresql.util.PSQLException: 错误: 关系 "pwp_no" 不存在 137 位置:92 138 at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.postProcessPropertyValues(CommonAnnotationBeanPostProcessor.java:306) 139 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1106) 140 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517) 141 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456) 142 at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294) 143 at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225) 144 at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291) 145 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193) 146 at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:585) 147 at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:913) 148 at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:464) 149 at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:139) 150 at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:83) 151 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) 152 at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) 153 at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) 154 at java.lang.reflect.Constructor.newInstance(Constructor.java:423) 155 at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:147) 156 ... 63 more 157 Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'authSrv': Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'organizationRep': Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'defaultDao': Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sequence' defined in URL [jar:file:/H:/SoftCodes/GDFS2021/BaseFrame2021/target/fsb/WEB-INF/lib/pwp-core-2.0.1.20171009.18.jar!/conf/context.core.xml]: Invocation of init method failed; nested exception is java.lang.RuntimeException: org.postgresql.util.PSQLException: 错误: 关系 "pwp_no" 不存在 158 位置:92 159 at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.postProcessPropertyValues(CommonAnnotationBeanPostProcessor.java:306) 160 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1106) 161 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517) 162 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456) 163 at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294) 164 at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225) 165 at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291) 166 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197) 167 at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.autowireResource(CommonAnnotationBeanPostProcessor.java:442) 168 at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.getResource(CommonAnnotationBeanPostProcessor.java:416) 169 at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor$ResourceElement.getResourceToInject(CommonAnnotationBeanPostProcessor.java:549) 170 at org.springframework.beans.factory.annotation.InjectionMetadata$InjectedElement.inject(InjectionMetadata.java:150) 171 at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:87) 172 at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.postProcessPropertyValues(CommonAnnotationBeanPostProcessor.java:303) 173 ... 80 more 174 Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'organizationRep': Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'defaultDao': Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sequence' defined in URL [jar:file:/H:/SoftCodes/GDFS2021/BaseFrame2021/target/fsb/WEB-INF/lib/pwp-core-2.0.1.20171009.18.jar!/conf/context.core.xml]: Invocation of init method failed; nested exception is java.lang.RuntimeException: org.postgresql.util.PSQLException: 错误: 关系 "pwp_no" 不存在 175 位置:92 176 at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.postProcessPropertyValues(CommonAnnotationBeanPostProcessor.java:306) 177 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1106) 178 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517) 179 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456) 180 at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294) 181 at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225) 182 at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291) 183 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197) 184 at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.autowireResource(CommonAnnotationBeanPostProcessor.java:442) 185 at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.getResource(CommonAnnotationBeanPostProcessor.java:416) 186 at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor$ResourceElement.getResourceToInject(CommonAnnotationBeanPostProcessor.java:549) 187 at org.springframework.beans.factory.annotation.InjectionMetadata$InjectedElement.inject(InjectionMetadata.java:150) 188 at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:87) 189 at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.postProcessPropertyValues(CommonAnnotationBeanPostProcessor.java:303) 190 ... 93 more 191 Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'defaultDao': Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sequence' defined in URL [jar:file:/H:/SoftCodes/GDFS2021/BaseFrame2021/target/fsb/WEB-INF/lib/pwp-core-2.0.1.20171009.18.jar!/conf/context.core.xml]: Invocation of init method failed; nested exception is java.lang.RuntimeException: org.postgresql.util.PSQLException: 错误: 关系 "pwp_no" 不存在 192 位置:92 193 at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.postProcessPropertyValues(CommonAnnotationBeanPostProcessor.java:306) 194 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1106) 195 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517) 196 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456) 197 at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294) 198 02-Nov-2021 09:49:00.121 严重 [RMI TCP Connection(5)-127.0.0.1] org.apache.catalina.core.StandardContext.startInternal One or more listeners failed to start. Full details will be found in the appropriate container log file 199 02-Nov-2021 09:49:00.122 严重 [RMI TCP Connection(5)-127.0.0.1] org.apache.catalina.core.StandardContext.startInternal Context [/fsb2021] startup failed due to previous errors 200 at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225) 201 at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291) 202 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197) 203 at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.autowireResource(CommonAnnotationBeanPostProcessor.java:442) 204 at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.getResource(CommonAnnotationBeanPostProcessor.java:416) 205 at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor$ResourceElement.getResourceToInject(CommonAnnotationBeanPostProcessor.java:549) 206 at org.springframework.beans.factory.annotation.InjectionMetadata$InjectedElement.inject(InjectionMetadata.java:150) 207 at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:87) 208 at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.postProcessPropertyValues(CommonAnnotationBeanPostProcessor.java:303) 209 ... 106 more 210 Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sequence' defined in URL [jar:file:/H:/SoftCodes/GDFS2021/BaseFrame2021/target/fsb/WEB-INF/lib/pwp-core-2.0.1.20171009.18.jar!/conf/context.core.xml]: Invocation of init method failed; nested exception is java.lang.RuntimeException: org.postgresql.util.PSQLException: 错误: 关系 "pwp_no" 不存在 211 位置:92 212 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1455) 213 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519) 214 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456) 215 at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294) 216 at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225) 217 at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291) 218 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197) 219 at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.autowireResource(CommonAnnotationBeanPostProcessor.java:442) 220 at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.getResource(CommonAnnotationBeanPostProcessor.java:416) 221 at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor$ResourceElement.getResourceToInject(CommonAnnotationBeanPostProcessor.java:549) 222 at org.springframework.beans.factory.annotation.InjectionMetadata$InjectedElement.inject(InjectionMetadata.java:150) 223 at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:87) 224 at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.postProcessPropertyValues(CommonAnnotationBeanPostProcessor.java:303) 225 ... 119 more 226 Caused by: java.lang.RuntimeException: org.postgresql.util.PSQLException: 错误: 关系 "pwp_no" 不存在 227 位置:92 228 at com.todaytech.pwp.core.no.SequenceDao.getAllNo(SequenceDao.java:81) 229 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 230 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) 231 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 232 at java.lang.reflect.Method.invoke(Method.java:498) 233 at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309) 234 at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:196) 235 at com.sun.proxy.$Proxy29.getAllNo(Unknown Source) 236 at com.todaytech.pwp.core.no.DefaultSequence.afterPropertiesSet(DefaultSequence.java:127) 237 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1514) 238 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1452) 239 ... 131 more 240 Caused by: org.postgresql.util.PSQLException: 错误: 关系 "pwp_no" 不存在 241 位置:92 242 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2433) 243 at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2178) 244 at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:306) 245 at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441) 246 at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365) 247 at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:155) 248 at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:118) 249 at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) 250 at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) 251 at com.todaytech.pwp.core.no.SequenceDao.getAllNo(SequenceDao.java:73) 252 ... 141 more 253 02-Nov-2021 09:49:00.197 警告 [RMI TCP Connection(5)-127.0.0.1] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesJdbc Web应用程序 [fsb2021] 注册了JDBC驱动程序 [org.postgresql.Driver],但在Web应用程序停止时无法注销它。 为防止内存泄漏,JDBC驱动程序已被强制取消注册。 254 [2021-11-02 09:49:00,248] Artifact fsb:war exploded: Error during artifact deployment. See server log for details. 255
2:问题分析
使用的是postgresql数据库,以往使用数据库是在XML文件中自己编写sql语句。会在表名上加入“”,这次使用了以往没有使用过的。网上找了好多。说是表名不能有大写。可就算改成是小写了也还是不行,一直报这个不存在的错误
找到了一个关于currentSchema 这个属性,但是自己也不知道这个怎么设置。学着网络上写的都不行,就慢慢的去试。总数给搞出来了。原来是表的模式名字
3:处理方案:
postgresql 数据库的表名是区分大小写的。
如果数据库表的表名是大写的,则在代码的sql里的数据名称也必须是大写的。反之则为小写。
PostgreSQL 大小写问题 一键修改表名、字段名为小写
标准的SQL是不区分大小写的。但是PostgreSQL对于数据库中对象的名字允许使用支持大小写区分的定义和引用方法。方式就是在DDL中用双引号把希望支持大小的对象名括起来。
比如希望创建一个叫AAA的表。如果用CREATE TABLE AAA (...);的话,创建出来的表实际上是aaa。
如果希望创建大写的AAA表的话,就需要用CREATE TABLE "AAA" (...);这种双引号的方式定义对象名。
这样写的缺点是查询语句必须也使用双引号的方式引用对象名。比如SELECT * FROM "AAA";否则PostgreSQL缺省会去找aaa这个对象,然后返回aaa不存在的错误。需要注意的是不仅仅是表可以这样定义和引用,对PostgreSQL中的任意对象(比如列名,索引名等)都有效。创建
exec(sqlstring)
函数方便执行1 CREATE OR REPLACE FUNCTION "public"."exec"("sqlstring" varchar) 2 RETURNS "pg_catalog"."varchar" AS $BODY$ 3 declare 4 res varchar(50); 5 BEGIN 6 EXECUTE sqlstring; 7 RETURN 'ok'; 8 END 9 $BODY$ 10 LANGUAGE plpgsql VOLATILE 11 COST 100
通过条件拼接SQL
1 -- 根据条件查询所有大写的column 2 select * from information_schema.columns where table_schema='public' and table_name<>'pg_stat_statements' and column_name <> lower(column_name); 3 4 -- 修改条件后,通过下列语句转换column_name中的大写字母 5 SELECT 6 exec('alter table "' || table_name || '" rename column "' || column_name || '" to ' || lower( column_name ) || ';') 7 FROM 8 information_schema.COLUMNS 9 WHERE 10 table_schema = 'public' 11 AND column_name <> lower(column_name) 12 AND table_name <> 'pg_stat_statements' 13 AND table_name = 'prescribe_state_copy1'; 14 15 -- 查询大写的table_name 16 SELECT * FROM information_schema.TABLES WHERE table_schema = 'public' AND table_catalog = 'Guns' AND table_name <> lower( table_name ); 17 18 -- 修改表名中的大写为小写 19 SELECT 20 exec ( 'alter table "' || table_name || '" rename to ' || lower( table_name ) || ';' ) 21 FROM 22 information_schema.tables 23 WHERE 24 table_schema='public' 25 and table_catalog = 'Guns' 26 and table_name <> lower(table_name);
变更数据库表的表名由大写改为小写的sql查询脚本:
1 SELECT 'alter table "public"."'|| t.tablename ||'"' ||' rename to "' || "lower"(t.tablename) ||'";' newRename ,t.*FROM pg_tables TWHERE T .schemaname = 'public';
如图: 先执行 生成 修改数据库表名的脚本:
然后把 查询出来的 修改数据库表名的脚本执行一次即可。
更改下连接字符串即可
1 useUnicode=true&characterEncoding=utf8¤tSchema=public&stringtype=unspecified
或者实体类加入
@TableName(autoResultMap = true, value = "machiningday",schema = "public")
学问:纸上得来终觉浅,绝知此事要躬行
为事:工欲善其事,必先利其器。
态度:道阻且长,行则将至;行而不辍,未来可期
.....................................................................
------- 桃之夭夭,灼灼其华。之子于归,宜其室家。 ---------------
------- 桃之夭夭,有蕡其实。之子于归,宜其家室。 ---------------
------- 桃之夭夭,其叶蓁蓁。之子于归,宜其家人。 ---------------
=====================================================================
* 博客文章部分截图及内容来自于学习的书本及相应培训课程以及网络其他博客,仅做学习讨论之用,不做商业用途。
* 如有侵权,马上联系我,我立马删除对应链接。 * @author Alan -liu * @Email no008@foxmail.com
转载请标注出处! ✧*꧁一品堂.技术学习笔记꧂*✧. ---> https://www.cnblogs.com/ios9/
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 一个奇形怪状的面试题:Bean中的CHM要不要加volatile?
· [.NET]调用本地 Deepseek 模型
· 一个费力不讨好的项目,让我损失了近一半的绩效!
· .NET Core 托管堆内存泄露/CPU异常的常见思路
· PostgreSQL 和 SQL Server 在统计信息维护中的关键差异
· DeepSeek “源神”启动!「GitHub 热点速览」
· 微软正式发布.NET 10 Preview 1:开启下一代开发框架新篇章
· C# 集成 DeepSeek 模型实现 AI 私有化(本地部署与 API 调用教程)
· DeepSeek R1 简明指南:架构、训练、本地部署及硬件要求
· 2 本地部署DeepSeek模型构建本地知识库+联网搜索详细步骤
2017-11-02 关闭VirtualBox虚拟机的时钟同步