Hi all,

I am getting this error while running 5 concurrent clients

can any one help on this

org.firebirdsql.jdbc.FBSQLException: GDS Exception. deadlock

deadlock

update conflicts with concurrent update

at org.firebirdsql.jdbc.FBPreparedStatement.internalExecute(FBPreparedStatement.java:425)

at org.firebirdsql.jdbc.FBPreparedStatement.executeUpdate(FBPreparedStatement.java:136)

at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreEntityCommand.execute(JDBCStoreEntityCommand.java:153)

at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.storeEntity(JDBCStoreManager.java:649)

at org.jboss.ejb.plugins.CMPPersistenceManager.storeEntity(CMPPersistenceManager.java:434)

at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.storeEntity(CachedConnectionInterceptor.java:388)

at org.jboss.ejb.EntityContainer.storeEntity(EntityContainer.java:702)

at org.jboss.ejb.GlobalTxEntityMap.synchronizeEntities(GlobalTxEntityMap.java:163)

at org.jboss.ejb.GlobalTxEntityMap$GlobalTxEntityMapCleanup.beforeCompletion(GlobalTxEntityMap.java:227)

at org.jboss.tm.TransactionImpl.doBeforeCompletion(TransactionImpl.java:1297)

at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:338)

at org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(TxInterceptorCMT.java:369)

at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:301)

at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:104)

at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:117)

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:322)

at org.jboss.ejb.Container.invoke(Container.java:674)

at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.java:353)

at org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionProxy.java:83)

at $Proxy213.createOrder(Unknown Source)

at com.telegea.orderAPI.ejb.OrderAPIBean.APEntry(OrderAPIBean.java:162)

at java.lang.reflect.Method.invoke(Native Method)

at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:629)

at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:186)

at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:72)

at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:84)

at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:243)

at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:104)

at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:117)

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:322)

at org.jboss.ejb.Container.invoke(Container.java:674)

at java.lang.reflect.Method.invoke(Native Method)

at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)

at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)

at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:101)

at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:83)

at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:46)

at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:45)

at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:100)

at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:85)

at $Proxy191.APEntry(Unknown Source)

at com.telegea.soapagent.OrderEntryBridge.callOrderAPI(OrderEntryBridge.java:79)

at com.telegea.soapagent.adapter.soap.APSoapRequestAgent.doPost(APSoapRequestAgent.java:125)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:360)

at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:294)

at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:558)

at org.mortbay.http.HttpContext.handle(HttpContext.java:1714)

at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:507)

at org.mortbay.http.HttpContext.handle(HttpContext.java:1664)

at org.mortbay.http.HttpServer.service(HttpServer.java:863)

at org.jboss.jetty.Jetty.service(Jetty.java:460)

at org.mortbay.http.HttpConnection.service(HttpConnection.java:775)

at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:939)

at org.mortbay.http.HttpConnection.handle(HttpConnection.java:792)

at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:201)

at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:289)

at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:455)

thanks,

Prem



---------------------------------
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software

[Non-text portions of this message have been removed]