Spring Boot 切换mysql到postgres出错,不知道原因是啥

ti_technology 发布于 08/20 16:37
阅读 119
收藏 0

公司要把原来Spring boot的项目mysql的数据库换成postgres,然后我们把sql文件导了出来,用工具转换成了postgres的ddl语法,改了一下Spring boot的依赖和配置之后。一直出现column “id” does not exist的错误

 .   ____          _            __ _ _
 /\\ / ___'_ __ _ _(_)_ __  __ _ \ \ \ \
( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
 \\/  ___)| |_)| | | | | || (_| |  ) ) ) )
  '  |____| .__|_| |_|_| |_\__, | / / / /
 =========|_|==============|___/=/_/_/_/
 :: Spring Boot ::        (v2.1.1.RELEASE)

2019-08-20 16:35:39.038 [INFO ] [shintens-MacBook-Pro.local|main] (:) - Starting BibiApplication v0.0.1-SNAPSHOT on shintens-MacBook-Pro.local with PID 41877 (/Users/qintianqi/Documents/GitHub/waxis_bibi_backend_java/target/bibi-0.0.1-SNAPSHOT.jar started by qintianqi in /Users/qintianqi/Documents/GitHub/waxis_bibi_backend_java/target)
2019-08-20 16:35:39.039 [DEBUG] [shintens-MacBook-Pro.local|main] (:) - Running with Spring Boot v2.1.1.RELEASE, Spring v5.1.3.RELEASE
2019-08-20 16:35:39.041 [INFO ] [shintens-MacBook-Pro.local|main] (:) - No active profile set, falling back to default profiles: default
2019-08-20 16:35:41.069 [INFO ] [shintens-MacBook-Pro.local|main] (:) - Multiple Spring Data modules found, entering strict repository configuration mode!
2019-08-20 16:35:41.109 [INFO ] [shintens-MacBook-Pro.local|main] (:) - Bootstrapping Spring Data repositories in DEFAULT mode.
2019-08-20 16:35:41.235 [INFO ] [shintens-MacBook-Pro.local|main] (:) - Finished Spring Data repository scanning in 54ms. Found 0 repository interfaces.
2019-08-20 16:35:42.657 [INFO ] [shintens-MacBook-Pro.local|main] (:) - Bean 'org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration' of type [org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration$$EnhancerBySpringCGLIB$$6d14ae8d] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2019-08-20 16:35:43.815 [INFO ] [shintens-MacBook-Pro.local|main] (:) - Tomcat initialized with port(s): 8080 (http)
2019-08-20 16:35:43.890 [INFO ] [shintens-MacBook-Pro.local|main] (:) - Initializing ProtocolHandler ["http-nio-8080"]
2019-08-20 16:35:43.924 [INFO ] [shintens-MacBook-Pro.local|main] (:) - Starting service [Tomcat]
2019-08-20 16:35:43.926 [INFO ] [shintens-MacBook-Pro.local|main] (:) - Starting Servlet Engine: Apache Tomcat/9.0.13
2019-08-20 16:35:43.980 [INFO ] [shintens-MacBook-Pro.local|main] (:) - The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: [/Users/qintianqi/Library/Java/Extensions:/Library/Java/Extensions:/Network/Library/Java/Extensions:/System/Library/Java/Extensions:/usr/lib/java:.]
2019-08-20 16:35:44.223 [INFO ] [shintens-MacBook-Pro.local|main] (:) - Initializing Spring embedded WebApplicationContext
2019-08-20 16:35:44.224 [INFO ] [shintens-MacBook-Pro.local|main] (:) - Root WebApplicationContext: initialization completed in 5056 ms
2019-08-20 16:35:48.181 [INFO ] [shintens-MacBook-Pro.local|main] (:) - Redisson 3.8.2
2019-08-20 16:35:49.830 [INFO ] [shintens-MacBook-Pro.local|redisson-netty-1-6] (:) - 1 connections initialized for 127.0.0.1/127.0.0.1:6379
2019-08-20 16:35:49.839 [INFO ] [shintens-MacBook-Pro.local|redisson-netty-1-6] (:) - 32 connections initialized for 127.0.0.1/127.0.0.1:6379
2019-08-20 16:35:50.024 [INFO ] [shintens-MacBook-Pro.local|main] (:) - Initializing ExecutorService 'customThreadPoolExecutor'
2019-08-20 16:35:55.141 [WARN ] [shintens-MacBook-Pro.local|main] (:) - Cannot find template location(s): [classpath:/templates/] (please add some templates, check your FreeMarker configuration, or set spring.freemarker.checkTemplateLocation=false)
2019-08-20 16:35:55.438 [INFO ] [shintens-MacBook-Pro.local|main] (:) - Starting ProtocolHandler ["http-nio-8080"]
2019-08-20 16:35:55.449 [INFO ] [shintens-MacBook-Pro.local|main] (:) - Using a shared selector for servlet write/read
2019-08-20 16:35:55.528 [INFO ] [shintens-MacBook-Pro.local|main] (:) - Tomcat started on port(s): 8080 (http) with context path ''
2019-08-20 16:35:55.533 [INFO ] [shintens-MacBook-Pro.local|main] (:) - Started BibiApplication in 18.376 seconds (JVM running for 20.91)
2019-08-20 16:35:59.593 [INFO ] [shintens-MacBook-Pro.local|http-nio-8080-exec-1] (:) - Initializing Spring DispatcherServlet 'dispatcherServlet'
2019-08-20 16:35:59.594 [INFO ] [shintens-MacBook-Pro.local|http-nio-8080-exec-1] (:) - Initializing Servlet 'dispatcherServlet'
2019-08-20 16:35:59.730 [INFO ] [shintens-MacBook-Pro.local|http-nio-8080-exec-1] (:) - Completed initialization in 135 ms
2019-08-20 16:36:00.617 [INFO ] [shintens-MacBook-Pro.local|http-nio-8080-exec-3] (:) - request uri: /topic/queryTopicList/.
2019-08-20 16:36:00.617 [INFO ] [shintens-MacBook-Pro.local|http-nio-8080-exec-3] (:) - request body: {"pageNo":1,"pageSize":20,"sortFields":"attention_count DESC"}.
2019-08-20 16:36:00.618 [INFO ] [shintens-MacBook-Pro.local|http-nio-8080-exec-1] (:) - request uri: /message/queryUnreadMessageCount/.
2019-08-20 16:36:00.619 [INFO ] [shintens-MacBook-Pro.local|http-nio-8080-exec-1] (:) - request body: {}.
2019-08-20 16:36:00.630 [INFO ] [shintens-MacBook-Pro.local|http-nio-8080-exec-2] (:) - request uri: /user/login/.
2019-08-20 16:36:00.630 [INFO ] [shintens-MacBook-Pro.local|http-nio-8080-exec-2] (:) - request body: {"code":"011Bpvja0pBGIx1ai8ja0Mrfja0Bpvjl"}.
2019-08-20 16:36:00.703 [INFO ] [shintens-MacBook-Pro.local|http-nio-8080-exec-3] (:) - => sessionId is empty!
2019-08-20 16:36:00.714 [INFO ] [shintens-MacBook-Pro.local|http-nio-8080-exec-1] (:) - => sessionId is empty!
2019-08-20 16:36:01.454 [INFO ] [shintens-MacBook-Pro.local|http-nio-8080-exec-2] (:) - {dataSource-1} inited
null--->[HTTP/1.1 200 OK]
Connection--->[keep-alive]
Content-Length--->[82]
Date--->[Tue, 20 Aug 2019 08:36:02 GMT]
Content-Type--->[text/plain]
2019-08-20 16:36:02.303 [DEBUG] [shintens-MacBook-Pro.local|http-nio-8080-exec-2] (:) - JDBC Connection [org.postgresql.jdbc.PgConnection@448f699c] will be managed by Spring
2019-08-20 16:36:02.336 [DEBUG] [shintens-MacBook-Pro.local|http-nio-8080-exec-2] (:) - ==>  Preparing: SELECT id AS id, name AS name, gender AS gender, head_image_path AS head_image_path, head_image_url AS head_image_url, wechat AS wechat, phone AS phone, type AS type, enabled AS enabled, openid AS openid, email AS email FROM user WHERE openid = ? 
2019-08-20 16:36:02.380 [DEBUG] [shintens-MacBook-Pro.local|http-nio-8080-exec-2] (:) - ==> Parameters: ot1Dm5Y8sg2nQ9gquKlbHHAfJE0U(String)
2019-08-20 16:36:02.531 [ERROR] [shintens-MacBook-Pro.local|http-nio-8080-exec-2] (:) - 应用服务器异常,请联系系统管理员!
org.springframework.jdbc.BadSqlGrammarException: 
### Error querying database.  Cause: org.postgresql.util.PSQLException: ERROR: column "id" does not exist
  位置:23
### The error may exist in URL [jar:file:/Users/qintianqi/Documents/GitHub/waxis_bibi_backend_java/target/bibi-0.0.1-SNAPSHOT.jar!/BOOT-INF/classes!/mapper/UserMapper.xml]
### The error may involve com.shichengbibi.bibi.dao.IUserDao.queryUserInfo-Inline
### The error occurred while setting parameters
### SQL: SELECT                id AS id, name AS name, gender AS gender, head_image_path AS head_image_path, head_image_url AS head_image_url, wechat AS wechat, phone AS phone, type AS type, enabled AS enabled, openid AS openid, email AS email                   FROM user              WHERE openid = ?
### Cause: org.postgresql.util.PSQLException: ERROR: column "id" does not exist
  位置:23
; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: column "id" does not exist
  位置:23
        at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101) ~[spring-jdbc-5.1.3.RELEASE.jar!/:5.1.3.RELEASE]
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) ~[spring-jdbc-5.1.3.RELEASE.jar!/:5.1.3.RELEASE]
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) ~[spring-jdbc-5.1.3.RELEASE.jar!/:5.1.3.RELEASE]
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) ~[spring-jdbc-5.1.3.RELEASE.jar!/:5.1.3.RELEASE]
        at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73) ~[mybatis-spring-1.3.2.jar!/:1.3.2]
        at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446) ~[mybatis-spring-1.3.2.jar!/:1.3.2]
        at com.sun.proxy.$Proxy84.selectOne(Unknown Source) ~[?:?]
        at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:166) ~[mybatis-spring-1.3.2.jar!/:1.3.2]
        at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:83) ~[mybatis-3.4.6.jar!/:3.4.6]
        at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59) ~[mybatis-3.4.6.jar!/:3.4.6]
        at com.sun.proxy.$Proxy106.queryUserInfo(Unknown Source) ~[?:?]
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_221]
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_221]
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_221]
        at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_221]
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343) ~[spring-aop-5.1.3.RELEASE.jar!/:5.1.3.RELEASE]
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198) ~[spring-aop-5.1.3.RELEASE.jar!/:5.1.3.RELEASE]
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-5.1.3.RELEASE.jar!/:5.1.3.RELEASE]
        at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:139) ~[spring-tx-5.1.3.RELEASE.jar!/:5.1.3.RELEASE]
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.1.3.RELEASE.jar!/:5.1.3.RELEASE]
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212) ~[spring-aop-5.1.3.RELEASE.jar!/:5.1.3.RELEASE]
        at com.sun.proxy.$Proxy107.queryUserInfo(Unknown Source) ~[?:?]
        at com.shichengbibi.bibi.service.impl.UserServiceImpl.login(UserServiceImpl.java:194) ~[classes!/:0.0.1-SNAPSHOT]
        at com.shichengbibi.bibi.service.impl.UserServiceImpl$$FastClassBySpringCGLIB$$f9f75c7.invoke(<generated>) ~[classes!/:0.0.1-SNAPSHOT]
        at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) ~[spring-core-5.1.3.RELEASE.jar!/:5.1.3.RELEASE]
        at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:749) ~[spring-aop-5.1.3.RELEASE.jar!/:5.1.3.RELEASE]
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-5.1.3.RELEASE.jar!/:5.1.3.RELEASE]
        at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:294) ~[spring-tx-5.1.3.RELEASE.jar!/:5.1.3.RELEASE]
        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98) ~[spring-tx-5.1.3.RELEASE.jar!/:5.1.3.RELEASE]
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.1.3.RELEASE.jar!/:5.1.3.RELEASE]
        at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688) ~[spring-aop-5.1.3.RELEASE.jar!/:5.1.3.RELEASE]
        at com.shichengbibi.bibi.service.impl.UserServiceImpl$$EnhancerBySpringCGLIB$$770f4284.login(<generated>) ~[classes!/:0.0.1-SNAPSHOT]
        at com.shichengbibi.bibi.webapi.UserController.login(UserController.java:50) ~[classes!/:0.0.1-SNAPSHOT]
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_221]
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_221]
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_221]
        at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_221]
        at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:189) ~[spring-web-5.1.3.RELEASE.jar!/:5.1.3.RELEASE]
        at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138) ~[spring-web-5.1.3.RELEASE.jar!/:5.1.3.RELEASE]
        at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102) ~[spring-webmvc-5.1.3.RELEASE.jar!/:5.1.3.RELEASE]
        at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895) ~[spring-webmvc-5.1.3.RELEASE.jar!/:5.1.3.RELEASE]
        at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:800) ~[spring-webmvc-5.1.3.RELEASE.jar!/:5.1.3.RELEASE]
        at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) ~[spring-webmvc-5.1.3.RELEASE.jar!/:5.1.3.RELEASE]
        at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1038) ~[spring-webmvc-5.1.3.RELEASE.jar!/:5.1.3.RELEASE]
        at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942) ~[spring-webmvc-5.1.3.RELEASE.jar!/:5.1.3.RELEASE]
        at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1005) ~[spring-webmvc-5.1.3.RELEASE.jar!/:5.1.3.RELEASE]
        at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:908) ~[spring-webmvc-5.1.3.RELEASE.jar!/:5.1.3.RELEASE]
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:660) ~[tomcat-embed-core-9.0.13.jar!/:9.0.13]
        at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:882) ~[spring-webmvc-5.1.3.RELEASE.jar!/:5.1.3.RELEASE]
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) ~[tomcat-embed-core-9.0.13.jar!/:9.0.13]
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) ~[tomcat-embed-core-9.0.13.jar!/:9.0.13]
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.13.jar!/:9.0.13]
        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) ~[tomcat-embed-websocket-9.0.13.jar!/:9.0.13]
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.13.jar!/:9.0.13]
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.13.jar!/:9.0.13]
        at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99) ~[spring-web-5.1.3.RELEASE.jar!/:5.1.3.RELEASE]
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) ~[spring-web-5.1.3.RELEASE.jar!/:5.1.3.RELEASE]
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.13.jar!/:9.0.13]
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.13.jar!/:9.0.13]
        at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:92) ~[spring-web-5.1.3.RELEASE.jar!/:5.1.3.RELEASE]
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) ~[spring-web-5.1.3.RELEASE.jar!/:5.1.3.RELEASE]
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.13.jar!/:9.0.13]
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.13.jar!/:9.0.13]
        at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93) ~[spring-web-5.1.3.RELEASE.jar!/:5.1.3.RELEASE]
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) ~[spring-web-5.1.3.RELEASE.jar!/:5.1.3.RELEASE]
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.13.jar!/:9.0.13]
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.13.jar!/:9.0.13]
        at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200) ~[spring-web-5.1.3.RELEASE.jar!/:5.1.3.RELEASE]
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) ~[spring-web-5.1.3.RELEASE.jar!/:5.1.3.RELEASE]
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.13.jar!/:9.0.13]
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.13.jar!/:9.0.13]
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) ~[tomcat-embed-core-9.0.13.jar!/:9.0.13]
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) ~[tomcat-embed-core-9.0.13.jar!/:9.0.13]
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) ~[tomcat-embed-core-9.0.13.jar!/:9.0.13]
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) ~[tomcat-embed-core-9.0.13.jar!/:9.0.13]
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) ~[tomcat-embed-core-9.0.13.jar!/:9.0.13]
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) ~[tomcat-embed-core-9.0.13.jar!/:9.0.13]
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) ~[tomcat-embed-core-9.0.13.jar!/:9.0.13]
        at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408) ~[tomcat-embed-core-9.0.13.jar!/:9.0.13]
        at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) ~[tomcat-embed-core-9.0.13.jar!/:9.0.13]
        at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:791) ~[tomcat-embed-core-9.0.13.jar!/:9.0.13]
        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1417) ~[tomcat-embed-core-9.0.13.jar!/:9.0.13]
        at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) ~[tomcat-embed-core-9.0.13.jar!/:9.0.13]
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_221]
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_221]
        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) ~[tomcat-embed-core-9.0.13.jar!/:9.0.13]
        at java.lang.Thread.run(Thread.java:748) [?:1.8.0_221]
