New table - Mailing list 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