From: | Thom Brown <thom(at)linux(dot)com> |
---|---|
To: | Karen Castillo <karen(dot)simplyme(at)gmail(dot)com> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: New table |
Date: | 2011-02-01 10:54:55 |
Message-ID: | AANLkTim53pGiEUndV_J4V4C-rW4dTsh0YfPA4qSgvn19@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On 1 February 2011 09:47, Karen Castillo <karen(dot)simplyme(at)gmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Oliveiros d'Azevedo Cristina | 2011-02-01 11:57:27 | Re: Help by query |
Previous Message | killspam killspam | 2011-02-01 10:14:03 | Help by query |