I have a multi-threaded application. Each thread has its own database connection. One of the thread changes the schema of the database (DROP TABLE, CREATE TABLE). I have observed that the other threads do not know about these modifications since queries for the new/altered table doesn't return the expected results.
It looks like the schema is cached by the connection. Can anybody confirm this? How can I efficiently refresh the cache, or do I have to close and reopen the database connection? -Ralf
