Results 1 to 2 of 2

Thread: Informix

  1. #1
    Join Date
    Jul 2002
    Posts
    2

    Unanswered: Informix

    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

    -

  2. #2
    Join Date
    Feb 2002
    Location
    San Francisco, CA
    Posts
    441
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •