PDA

View Full Version : Informix


bunty_guru
07-01-02, 18:27
When a i make a change (alter table )in any table used in my applications i get the follow error :


java.sql.SQLException: Table (informix.tablename) has been dropped, altered or renamed.

I am using prepardstatements using a connection pool created in WebLogic 6.1.. I am feeling like prepardstatements are being cached. As when I start the WebLogic server again . problem goes away. Any Idea whats going on ?? Thanks in Advance

-

rhs98
07-05-02, 04:16
As far as i know prepared statements are cached - they are not reparsed every time to speed things up. I don't know for sure for your db though as i have not used informix

try posting a message in the informix section asking wheter prepared statements are cached and if there is a flushing command