Subject RE: [Firebird-Java] OBJECT in use during Foreign key creation
Author Robert DiFalco
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.


-----Original Message-----
From: Helen Borrie [mailto:helebor@...]
Sent: Wednesday, March 26, 2003 1:21 AM
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
>the existince of the table name before I create it, I eventually hang
>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
can do other stuff with/to it...


Yahoo! Groups Sponsor

To unsubscribe from this group, send an email to:

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