2006-09-11 16:56:46,564 DEBUG [SurveillanceView Builder] com.mchange.v2.c3p0.impl.NewPooledConnection: com.mchange.v2.c3p0.impl.NewPooledConnection@ceb175 handling a throwable.
org.postgresql.util.PSQLException: ERROR: relation "categories" does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:258)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1669)
at org.hibernate.loader.Loader.doQuery(Loader.java:662)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.doList(Loader.java:2145)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
at org.hibernate.loader.Loader.list(Loader.java:2024)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:392)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:333)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1114)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:756)
at org.opennms.netmgt.dao.hibernate.AbstractDaoHibernate$3.doInHibernate(AbstractDaoHibernate.java:125)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:366)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:334)
at org.opennms.netmgt.dao.hibernate.AbstractDaoHibernate.findUnique(AbstractDaoHibernate.java:129)
at org.opennms.netmgt.dao.hibernate.CategoryDaoHibernate.findByName(CategoryDaoHibernate.java:14)
at org.opennms.web.svclayer.support.DefaultSurveillanceService.createCategoryNameCollection(DefaultSurveillanceService.java:202)
at org.opennms.web.svclayer.support.DefaultSurveillanceService.createCategories(DefaultSurveillanceService.java:188)
at org.opennms.web.svclayer.support.DefaultSurveillanceService.createNodes(DefaultSurveillanceService.java:161)
at org.opennms.web.svclayer.support.DefaultSurveillanceService.createSurveillanceTable(DefaultSurveillanceService.java:112)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:288)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:181)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:148)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:100)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176)
at $Proxy24.createSurveillanceTable(Unknown Source)
at org.opennms.web.controller.SurveillanceViewController$1.run(SurveillanceViewController.java:96)
2006-09-11 16:56:46,566 DEBUG [SurveillanceView Builder] com.mchange.v2.sql.SqlUtils: Attempted to convert SQLException to SQLException. Leaving it alone. [SQLState: 42P01; errorCode: 0]
org.postgresql.util.PSQLException: ERROR: relation "categories" does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:258)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1669)
at org.hibernate.loader.Loader.doQuery(Loader.java:662)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.doList(Loader.java:2145)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
at org.hibernate.loader.Loader.list(Loader.java:2024)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:392)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:333)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1114)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:756)
at org.opennms.netmgt.dao.hibernate.AbstractDaoHibernate$3.doInHibernate(AbstractDaoHibernate.java:125)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:366)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:334)
at org.opennms.netmgt.dao.hibernate.AbstractDaoHibernate.findUnique(AbstractDaoHibernate.java:129)
at org.opennms.netmgt.dao.hibernate.CategoryDaoHibernate.findByName(CategoryDaoHibernate.java:14)
at org.opennms.web.svclayer.support.DefaultSurveillanceService.createCategoryNameCollection(DefaultSurveillanceService.java:202)
at org.opennms.web.svclayer.support.DefaultSurveillanceService.createCategories(DefaultSurveillanceService.java:188)
at org.opennms.web.svclayer.support.DefaultSurveillanceService.createNodes(DefaultSurveillanceService.java:161)
at org.opennms.web.svclayer.support.DefaultSurveillanceService.createSurveillanceTable(DefaultSurveillanceService.java:112)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:288)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:181)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:148)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:100)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176)
at $Proxy24.createSurveillanceTable(Unknown Source)
at org.opennms.web.controller.SurveillanceViewController$1.run(SurveillanceViewController.java:96)
2006-09-11 16:56:46,566 DEBUG [SurveillanceView Builder] com.mchange.v2.c3p0.impl.DefaultConnectionTester: Testing a Connection in response to an Exception:
org.postgresql.util.PSQLException: ERROR: relation "categories" does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:258)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1669)
at org.hibernate.loader.Loader.doQuery(Loader.java:662)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.doList(Loader.java:2145)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
at org.hibernate.loader.Loader.list(Loader.java:2024)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:392)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:333)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1114)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:756)
at org.opennms.netmgt.dao.hibernate.AbstractDaoHibernate$3.doInHibernate(AbstractDaoHibernate.java:125)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:366)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:334)
at org.opennms.netmgt.dao.hibernate.AbstractDaoHibernate.findUnique(AbstractDaoHibernate.java:129)
at org.opennms.netmgt.dao.hibernate.CategoryDaoHibernate.findByName(CategoryDaoHibernate.java:14)
at org.opennms.web.svclayer.support.DefaultSurveillanceService.createCategoryNameCollection(DefaultSurveillanceService.java:202)
at org.opennms.web.svclayer.support.DefaultSurveillanceService.createCategories(DefaultSurveillanceService.java:188)
at org.opennms.web.svclayer.support.DefaultSurveillanceService.createNodes(DefaultSurveillanceService.java:161)
at org.opennms.web.svclayer.support.DefaultSurveillanceService.createSurveillanceTable(DefaultSurveillanceService.java:112)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:288)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:181)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:148)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:100)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176)
at $Proxy24.createSurveillanceTable(Unknown Source)
at org.opennms.web.controller.SurveillanceViewController$1.run(SurveillanceViewController.java:96)
2006-09-11 16:56:46,576 DEBUG [SurveillanceView Builder] com.mchange.v2.c3p0.impl.DefaultConnectionTester: Connection org.postgresql.jdbc3.Jdbc3Connection@1ddadc failed default system-table Connection test with an Exception!
org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:340)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:239)
at org.postgresql.jdbc2.AbstractJdbc2DatabaseMetaData.getTables(AbstractJdbc2DatabaseMetaData.java:2183)
at com.mchange.v2.c3p0.impl.DefaultConnectionTester.activeCheckConnection(DefaultConnectionTester.java:104)
at com.mchange.v2.c3p0.impl.DefaultConnectionTester.statusOnException(DefaultConnectionTester.java:77)
at com.mchange.v2.c3p0.impl.DefaultConnectionTester.statusOnException(DefaultConnectionTester.java:56)
at com.mchange.v2.c3p0.impl.NewPooledConnection.handleThrowable(NewPooledConnection.java:261)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:93)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1669)
at org.hibernate.loader.Loader.doQuery(Loader.java:662)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.doList(Loader.java:2145)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
at org.hibernate.loader.Loader.list(Loader.java:2024)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:392)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:333)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1114)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:756)
at org.opennms.netmgt.dao.hibernate.AbstractDaoHibernate$3.doInHibernate(AbstractDaoHibernate.java:125)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:366)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:334)
at org.opennms.netmgt.dao.hibernate.AbstractDaoHibernate.findUnique(AbstractDaoHibernate.java:129)
at org.opennms.netmgt.dao.hibernate.CategoryDaoHibernate.findByName(CategoryDaoHibernate.java:14)
at org.opennms.web.svclayer.support.DefaultSurveillanceService.createCategoryNameCollection(DefaultSurveillanceService.java:202)
at org.opennms.web.svclayer.support.DefaultSurveillanceService.createCategories(DefaultSurveillanceService.java:188)
at org.opennms.web.svclayer.support.DefaultSurveillanceService.createNodes(DefaultSurveillanceService.java:161)
at org.opennms.web.svclayer.support.DefaultSurveillanceService.createSurveillanceTable(DefaultSurveillanceService.java:112)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:288)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:181)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:148)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:100)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176)
at $Proxy24.createSurveillanceTable(Unknown Source)
at org.opennms.web.controller.SurveillanceViewController$1.run(SurveillanceViewController.java:96)
2006-09-11 16:56:46,578 DEBUG [SurveillanceView Builder] com.mchange.v2.c3p0.impl.NewPooledConnection: com.mchange.v2.c3p0.impl.NewPooledConnection@ceb175 invalidated by Exception.
org.postgresql.util.PSQLException: ERROR: relation "categories" does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:258)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1669)
at org.hibernate.loader.Loader.doQuery(Loader.java:662)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.doList(Loader.java:2145)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
at org.hibernate.loader.Loader.list(Loader.java:2024)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:392)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:333)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1114)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:756)
at org.opennms.netmgt.dao.hibernate.AbstractDaoHibernate$3.doInHibernate(AbstractDaoHibernate.java:125)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:366)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:334)
at org.opennms.netmgt.dao.hibernate.AbstractDaoHibernate.findUnique(AbstractDaoHibernate.java:129)
at org.opennms.netmgt.dao.hibernate.CategoryDaoHibernate.findByName(CategoryDaoHibernate.java:14)
at org.opennms.web.svclayer.support.DefaultSurveillanceService.createCategoryNameCollection(DefaultSurveillanceService.java:202)
at org.opennms.web.svclayer.support.DefaultSurveillanceService.createCategories(DefaultSurveillanceService.java:188)
at org.opennms.web.svclayer.support.DefaultSurveillanceService.createNodes(DefaultSurveillanceService.java:161)
at org.opennms.web.svclayer.support.DefaultSurveillanceService.createSurveillanceTable(DefaultSurveillanceService.java:112)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:288)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:181)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:148)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:100)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176)
at $Proxy24.createSurveillanceTable(Unknown Source)
at org.opennms.web.controller.SurveillanceViewController$1.run(SurveillanceViewController.java:96)
2006-09-11 16:56:46,580 DEBUG [SurveillanceView Builder] com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool: CONNECTION ERROR OCCURRED!
2006-09-11 16:56:46,582 DEBUG [SurveillanceView Builder] com.mchange.v2.resourcepool.BasicResourcePool: Resource com.mchange.v2.c3p0.impl.NewPooledConnection@ceb175 marked broken by pool (com.mchange.v2.resourcepool.BasicResourcePool@404564).
2006-09-11 16:56:46,582 DEBUG [SurveillanceView Builder] org.hibernate.jdbc.AbstractBatcher: about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
2006-09-11 16:56:46,582 DEBUG [SurveillanceView Builder] org.hibernate.jdbc.AbstractBatcher: closing statement
2006-09-11 16:56:46,584 DEBUG [SurveillanceView Builder] org.hibernate.util.JDBCExceptionReporter: could not execute query [select onmscatego0_.categoryid as categoryid6_, onmscatego0_.categoryName as category2_6_, onmscatego0_.categoryDescription as category3_6_ from categories onmscatego0_ where onmscatego0_.categoryName=?]
org.postgresql.util.PSQLException: ERROR: relation "categories" does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:258)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1669)
at org.hibernate.loader.Loader.doQuery(Loader.java:662)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.doList(Loader.java:2145)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
at org.hibernate.loader.Loader.list(Loader.java:2024)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:392)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:333)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1114)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:756)
at org.opennms.netmgt.dao.hibernate.AbstractDaoHibernate$3.doInHibernate(AbstractDaoHibernate.java:125)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:366)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:334)
at org.opennms.netmgt.dao.hibernate.AbstractDaoHibernate.findUnique(AbstractDaoHibernate.java:129)
at org.opennms.netmgt.dao.hibernate.CategoryDaoHibernate.findByName(CategoryDaoHibernate.java:14)
at org.opennms.web.svclayer.support.DefaultSurveillanceService.createCategoryNameCollection(DefaultSurveillanceService.java:202)
at org.opennms.web.svclayer.support.DefaultSurveillanceService.createCategories(DefaultSurveillanceService.java:188)
at org.opennms.web.svclayer.support.DefaultSurveillanceService.createNodes(DefaultSurveillanceService.java:161)
at org.opennms.web.svclayer.support.DefaultSurveillanceService.createSurveillanceTable(DefaultSurveillanceService.java:112)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:288)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:181)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:148)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:100)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176)
at $Proxy24.createSurveillanceTable(Unknown Source)
at org.opennms.web.controller.SurveillanceViewController$1.run(SurveillanceViewController.java:96)
2006-09-11 16:56:46,585 WARN [SurveillanceView Builder] org.hibernate.util.JDBCExceptionReporter: SQL Error: 0, SQLState: 42P01
2006-09-11 16:56:46,585 ERROR [SurveillanceView Builder] org.hibernate.util.JDBCExceptionReporter: ERROR: relation "categories" does not exist
2006-09-11 16:56:46,585 DEBUG [SurveillanceView Builder] org.hibernate.transaction.JDBCTransaction: rollback
2006-09-11 16:56:46,589 DEBUG [SurveillanceView Builder] org.hibernate.transaction.JDBCTransaction: re-enabling autocommit
2006-09-11 16:56:46,589 DEBUG [SurveillanceView Builder] org.hibernate.transaction.JDBCTransaction: rolled back JDBC Connection
2006-09-11 16:56:46,589 DEBUG [SurveillanceView Builder] org.hibernate.jdbc.JDBCContext: after transaction completion
2006-09-11 16:56:46,589 DEBUG [SurveillanceView Builder] org.hibernate.jdbc.ConnectionManager: transaction completed on session with on_close connection release mode; be sure to close the session to release JDBC resources!
2006-09-11 16:56:46,589 DEBUG [SurveillanceView Builder] org.hibernate.impl.SessionImpl: after transaction completion
2006-09-11 16:56:46,605 DEBUG [SurveillanceView Builder] org.hibernate.impl.SessionImpl: closing session
2006-09-11 16:56:46,606 DEBUG [SurveillanceView Builder] org.hibernate.jdbc.ConnectionManager: performing cleanup
2006-09-11 16:56:46,606 DEBUG [SurveillanceView Builder] org.hibernate.jdbc.ConnectionManager: releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
2006-09-11 16:56:46,622 DEBUG [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2] com.mchange.v2.resourcepool.BasicResourcePool: trace com.mchange.v2.resourcepool.BasicResourcePool@404564 [managed: 3, unused: 3, excluded: 1] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@34b721)
2006-09-11 16:56:46,623 DEBUG [SurveillanceView Builder] com.mchange.v2.resourcepool.BasicResourcePool: trace com.mchange.v2.resourcepool.BasicResourcePool@404564 [managed: 3, unused: 3, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@34b721)
2006-09-11 16:56:46,623 DEBUG [SurveillanceView Builder] org.hibernate.jdbc.JDBCContext: after transaction completion
2006-09-11 16:56:46,623 DEBUG [SurveillanceView Builder] org.hibernate.jdbc.ConnectionManager: transaction completed on session with on_close connection release mode; be sure to close the session to release JDBC resources!
2006-09-11 16:56:46,623 DEBUG [SurveillanceView Builder] org.hibernate.impl.SessionImpl: after transaction completion
2006-09-11 16:56:46,773 DEBUG [http-8080-Processor23] org.apache.jasper.servlet.JspServlet: JspEngine --> /test/testProgressBar.jsp
2006-09-11 16:56:46,773 DEBUG [http-8080-Processor23] org.apache.jasper.servlet.JspServlet: ServletPath: /test/testProgressBar.jsp
2006-09-11 16:56:46,773 DEBUG [http-8080-Processor23] org.apache.jasper.servlet.JspServlet: PathInfo: null
2006-09-11 16:56:46,773 DEBUG [http-8080-Processor23] org.apache.jasper.servlet.JspServlet: RealPath: /Users/.dgregor/opennms/trunk/workspace/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/webapps/opennms-webapp/test/testProgressBar.jsp
2006-09-11 16:56:46,773 DEBUG [http-8080-Processor23] org.apache.jasper.servlet.JspServlet: RequestURI: /opennms-webapp/test/testProgressBar.jsp
2006-09-11 16:56:46,773 DEBUG [http-8080-Processor23] org.apache.jasper.servlet.JspServlet: QueryString: null
2006-09-11 16:56:46,773 DEBUG [http-8080-Processor23] org.apache.jasper.servlet.JspServlet: Request Params:
2006-09-11 16:56:46,773 DEBUG [http-8080-Processor23] org.apache.catalina.core.ApplicationDispatcher: servletPath=/WEB-INF/jsp/progressBar.jsp, pathInfo=null, queryString=null, name=null
2006-09-11 16:56:46,773 DEBUG [http-8080-Processor23] org.apache.catalina.core.ApplicationDispatcher: Path Based Forward
2006-09-11 16:56:46,773 DEBUG [http-8080-Processor23] org.apache.jasper.servlet.JspServlet: JspEngine --> /WEB-INF/jsp/progressBar.jsp
2006-09-11 16:56:46,773 DEBUG [http-8080-Processor23] org.apache.jasper.servlet.JspServlet: ServletPath: /WEB-INF/jsp/progressBar.jsp
2006-09-11 16:56:46,773 DEBUG [http-8080-Processor23] org.apache.jasper.servlet.JspServlet: PathInfo: null
2006-09-11 16:56:46,773 DEBUG [http-8080-Processor23] org.apache.jasper.servlet.JspServlet: RealPath: /Users/.dgregor/opennms/trunk/workspace/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/webapps/opennms-webapp/WEB-INF/jsp/progressBar.jsp
2006-09-11 16:56:46,773 DEBUG [http-8080-Processor23] org.apache.jasper.servlet.JspServlet: RequestURI: /opennms-webapp/WEB-INF/jsp/progressBar.jsp
2006-09-11 16:56:46,773 DEBUG [http-8080-Processor23] org.apache.jasper.servlet.JspServlet: QueryString: null
2006-09-11 16:56:46,773 DEBUG [http-8080-Processor23] org.apache.jasper.servlet.JspServlet: Request Params:
2006-09-11 16:56:46,773 DEBUG [http-8080-Processor23] org.apache.catalina.core.ApplicationDispatcher: servletPath=/includes/header.jsp, pathInfo=null, queryString=title=Progress&headTitle=Progress&meta=%3cmeta+http-equiv%3d'refresh'+content%3d'3'%3e, name=null
2006-09-11 16:56:46,773 DEBUG [http-8080-Processor23] org.apache.catalina.core.ApplicationDispatcher: Path Based Include
2006-09-11 16:56:46,773 DEBUG [http-8080-Processor23] org.apache.jasper.servlet.JspServlet: JspEngine --> /includes/header.jsp
2006-09-11 16:56:46,773 DEBUG [http-8080-Processor23] org.apache.jasper.servlet.JspServlet: ServletPath: /WEB-INF/jsp/progressBar.jsp
2006-09-11 16:56:46,773 DEBUG [http-8080-Processor23] org.apache.jasper.servlet.JspServlet: PathInfo: null
2006-09-11 16:56:46,773 DEBUG [http-8080-Processor23] org.apache.jasper.servlet.JspServlet: RealPath: /Users/.dgregor/opennms/trunk/workspace/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/webapps/opennms-webapp/includes/header.jsp
2006-09-11 16:56:46,773 DEBUG [http-8080-Processor23] org.apache.jasper.servlet.JspServlet: RequestURI: /opennms-webapp/WEB-INF/jsp/progressBar.jsp
2006-09-11 16:56:46,773 DEBUG [http-8080-Processor23] org.apache.jasper.servlet.JspServlet: QueryString: null
2006-09-11 16:56:46,773 DEBUG [http-8080-Processor23] org.apache.jasper.servlet.JspServlet: Request Params:
2006-09-11 16:56:46,773 DEBUG [http-8080-Processor23] org.apache.jasper.servlet.JspServlet: title = Progress
2006-09-11 16:56:46,773 DEBUG [http-8080-Processor23] org.apache.jasper.servlet.JspServlet: headTitle = Progress
2006-09-11 16:56:46,773 DEBUG [http-8080-Processor23] org.apache.jasper.servlet.JspServlet: meta =
2006-09-11 16:56:46,774 DEBUG [http-8080-Processor23] org.apache.catalina.core.ApplicationDispatcher: servletPath=/includes/navbar.jsp, pathInfo=null, queryString=null, name=null
2006-09-11 16:56:46,774 DEBUG [http-8080-Processor23] org.apache.catalina.core.ApplicationDispatcher: Path Based Include
2006-09-11 16:56:46,774 DEBUG [http-8080-Processor23] org.apache.jasper.servlet.JspServlet: JspEngine --> /includes/navbar.jsp
2006-09-11 16:56:46,774 DEBUG [http-8080-Processor23] org.apache.jasper.servlet.JspServlet: ServletPath: /WEB-INF/jsp/progressBar.jsp
2006-09-11 16:56:46,774 DEBUG [http-8080-Processor23] org.apache.jasper.servlet.JspServlet: PathInfo: null
2006-09-11 16:56:46,774 DEBUG [http-8080-Processor23] org.apache.jasper.servlet.JspServlet: RealPath: /Users/.dgregor/opennms/trunk/workspace/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/webapps/opennms-webapp/includes/navbar.jsp
2006-09-11 16:56:46,774 DEBUG [http-8080-Processor23] org.apache.jasper.servlet.JspServlet: RequestURI: /opennms-webapp/WEB-INF/jsp/progressBar.jsp
2006-09-11 16:56:46,774 DEBUG [http-8080-Processor23] org.apache.jasper.servlet.JspServlet: QueryString: null
2006-09-11 16:56:46,774 DEBUG [http-8080-Processor23] org.apache.jasper.servlet.JspServlet: Request Params:
2006-09-11 16:56:46,774 DEBUG [http-8080-Processor23] org.apache.jasper.servlet.JspServlet: title = Progress
2006-09-11 16:56:46,774 DEBUG [http-8080-Processor23] org.apache.jasper.servlet.JspServlet: headTitle = Progress
2006-09-11 16:56:46,774 DEBUG [http-8080-Processor23] org.apache.jasper.servlet.JspServlet: meta =
2006-09-11 16:56:46,775 DEBUG [http-8080-Processor23] org.apache.catalina.core.ApplicationDispatcher: servletPath=/includes/footer.jsp, pathInfo=null, queryString=null, name=null
2006-09-11 16:56:46,775 DEBUG [http-8080-Processor23] org.apache.catalina.core.ApplicationDispatcher: Path Based Include
2006-09-11 16:56:46,775 DEBUG [http-8080-Processor23] org.apache.jasper.servlet.JspServlet: JspEngine --> /includes/footer.jsp
2006-09-11 16:56:46,775 DEBUG [http-8080-Processor23] org.apache.jasper.servlet.JspServlet: ServletPath: /WEB-INF/jsp/progressBar.jsp
2006-09-11 16:56:46,775 DEBUG [http-8080-Processor23] org.apache.jasper.servlet.JspServlet: PathInfo: null
2006-09-11 16:56:46,775 DEBUG [http-8080-Processor23] org.apache.jasper.servlet.JspServlet: RealPath: /Users/.dgregor/opennms/trunk/workspace/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/webapps/opennms-webapp/includes/footer.jsp
2006-09-11 16:56:46,775 DEBUG [http-8080-Processor23] org.apache.jasper.servlet.JspServlet: RequestURI: /opennms-webapp/WEB-INF/jsp/progressBar.jsp
2006-09-11 16:56:46,775 DEBUG [http-8080-Processor23] org.apache.jasper.servlet.JspServlet: QueryString: null
2006-09-11 16:56:46,775 DEBUG [http-8080-Processor23] org.apache.jasper.servlet.JspServlet: Request Params:
2006-09-11 16:56:46,775 DEBUG [http-8080-Processor23] org.apache.catalina.core.ApplicationDispatcher: Disabling the response for futher output