Re: jdbc & tomcat

You must be executing a stored procedure.
Instead of DROPing the table, TRUNCATE the table.
You will have to "CREATE OR REPLACE" the procedure.

JLL

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