ERROR: relation "public.userinfo" does not exist

概述解决c3p0 pool 找不到 Postsql的表的问题。 建表的时候注意需要赋予相应的用户权限。 ALTER TABLE "userInfo" OWNER TO sa;GRANT ALL ON TABLE "userInfo" TO sa;GRANT ALL ON TABLE "userInfo" TO public; Initializing c3p0 pool... com.mcha

解决c3p0 pool 找不到 postsql的表的问题。

建表的时候注意需要赋予相应的用户权限。

ALTER table "userInfo"  OWNER TO sa;GRANT ALL ON table "userInfo" TO sa;GRANT ALL ON table "userInfo" TO public;

Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource@1571dff [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@10848b9 [ acquireIncrement -> 1,acquireRetryAttempts -> 30,acquireRetryDelay -> 1000,autoCommitOnClose -> false,automaticTesttable -> null,breakAfteracquireFailure -> false,checkoutTimeout -> 0,connectionTesterClassname -> com.mchange.v2.c3p0.impl.DefaultConnectionTester,factoryClassLocation -> null,forceIgnoreUnresolvedTransactions -> false,IDleConnectionTestPeriod -> 120,initialPoolSize -> 5,maxIDleTime -> 0,maxPoolSize -> 30,maxStatements -> 50,maxStatementsPerConnection -> 0,minPoolSize -> 5,nestedDataSource -> com.mchange.v2.c3p0.DriverManagerDataSource@104cf67 [ description -> null,driverClass -> null,jdbcUrl -> jdbc:postgresql://192.168.1.128:5432/sencloudMM,propertIEs -> {user=******,password=******} ],preferredTestquery -> null,propertyCycle -> 300,testConnectionOnCheckin -> false,testConnectionOnCheckout -> false,usesTraditionalReflectiveProxIEs -> false ],numHelperThreads -> 3,poolOwnerIDentityToken -> 1571dff ]

com.mchange.v2.c3p0.impl.NewPooledConnection@1c330aa invalIDated by Exception: org.postgresql.util.PsqlException: ERROR: relation "public.userinfo" does not exist 位置：51 at org.postgresql.core.v3.queryExecutorImpl.receiveErrorResponse(queryExecutorImpl.java:2101) at org.postgresql.core.v3.queryExecutorImpl.processResults(queryExecutorImpl.java:1834) at org.postgresql.core.v3.queryExecutorImpl.execute(queryExecutorImpl.java:255) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:510) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:386) at org.postgresql.jdbc2.AbstractJdbc2Statement.executequery(AbstractJdbc2Statement.java:271) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executequery(NewProxyPreparedStatement.java:75) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208) at org.hibernate.loader.Loader.getResultSet(Loader.java:1812) at org.hibernate.loader.Loader.doquery(Loader.java:697) at org.hibernate.loader.Loader.doqueryAndInitialiZenonLazyCollections(Loader.java:259) at org.hibernate.loader.Loader.doList(Loader.java:2232) at org.hibernate.loader.Loader.ListIgnorequeryCache(Loader.java:2129) at org.hibernate.loader.Loader.List(Loader.java:2124) at org.hibernate.loader.hql.queryLoader.List(queryLoader.java:401) at org.hibernate.hql.ast.queryTranslatorImpl.List(queryTranslatorImpl.java:363) at org.hibernate.engine.query.HQLqueryPlan.performList(HQLqueryPlan.java:196) at org.hibernate.impl.SessionImpl.List(SessionImpl.java:1149) at org.hibernate.impl.queryImpl.List(queryImpl.java:102) at org.hibernate.impl.AbstractqueryImpl.uniqueResult(AbstractqueryImpl.java:835) at com.sencloud.mm.dao.hibimpl.UserInfoDaoImpl.checkUserInfoIsExistByLoginID(UserInfoDaoImpl.java:62) at com.sencloud.mm.action.LoginAction.checkLoginIdisExist(LoginAction.java:273) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(UnkNown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(UnkNown Source) at java.lang.reflect.Method.invoke(UnkNown Source) at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:441) at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:280) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:243) at com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:165) at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) at com.opensymphony.xwork2.valIDator.ValIDationInterceptor.doIntercept(ValIDationInterceptor.java:252) at org.apache.struts2.interceptor.valIDation.AnnotationValIDationInterceptor.doIntercept(AnnotationValIDationInterceptor.java:68) at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) at com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:122) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195) at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195) at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:179) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) at org.apache.struts2.interceptor.MultiselectInterceptor.intercept(MultiselectInterceptor.java:75) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) at org.apache.struts2.interceptor.CheckBoxInterceptor.intercept(CheckBoxInterceptor.java:94) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) at org.apache.struts2.interceptor.fileUploadInterceptor.intercept(fileUploadInterceptor.java:235) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) at com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:89) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) at com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:130) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) at org.apache.struts2.interceptor.deBUGging.DeBUGgingInterceptor.intercept(DeBUGgingInterceptor.java:267) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) at com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:126) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) at com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:138) at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) at com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:165) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) at org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) at com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:179) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) at com.opensymphony.xwork2.interceptor.ExceptionMapPingInterceptor.intercept(ExceptionMapPingInterceptor.java:176) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237) at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52) at org.apache.struts2.dispatcher.dispatcher.serviceAction(dispatcher.java:488) at org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77) at org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:91) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandarDWrapperValve.invoke(StandarDWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.coyote.http11.http11Processor.process(http11Processor.java:859) at org.apache.coyote.http11.http11Protocol$http11ConnectionHandler.process(http11Protocol.java:602) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(UnkNown Source) CONNECTION ERROR OCCURRED! 总结

以上是内存溢出为你收集整理的ERROR: relation "public.userinfo" does not exist全部内容，希望文章能够帮你解决ERROR: relation "public.userinfo" does not exist所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。