Please always include your exact jboss and firebird versions.

As I recall JBoss has been relying on the connections being in
autocommit=true when creating tables, fks, etc for quite some time (in the
3 + branches). Assuming you are using such a JBoss version, this would
point to the autocommit functionality in jaybird being broken.

When used as a connector, connections are supposed commit each operation
separately (like autocommit=true) when there is no managed transaction
(started by the tx manager).

So, can you say which versions you have and post the appropriate part of
the jboss log showing what's happening.

thanks
david jencks

On 2002.11.20 19:31:59 -0500 Phil Shrimpton wrote:
> Hi,
>
> Not sure if this is Jaybird or Jboss, but I will start here..
>
> When JBoss is deploying CMP EJB's, with "create-tables = true", who is
> controlling the transactions, JBoss or Jaybird?
>
> What is happening is attempts to create Foreign Keys seem to be happening
>
> before the "table creation" transaction has been committed, resulting in
> an
> Object in use exception thrown.
>
> It would probably help if I could get more info out of the Jaybird/Jboss
> logs, but I haven't figured out how to do that yet!
>
> Phil
> --
> Linux 2.4.4-4GB
> 12:18am up 3 days, 11:42, 1 user, load average: 0.33, 0.17, 0.17
>
>
> 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/
>
>
>
>
>