I don't think that is the problem because I do perform a commit after
the call to dbMetaData.getTables(). I've also tried setting the
connection to autocommit but something seems to be keeping a lock on the
relations table.

R.


-----Original Message-----
From: Helen Borrie [mailto:helebor@...]
Sent: Wednesday, March 26, 2003 1:21 AM
To: Firebird-Java@yahoogroups.com
Subject: RE: [Firebird-Java] OBJECT in use during Foreign key creation


At 06:11 PM 25/03/2003 -0800, you wrote:

>Actually, with a small test case, I can make this work with JayBird.
>However, if I add some con.getMetaData() calls in between that query

for

>the existince of the table name before I create it, I eventually hang

on

>one of the calls to dbMetaData.getTables( null, null,
>getPrimaryTableName(), null ). Hmmmm....

You do need to COMMIT each metadata item in its own transaction before
you
can do other stuff with/to it...

Helen



Yahoo! Groups Sponsor



To unsubscribe from this group, send an email to:
Firebird-Java-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.