On 2002.11.22 05:38:33 -0500 Phil Shrimpton wrote:

> On Thursday 21 November 2002 16:33, you wrote:
>
> David,
>
> > 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.
>
>
> That is correct. Its almost impossible to create FKs (or any metadata)
> successfully if there is more than one connection.
>
> > 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).
>
>
> I changed the max connection pool setting to 1 in
> firebird-service.xml, and the FK creation still failed.
>
> 2002-11-22 00:43:07,172 WARN
> [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.Driver] Could not add
> foreign key constraint: table=DRIVER
> 2002-11-22 00:43:07,182 WARN [org.jboss.system.ServiceController]
> Problem starting service jboss.j2ee:jndiName=CustomerRemote,service=EJB
> org.jboss.deployment.DeploymentException: Error while adding foreign key
> constraint; - nested throwable: (java.sql.SQLException: Error during
> autocommit: org.firebirdsql.jca.FBResourceException: couldn't commit
> local transaction.
> Reason: unsuccessful metadata update
> object CARD is in use)
> at
> org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.addForeignKeyConstraint(
> JDBCStartCommand.java:384)
> at
> org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.addForeignKeyConstraint(
> JDBCStartCommand.java:304)
>
> Is there anyway I can turn logging on in Jaybird so I can see if/when any
>
> commits are happening?

My experience is that unless I put a line in log4j.xml setting the priority
for org.firebirdsql to INFO or higher I get more logging than I want.

Since the error says the problem occurs during autocommit, I think the
table creation was also autocommitted. I'm mystified.

In my tjdo application, probably 75 tables with maybe 100 fks are created
without problem, so I'm really really mystified.

david jencks

>
> Phil
> --
> Linux 2.4.4-4GB
> 10:38am up 53 min, 1 user, load average: 0.29, 0.10, 0.03
>
>
> 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/
>
>
>
>
>