I am getting the following error when i am performing the update operation onto a table in Acess database from the j2ee 1.3 server
java.sql.SQLException: Timeout Interrupted Exception: beyond 1000 msecs to open a table of EJBPractice.
at com.hxtt.global.SQLState.SQLException(Unknown Source)
at com.hxtt.sql.access.a2.a(Unknown Source)
at com.hxtt.sql.access.r.a(Unknown Source)
at com.hxtt.sql.bm.if(Unknown Source)
at com.hxtt.sql.bm.a(Unknown Source)
at com.hxtt.sql.de.a(Unknown Source)
at com.hxtt.sql.bm.a(Unknown Source)
at com.hxtt.sql.bm.a(Unknown Source)
at com.hxtt.sql.ag.a(Unknown Source)
at com.hxtt.sql.dg.char(Unknown Source)
at com.hxtt.sql.dg.executeUpdate(Unknown Source)
at employee.EmployeeBean.ejbStore(EmployeeBean.java:205)
at com.sun.ejb.containers.EntityContainer.callEJBStore(EntityContainer.java:1641)
at com.sun.ejb.containers.EntityContainer.enlistResourcesAndStore(EntityContainer.java:895)
at com.sun.ejb.containers.EntityContainer.beforeCompletion(EntityContainer.java:880)
at com.sun.ejb.containers.ContainerSynchronization.beforeCompletion(ContainerSynchronization.java:61)
at com.sun.enterprise.distributedtx.J2EETransaction.commit(J2EETransaction.java:152)
at com.sun.enterprise.distributedtx.J2EETransactionManagerOpt.commit(J2EETransactionManagerOpt.java:243)
at com.sun.ejb.containers.BaseContainer.completeNewTx(BaseContainer.java:1485)
at com.sun.ejb.containers.BaseContainer.postInvokeTx(BaseContainer.java:1289)
at com.sun.ejb.containers.BaseContainer.postInvoke(BaseContainer.java:403)
at employee.EmployeeBean_RemoteHomeImpl.create(EmployeeBean_RemoteHomeImpl.java:35)
at employee._EmployeeBean_RemoteHomeImpl_Tie._invoke(Unknown Source)
at com.sun.corba.ee.internal.POA.GenericPOAServerSC.dispatchToServant(GenericPOAServerSC.java:520)
at com.sun.corba.ee.internal.POA.GenericPOAServerSC.internalDispatch(GenericPOAServerSC.java:210)
at com.sun.corba.ee.internal.POA.GenericPOAServerSC.dispatch(GenericPOAServerSC.java:112)
at com.sun.corba.ee.internal.iiop.ORB.process(ORB.java:255)
at com.sun.corba.ee.internal.iiop.RequestProcessor.process(RequestProcessor.java:84)
at com.sun.corba.ee.internal.orbutil.ThreadPool$PooledThread.run(ThreadPool.java:99)
|
It seems that HXTT Access failed to lock and open a table, you can try a bigger lockTimeout connection property value.
|