I had similar problems recently with tjdo. In that case I found that if
more than one connection with the database was established no fks could be
created. When I modified the tjdo code so that only one connection was
established when ddl was executed it worked ok.

Phil, can you try with the jboss connection pool max size set to 1 and see
what happens? I'd expect there will be either success or a deadlock if
jboss is trying to get more than one connection (i.e. a jboss bug).

thanks
david jencks

On 2002.11.21 09:19:19 -0500 Phil Shrimpton wrote:
> On Thursday 21 November 2002 13:04, you wrote:
>
> Nickolay
>
> > > Whilst I know of issues when changing/droping metadata, creating
> metadata
> > > should not be a problem if commits are issued in the correct place.
> >
> > This is wrong for FB/IB (and should be wrong for all earlier versions).
> > If you have procedures and/or triggers (system triggers enforcing
> > constraints also cause the problems) bugs in their handling in IB6/FB1
> > may prevent you doing this even if you have one connection and commit
> > after each statement (or at whatever place).
>
> Whilst I agree with you that there are issues with metadata updates on
> 'existing' databases, I have never seen problems creating even complex
> DBs
> from scratch, in one go, from a single connection. I have several
> scripts
> that create 500-600 tables + FK's, a few thousand SP's and Triggers, etc.
> and
> as long as the commits are in the right place, they never cause any
> problems.
>
> 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.
>
> What happens is
>
> - Create Table A = Success
> - Create Table B = Success
> - Create FK = Error, Table B in use
>
> 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.
>
> Phil
> --
> Linux 2.4.4-4GB
> 2:05pm up 4 days, 1:29, 1 user, load average: 0.34, 0.32, 0.22
>
>
> To unsubscribe from this group, send an email to:
> Firebird-Java-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>