Re: exception with a temporary table - Mailing list pgsql-jdbc

Pablo,

You should be aware that the temporary table only exists for the
connection that created it.

Once that connection closes the table is dropped, also that table is
only visible to the connection that created it.

Dave
On 20-Nov-06, at 5:05 AM, Pablo Araujo wrote:

> 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.dropTemporaryTabl
> eIfNecessary (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.invokeJoinpointUsingReflectio
> n(AopUtils.java:287)
>         at
> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoi
> npoint(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.invokeJoinpointUsingReflectio
> n(AopUtils.java:287)
>         at
> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoi
> npoint (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