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?

Phil
--
Linux 2.4.4-4GB
10:38am up 53 min, 1 user, load average: 0.29, 0.10, 0.03