Hi,

I've been using firebird DB for few days now and when
I run my application (which is a app-server with
connection pooling) got the following error messages
consistently (my tables have foreign-key definitions
of course!)..

unsuccessful metadata update
object <tableName> is in use.

I searched through the net and found a answer in the
KnowledgeBase
http://www.ibphoenix.com/main.nfs?a=ibphoenix&l=;KNOWLEDGEBASE;ID='6'

My question now is: Can some body help me figure out
why such a "exclusive" access (as mentioned in the KB)
is required? I've used MySQL and Oracle DBs and I can
understand if such a restriction is imposed if the
Table is really in use (may be part of a transaction).
But, the above error happens if there exist more than
one connection with the DB and I donot perform *ANY*
operation apart from create table, that too with the
SAME CONNECTION.

I'll be grateful if I can get any clues/pointers and
any ways to counter this behavior of firebird?

Thanks,
Suresh.K.V.

PS> Details on Firebird I use:

DB: Firebird/x86/Windows NT (access method), version
"WI-V1.5.0.4306 Firebird 1.5"
on disk structure version 10.1

JDBC: firebirdsql-full.jar (from the
FirebirdSQL-1.0_beta_1)






____________________________________________________________
Yahoo! Messenger - Communicate instantly..."Ping"
your friends today! Download Messenger Now
http://uk.messenger.yahoo.com/download/index.html