Caused by: org.postgresql.util.PSQLException: ERROR: column "id" does not exist
  位置:23
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440) ~[postgresql-42.2.5.jar!/:42.2.5]
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183) ~[postgresql-42.2.5.jar!/:42.2.5]
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308) ~[postgresql-42.2.5.jar!/:42.2.5]
        at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441) ~[postgresql-42.2.5.jar!/:42.2.5]
        at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365) ~[postgresql-42.2.5.jar!/:42.2.5]
        at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:143) ~[postgresql-42.2.5.jar!/:42.2.5]
        at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:132) ~[postgresql-42.2.5.jar!/:42.2.5]
        at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:498) ~[druid-1.1.8.jar!/:1.1.8]
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_221]
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_221]
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_221]
        at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_221]
        at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59) ~[mybatis-3.4.6.jar!/:3.4.6]
        at com.sun.proxy.$Proxy126.execute(Unknown Source) ~[?:?]
        at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:63) ~[mybatis-3.4.6.jar!/:3.4.6]
        at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79) ~[mybatis-3.4.6.jar!/:3.4.6]
        at org.apache.ibatis.executor.ReuseExecutor.doQuery(ReuseExecutor.java:60) ~[mybatis-3.4.6.jar!/:3.4.6]
        at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:326) ~[mybatis-3.4.6.jar!/:3.4.6]
        at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) ~[mybatis-3.4.6.jar!/:3.4.6]
        at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109) ~[mybatis-3.4.6.jar!/:3.4.6]
        at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83) ~[mybatis-3.4.6.jar!/:3.4.6]
        at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148) ~[mybatis-3.4.6.jar!/:3.4.6]
        at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141) ~[mybatis-3.4.6.jar!/:3.4.6]
        at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:77) ~[mybatis-3.4.6.jar!/:3.4.6]
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_221]
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_221]
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_221]
        at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_221]
        at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433) ~[mybatis-spring-1.3.2.jar!/:1.3.2]
        ... 81 more

 

加载中
返回顶部
顶部