Hello

It seems the old "unsuccessful metadata update object ........ is in use".

This bug appears or not depending on the state of the database, sometimes where the database is sweeped or the disk defragmented (on
windows) the error disappears.

In the 1.5 builds there are some patches to this bug (by Nickolay Samofatov).

Regards
Blas Rodriguez Somoza

----- Original Message -----
From: "Phil Shrimpton" <phil@...>
To: <Firebird-Java@yahoogroups.com>
Sent: Thursday, November 21, 2002 10:03 AM
Subject: Re: [Firebird-Java] Another Issue with JBoss


> On Thursday 21 November 2002 03:17, you wrote:
>
> David,
>
> > Please always include your exact jboss and firebird versions.
>
> Yes sorry, FB1, Latest CVS Jaybird, JBoss 3.0.4 (tried 3.2.x beta as well)
>
> > So, can you say which versions you have and post the appropriate part of
> > the jboss log showing what's happening.
>
> OK, cut it down a bit, if you need more, it is easily creatable.
>
> 2002-11-21 00:45:18,449 INFO [org.jboss.deployment.MainDeployer]
> Starting deployment of package:
> file:/C:/jboss-3.0.4/server/default/deploy/fc1.jar
> 2002-11-21 00:45:18,669 INFO [org.jboss.ejb.EjbModule] Creating
> 2002-11-21 00:45:18,699 INFO [org.jboss.ejb.EjbModule] Deploying
> Customer
> 2002-11-21 00:45:18,879 INFO [org.jboss.ejb.EjbModule] Deploying Driver
> 2002-11-21 00:45:18,889 INFO [org.jboss.ejb.EjbModule] Deploying Card
> 2002-11-21 00:45:19,000 INFO [org.jboss.ejb.EjbModule] Created
> 2002-11-21 00:45:19,000 INFO [org.jboss.ejb.EjbModule] Starting
> 2002-11-21 00:45:21,583 INFO
> [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.Card] Created table
> 'CARD' successfully.
> 2002-11-21 00:45:21,694 INFO
> [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.Driver] Created table
> 'DRIVER' successfully.
> 2002-11-21 00:45:23,025 WARN
> [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.Driver] Could not add
> foreign key constraint: table=DRIVER
> 2002-11-21 00:45:23,035 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)
> at
> org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.execute(JDBCStartCommand
> .java:123)
> at
> org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.startStoreManager(JDBCSt
> oreManager.java:457)
> at
> org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.j
> ava:369)
> at
> org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.
> java:198)
> at org.jboss.ejb.EntityContainer.start(EntityContainer.java:376)
> at org.jboss.ejb.Container.invoke(Container.java:756)
> at
> org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:1058)
> at
> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
>
> [snip]
>
> + 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.firebirdsql.jdbc.FBConnection.checkEndTransaction(FBConnection.java:
> 1039)
> at
> org.firebirdsql.jdbc.FBStatement.executeUpdate(FBStatement.java:157)
> at
> org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.addForeignKeyConstraint(
> JDBCStartCommand.java:375)
> at
> org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.addForeignKeyConstraint(
> JDBCStartCommand.java:304)
> at
> org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.execute(JDBCStartCommand
> .java:123)
> at
> org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.startStoreManager(JDBCSt
> oreManager.java:457)
> at
> org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.j
> ava:369)
> at
> org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.
> java:198)
> at org.jboss.ejb.EntityContainer.start(EntityContainer.java:376)
> at org.jboss.ejb.Container.invoke(Container.java:756)
> at
> org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:1058)
> at
> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
>
> [snip]
>
> 2002-11-21 00:45:23,206 INFO [org.jboss.ejb.EjbModule] Started
> 2002-11-21 00:45:23,206 INFO [org.jboss.deployment.MainDeployer]
> Deployed package: file:/C:/jboss-3.0.4/server/default/deploy/fc1.jar
>
> Cheers
>
> Phil
>
> --
> Linux 2.4.4-4GB
> 8:52am up 3 days, 20:15, 1 user, load average: 0.55, 0.36, 0.18
>
>
> 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/
>
>
>