Re: New table - Mailing list pgsql-novice
From | Thom Brown |
---|---|
Subject | Re: New table |
Date | |
Msg-id | AANLkTim53pGiEUndV_J4V4C-rW4dTsh0YfPA4qSgvn19@mail.gmail.com Whole thread Raw |
In response to | New table (Karen Castillo <karen.simplyme@gmail.com>) |
List | pgsql-novice |
On 1 February 2011 09:47, Karen Castillo <karen.simplyme@gmail.com> wrote: > I have added a new table idc_log to my cdrdb database. I have used the same > user to create the table and can execute queries successfully from the > postgreSQL client tool. But when I execute a select from the webapp, i get > the following error: > > 01-feb-2011 10:39:02 DEBUG > [es.tid.slee.idc.webconsole.actions.extensionStatistic.IDCListExtensionStatisticsAction] > - Statement is closed > 01-feb-2011 10:39:02 DEBUG > [es.tid.slee.idc.webconsole.actions.extensionStatistic.IDCListExtensionStatisticsAction] > - Connection is closed: true > 01-feb-2011 10:39:02 DEBUG > [es.tid.slee.idc.webconsole.actions.extensionStatistic.IDCListExtensionStatisticsAction] > - SQL query: SELECT log0.extension as extension, log1.success as success, > count(log0.extension) as total FROM idc_log log0 LEFT OUTER JOIN > (SELECT extension, count(result) as success FROM idc_log WHERE (result IN > (0,1,2,5) OR (result = 4 AND statusCode IN (13,55))) GROUP BY extension) > log1 ON (log0.extension = log1.extension) GROUP BY log0.extension, > log1.success ORDER BY total DESC > 01-feb-2011 10:39:02 ERROR > [es.tid.slee.idc.webconsole.actions.extensionStatistic.IDCListExtensionStatisticsAction] > - Error al generating result list > org.postgresql.util.PSQLException: ERROR: relation "idc_log" does not exist > at > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548) > at > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316) > at > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191) > at > org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452) > at > org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351) > at > org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:255) > at > weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:100) > at > es.tid.slee.idc.webconsole.actions.extensionStatistic.IDCListExtensionStatisticsAction.execute(Unknown > Source) > at > org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425) > at > org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228) > at > org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913) > at > org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:763) > at > es.tid.slee.plataforma.webconsole.ActionServletSignOn.service(Unknown > Source) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) > at > weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:225) > at > weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:127) > at > weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:283) > at > weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:175) > at > weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3214) > at > weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321) > at > weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121) > at > weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:1983) > at > weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:1890) > at > weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1344) > at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209) > at weblogic.work.ExecuteThread.run(ExecuteThread.java:181) > 01-feb-2011 10:39:02 DEBUG > [es.tid.slee.idc.webconsole.actions.extensionStatistic.IDCListExtensionStatisticsAction] > - Statement is closed > 01-feb-2011 10:39:02 DEBUG > [es.tid.slee.idc.webconsole.actions.extensionStatistic.IDCListExtensionStatisticsAction] > - Connection is closed: true Are you sure your web app is connecting to the correct database? -- Thom Brown Twitter: @darkixion IRC (freenode): dark_ixion Registered Linux user: #516935
pgsql-novice by date: