Re: jdbc & tomcat

Steve,

This error message is from some other object in the database that
depended on the table you dropped. Most likely this is a view that
selects from the table. After dropping and recreating the table you
also need to drop and recreate dependent objects like views.

thanks,
--Barry

Steve Linabery wrote:

> So I'm using postgresql 7.2, redhat linux 7.1, jakarta tomcat 4.x,
> j2sdk 1.4.
>
> I have a jsp that instantiates a bean that creates a Connection and
> queries a table called dw_adcosts.
>
> This table is updated nightly with data from another database. Until
> recently, this update was done with a DELETE followed by multiple
> INSERTs. This eventually caused performance problems since I wasn't
> doing a VACUUM after the DELETE, so I decided to DROP the table and
> re-CREATE it each time (I already had meta-info about the table stored
> in an xml document, so re-creating it wasn't a problem).
>
> THIS is the problem: Since I first dropped the table, my jsp doesn't
> work. I suspect this is not a postgresql problem, but I'm hoping
> someone has some ideas anyway. When I try to access the jsp, the
> bean's Connection throws this exception:
> java.sql.SQLException: ERROR: Relation "dw_adcosts" with OID 597084
> no longer exists
>
> I thought perhaps this was something weird with the pgjdbc driver, so
> I got the shiniest, newest version. Restarted Tomcat. Still get the
> error.
>
> I can "see" the table just fine using psql.
>
> If I can just get the jsp working again, I think I'll just TRUNCATE
> the table from now on...but my problem is that even with restarting
> tomcat I get this error. I know jsp's get compiled, but the bean
> creates a new Connection each time its
> "getTheOutputThatTheJspNeedsOrSomeSimilarMethodName()" method is called.
>
> Anyone have any thoughts on this?
>
> Thank you,
> Steve Linabery
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>