Skip site navigation (1) Skip section navigation (2)

Re: New table

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 (view raw or flat)
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

In response to

  • New table at 2011-02-01 09:47:14 from Karen Castillo

pgsql-novice by date

Next:From: Oliveiros d'Azevedo CristinaDate: 2011-02-01 11:57:27
Subject: Re: Help by query
Previous:From: killspam killspamDate: 2011-02-01 10:14:03
Subject: Help by query

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group