"vrotaru" wrote:

"vrotaru" wrote:

"vrotaru" wrote:

"vrotaru" wrote:
jdk 1.4.2
JBoss 3.2.3
Firebird 1.5 RC8
JayBird JCA connector 1.5 (latest)

I have the following problem:

Scenario:

Begin TX
Issue DDL create table CUSTOMER
Commit TX

Check with isql: table CUSTOMER correctly created with proper constraints.

Begin TX
Issue DDL create table ORDERS which has a foreign key linked to the previous created table
Commit TX
On commit I got the following exception:

------------------------------------------------------------------------

15:04:36,182 WARN tm.TransactionImpl TransactionImpl logXAException() XAException: tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=localhost//407, BranchQual=] errorCode=XA_UNKNOWN(0)
org.jboss.resource.connectionmanager.JBossLocalXAException: could not commit local tx; - nested throwable:
(org.jboss.resource.JBossResourceException: SQLException; - nested throwable: (org.firebirdsql.jdbc.FBSQLException: Resource Exception. unsuccessful metadata update
object CUSTOMER is in use
Reason: unsuccessful metadata update
object CUSTOMER is in use))
at org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource.commit(TxConnectionManager.java:755)
at org.jboss.tm.TransactionImpl.commitResources(TransactionImpl.java:1593)
at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:375)
at org.jboss.tm.TxManager.commit(TxManager.java:141)
at org.jboss.ejb.EnterpriseContext$UserTransactionImpl.commit(EnterpriseContext.java:477)
at com.brightsoft.mobilemaster.ejb.mgmtint.impl.ProvisioningEJB.createObject(ProvisioningEJB.java:1175)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:683)
at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:185)
at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:84)
at org.jboss.ejb.plugins.AbstractTxInterceptorBMT.invokeNext(AbstractTxInterceptorBMT.java:144)
at org.jboss.ejb.plugins.TxInterceptorBMT.invoke(TxInterceptorBMT.java:62)
at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:72)
at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:118)
at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
at org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionContainer.java:331)
at org.jboss.ejb.Container.invoke(Container.java:700)
at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.java:375)
at org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionProxy.java:83)
at $Proxy143.createObject(Unknown Source)

------------------------------------------------------------------------

open isql and run the CREATE TABLE ORDERS SQL but got the error:

------------------------------------------------------------------------
Statement failed, SQLCODE = -607

unsuccessful metadata update
-object CUSTOMER is in use
------------------------------------------------------------------------

Any help would be greatly appreciated.

Regards