exception with a temporary table

From: "Pablo Araujo" <ferarap(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: exception with a temporary table
Date: 2006-11-20 10:05:45
Message-ID: b8e724640611200205h6e1d9c57t82255c06d1529be9@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hello forum, i am new in this forum. Excuse, but my English is not very
good.

I have an application CRUD, created from AndroMDA, with several classes
that inherit of others, for example:

camera ---> item
host ---> item

and other tables are associate as well to these:

cameraassignment --associations--> camera
I am using PostgreSQL 8.1 and hibernate 3.

The exception happens when i delete a camera, for example.

The full stack trace is:

10:42:03,013 INFO [STDOUT] Hibernate: insert into HT_item select
itemimpl0_.item_id as item_id from public.item itemimpl0_ where item_id in
(?)
10:42:03,029 WARN [JDBCExceptionReporter] SQL Error: 0, SQLState: 42P01
10:42:03,029 ERROR [JDBCExceptionReporter] ERROR: relation "ht_item" does
not exist
10:42:03,029 WARN [MultiTableDeleteExecutor] unable to drop temporary id
table after use
org.postgresql.util.PSQLException: ERROR: table "ht_item" does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(
QueryExecutorImpl.java:1512)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(
QueryExecutorImpl.java:1297)
at org.postgresql.core.v3.QueryExecutorImpl.execute(
QueryExecutorImpl.java:188)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(
AbstractJdbc2Statement.java:437)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(
AbstractJdbc2Statement.java:339)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(
AbstractJdbc2Statement.java:285)
at org.jboss.resource.adapter.jdbc.WrappedStatement.executeUpdate(
WrappedStatement.java:184)
at org.hibernate.hql.ast.exec.AbstractStatementExecutor$2.doWork(
AbstractStatementExecutor.java:149)
at
org.hibernate.hql.ast.exec.AbstractStatementExecutor.dropTemporaryTableIfNecessary
(AbstractStatementExecutor.java:170)
at org.hibernate.hql.ast.exec.MultiTableDeleteExecutor.execute(
MultiTableDeleteExecutor.java:136)
at org.hibernate.hql.ast.QueryTranslatorImpl.executeUpdate(
QueryTranslatorImpl.java:334)
at org.hibernate.engine.query.HQLQueryPlan.performExecuteUpdate(
HQLQueryPlan.java:209)
at org.hibernate.impl.SessionImpl.executeUpdate(SessionImpl.java
:1126)
at org.hibernate.impl.QueryImpl.executeUpdate(QueryImpl.java:94)
at es.indra.vipet.appcrud.domain.crud.CameraManageableDaoBase.delete
(CameraManageableDaoBase.java:380)
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:287)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint
(ReflectiveMethodInvocation.java:181)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:148)
at org.springframework.orm.hibernate3.HibernateInterceptor.invoke(
HibernateInterceptor.java:97)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:170)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(
JdkDynamicAopProxy.java:176)
at $Proxy75.delete(Unknown Source)
at
es.indra.vipet.appcrud.domain.crud.CameraManageableServiceBase.delete(
CameraManageableServiceBase.java:88)
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:287)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint
(ReflectiveMethodInvocation.java:181)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:148)
at org.springframework.orm.hibernate3.HibernateInterceptor.invoke(
HibernateInterceptor.java:97)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:170)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(
JdkDynamicAopProxy.java:176)
at $Proxy76.delete(Unknown Source)
at es.indra.vipet.appcrud.domain.crud.ManageCamera.delete(
ManageCamera.java:147)
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.apache.struts.actions.DispatchAction.dispatchMethod(
DispatchAction.java:274)
at org.apache.struts.actions.DispatchAction.execute(
DispatchAction.java:194)
at es.indra.vipet.appcrud.domain.crud.ManageCamera.execute(
ManageCamera.java:22)
at org.apache.struts.action.RequestProcessor.processActionPerform(
RequestProcessor.java:419)
at org.apache.struts.action.RequestProcessor.process(
RequestProcessor.java:224)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java
:1194)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java
:432)
at org.andromda.presentation.bpm4struts.ActionServlet.doPost(
ActionServlet.java:48)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:173)
at org.displaytag.filter.ResponseOverrideFilter.doFilter(
ResponseOverrideFilter.java:125)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:173)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(
ReplyHeaderFilter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(
StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(
StandardContextValve.java:178)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(
SecurityAssociationValve.java:175)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(
JaccContextValve.java:74)
at org.apache.catalina.core.StandardHostValve.invoke(
StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(
ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(
StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(
CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(
Http11Processor.java:869)
at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection
(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(
PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(
MasterSlaveWorkerThread.java:112)
at java.lang.Thread.run(Thread.java:595)
what I have found out until now is that the exception happens when ht_item
tries to use the temporary table that must be created before.
Why it is not created?

I have proven with mysql and works correctly.

Thanks

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2006-11-20 11:50:58 Re: exception with a temporary table
Previous Message Michael Paesold 2006-11-20 07:38:27 Re: JDBC Support for standard_conforming_strings