Subject Re[4]: [Firebird-Java] Another Issue with JBoss
Author Nickolay Samofatov
Hello Phil,

Thursday, November 21, 2002, 5:19:19 PM, you wrote:

> Whilst I agree with you that there are issues with metadata updates on
> 'existing' databases, I have never seen problems creating even complex DBs
And I had. There is a possible chain of triggers or foreign constraints
with ON UPDATE CASCADE rule and recursive procedures that will make
you a trouble even on database creation stage. Yes, this problems are much
easier to reproduce while altering metadata, not creating it.
It is fixed in FB1.5 anyway.

> In this case, the 'object in use' error happens when JBoss is creating two
> simple tables (with 2/3 fields each), and a FK between them.

In this case this error probably means than you have 2 CS connections or some
uncommitted transactions or some open prepared statements (i.e.
possibly Jaybird problems).

> I can recreate this error in a script, by not putting a COMMIT after the
> creation of Table B. If I do put a COMMIT after the creation of Table B, it
> always works.

Did you check this script on FB1.5 ? Can you send it to me if it fails
there ?

> Phil

Best regards,
Nickolay Samofatov mailto:skidder@...