Results 1 to 2 of 2

Thread: Informix

  1. #1
    Join Date
    Jul 2002

    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
    Aug 2002
    This is certainly a weblogic problem.
    I have a feeling that when you start weblogic it will read the database structure. If you alter a table, your weblogic sees the difference and raises an exception.
    That's why the problem goes away if you restart.
    Check your weblogic docs. There might be a setting that allows you to execute DDL without raising exceptions

Posting Permissions

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