New table

From: Karen Castillo <karen(dot)simplyme(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: New table
Date: 2011-02-01 09:47:14
Message-ID: AANLkTi=cYH_yTXyXxShoZvgC5vvCU7jCCLwTc8iOiTv-@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Please help.

Thanks!

KC

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message killspam killspam 2011-02-01 10:14:03 Help by query
Previous Message Christian Brennsteiner 2011-02-01 08:50:06 Re: handling concurrency right why am i wrong?