Re: Re: [Firebird-Java] Another Issue with JBoss
On Thursday 21 November 2002 16:33, you wrote:
> 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
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
Reason: unsuccessful metadata update
object CARD is in use)
Is there anyway I can turn logging on in Jaybird so I can see if/when any
commits are happening?
10:38am up 53 min, 1 user, load average: 0.29, 0.10, 0.03