jdbc & tomcat
От | Steve Linabery |
---|---|
Тема | jdbc & tomcat |
Дата | |
Msg-id | 3D6CDAC4.8040809@worldcycling.com обсуждение исходный текст |
Ответы |
Re: jdbc & tomcat
Re: jdbc & tomcat |
Список | pgsql-jdbc |
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
В списке pgsql-jdbc по дате отправления: