タイムアウト
537e2d8663c7eb5e4c15e16a37ec550[] が、120 秒後にタイムアウトになりました。
[03/07/29 19:34:11:289 JST] 5b14d9 XATransaction E J2CA0026E: 現行トランザクションの同期マネージャーでリソース・アダプターを登録しようとして、メソッド addSync が javax.transaction.RollbackException
at com.ibm.ejs.jts.jta.TransactionImpl.registerSynchronization(TransactionImpl.java:955)
at com.ibm.ejs.jts.jta.JTSXA.registerSynchronization(JTSXA.java:1096)
at com.ibm.ejs.j2c.XATransactionWrapper.addSync(XATransactionWrapper.java:255)
at com.ibm.ejs.j2c.ConnectionManager.initializeForUOW(ConnectionManager.java:805)
at com.ibm.ejs.j2c.ConnectionManager.involveMCInTran(ConnectionManager.java:651)
at com.ibm.ejs.j2c.ConnectionManager.associateConnection(ConnectionManager.java:1183)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.reactivate(WSJdbcConnection.java:1338)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.java:1242)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.java:1222)
at jp.co.zeus.INT.N5B.fw.N5BZDBConnection.prepareStatement(N5BZDBConnection.java:168)
at jp.co.zeus.INT.N5B.fw.N5BZDBStatement.getPreparedStatement(N5BZDBStatement.java:69)
at jp.co.zeus.INT.N5B.fw.N5BZDBQuery.execute(N5BZDBQuery.java:74)
at jp.co.zeus.INT.NWD.api.NWDOBaseDAO.executeQuery(NWDOBaseDAO.java:102)
at jp.co.zeus.INT.NWD.api.NWDOBaseDAO.executeQuery(NWDOBaseDAO.java:55)
at jp.co.zeus.INT.NWD.api.NWDOffer_DAO.searchCnt(NWDOffer_DAO.java:1057)
at jp.co.zeus.INT.NWD.api.NWDDocumentAccess.searchDocList(NWDDocumentAccess.java:205)
at jp.co.zeus.INT.NYA.search.NYAHznDichSearchDao.search(NYAHznDichSearchDao.java:321)
at jp.co.zeus.INT.NYA.search.NYAHznDichSearch.execute(NYAHznDichSearch.java:66)
at jp.co.zeus.INT.NYA.main.NYAZHznDichControllerBean.prepareNYADPL1000_BACK(NYAZHznDichControllerBean.java:3344)
at jp.co.zeus.INT.NYA.main.NYAZHznDichControllerBean.prepareBackList(NYAZHznDichControllerBean.java:3305)
at jp.co.zeus.INT.NYA.main.NYAZHznDichControllerBean.gotoList(NYAZHznDichControllerBean.java:3291)
at jp.co.zeus.INT.NYA.main.NYAZHznDichControllerBean.doExecute(NYAZHznDichControllerBean.java:392)
at jp.co.zeus.INT.N5B.fw.N5BZEJBAppControllerBase.doExecute(N5BZEJBAppControllerBase.java:161)
at jp.co.zeus.ifit.fw.business.controller.EJBAppControllerBase.execute(Unknown Source)
at jp.co.zeus.ifit.fw.business.controller.EJSRemoteStatelessNYAZHznDichControllerBean_d99d9511.execute(Unknown Source)
at jp.co.zeus.ifit.fw.business.controller._EJBAppController_Stub.execute(Unknown Source)
at jp.co.zeus.ifit.fw.business.proxy.EJBAppProxy.doExecute(Unknown Source)
at jp.co.zeus.ifit.fw.business.proxy.AppProxy.execute(Unknown Source)
at jp.co.zeus.ifit.fw.web.action.InputAction.callApplication(Unknown Source)
at jp.co.zeus.INT.N5B.fw.N5BZInputAction.callApplication(N5BZInputAction.java:163)
at jp.co.zeus.ifit.fw.web.action.InputAction.doExecute(Unknown Source)
at jp.co.zeus.ifit.fw.web.action.InputAction.execute(Unknown Source)
at jp.co.zeus.ifit.fw.web.action.InputActionInvoker.invoke(Unknown Source)
at jp.co.zeus.ifit.fw.web.action.FrontController.doProcess(Unknown Source)
at jp.co.zeus.ifit.fw.web.action.FrontController.process(Unknown Source)
at jp.co.zeus.ifit.fw.web.action.FrontController.doPost(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174)
at com.ibm.ws.webcontainer.servlet.ServicingServletState.service(StrictLifecycleServlet.java:333)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116)
at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:283)
at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42)
at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:76)
at jp.co.zeus.ifit.fw.web.filter.BaseFilter.doFilter(Unknown Source)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:132)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:71)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:914)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:528)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:176)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:79)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:201)
at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71)
at com.ibm.ws.webcontainer.cache.invocation.CacheableInvocationContext.invoke(CacheableInvocationContext.java:114)
at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:186)
at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334)
at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56)
at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:516)
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:362)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:593)
をキャッチして、ResourceException をスローしました。
[03/07/29 19:34:11:336 JST] 5b14d9 WSJdbcConnect W DSRA9400E: Connection の再アソシエーション中に致命的エラーが発生しました: javax.resource.ResourceException: addSync: caught Exception
at com.ibm.ejs.j2c.XATransactionWrapper.addSync(XATransactionWrapper.java:265)
at com.ibm.ejs.j2c.ConnectionManager.initializeForUOW(ConnectionManager.java:805)
at com.ibm.ejs.j2c.ConnectionManager.involveMCInTran(ConnectionManager.java:651)
at com.ibm.ejs.j2c.ConnectionManager.associateConnection(ConnectionManager.java:1183)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.reactivate(WSJdbcConnection.java:1338)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.java:1242)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.java:1222)
at jp.co.zeus.INT.N5B.fw.N5BZDBConnection.prepareStatement(N5BZDBConnection.java:168)
at jp.co.zeus.INT.N5B.fw.N5BZDBStatement.getPreparedStatement(N5BZDBStatement.java:69)
at jp.co.zeus.INT.N5B.fw.N5BZDBQuery.execute(N5BZDBQuery.java:74)
at jp.co.zeus.INT.NWD.api.NWDOBaseDAO.executeQuery(NWDOBaseDAO.java:102)
at jp.co.zeus.INT.NWD.api.NWDOBaseDAO.executeQuery(NWDOBaseDAO.java:55)
at jp.co.zeus.INT.NWD.api.NWDOffer_DAO.searchCnt(NWDOffer_DAO.java:1057)
at jp.co.zeus.INT.NWD.api.NWDDocumentAccess.searchDocList(NWDDocumentAccess.java:205)
at jp.co.zeus.INT.NYA.search.NYAHznDichSearchDao.search(NYAHznDichSearchDao.java:321)
at jp.co.zeus.INT.NYA.search.NYAHznDichSearch.execute(NYAHznDichSearch.java:66)
at jp.co.zeus.INT.NYA.main.NYAZHznDichControllerBean.prepareNYADPL1000_BACK(NYAZHznDichControllerBean.java:3344)
at jp.co.zeus.INT.NYA.main.NYAZHznDichControllerBean.prepareBackList(NYAZHznDichControllerBean.java:3305)
at jp.co.zeus.INT.NYA.main.NYAZHznDichControllerBean.gotoList(NYAZHznDichControllerBean.java:3291)
at jp.co.zeus.INT.NYA.main.NYAZHznDichControllerBean.doExecute(NYAZHznDichControllerBean.java:392)
at jp.co.zeus.INT.N5B.fw.N5BZEJBAppControllerBase.doExecute(N5BZEJBAppControllerBase.java:161)
at jp.co.zeus.ifit.fw.business.controller.EJBAppControllerBase.execute(Unknown Source)
at jp.co.zeus.ifit.fw.business.controller.EJSRemoteStatelessNYAZHznDichControllerBean_d99d9511.execute(Unknown Source)
at jp.co.zeus.ifit.fw.business.controller._EJBAppController_Stub.execute(Unknown Source)
at jp.co.zeus.ifit.fw.business.proxy.EJBAppProxy.doExecute(Unknown Source)
at jp.co.zeus.ifit.fw.business.proxy.AppProxy.execute(Unknown Source)
at jp.co.zeus.ifit.fw.web.action.InputAction.callApplication(Unknown Source)
at jp.co.zeus.INT.N5B.fw.N5BZInputAction.callApplication(N5BZInputAction.java:163)
at jp.co.zeus.ifit.fw.web.action.InputAction.doExecute(Unknown Source)
at jp.co.zeus.ifit.fw.web.action.InputAction.execute(Unknown Source)
at jp.co.zeus.ifit.fw.web.action.InputActionInvoker.invoke(Unknown Source)
at jp.co.zeus.ifit.fw.web.action.FrontController.doProcess(Unknown Source)
at jp.co.zeus.ifit.fw.web.action.FrontController.process(Unknown Source)
at jp.co.zeus.ifit.fw.web.action.FrontController.doPost(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174)
at com.ibm.ws.webcontainer.servlet.ServicingServletState.service(StrictLifecycleServlet.java:333)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116)
at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:283)
at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42)
at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:76)
at jp.co.zeus.ifit.fw.web.filter.BaseFilter.doFilter(Unknown Source)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:132)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:71)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:914)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:528)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:176)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:79)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:201)
at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71)
at com.ibm.ws.webcontainer.cache.invocation.CacheableInvocationContext.invoke(CacheableInvocationContext.java:114)
at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:186)
at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334)
at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56)
at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:516)
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:362)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:593)
---- Begin backtrace for Nested Throwables
javax.transaction.RollbackException
at com.ibm.ejs.jts.jta.TransactionImpl.registerSynchronization(TransactionImpl.java:955)
at com.ibm.ejs.jts.jta.JTSXA.registerSynchronization(JTSXA.java:1096)
at com.ibm.ejs.j2c.XATransactionWrapper.addSync(XATransactionWrapper.java:255)
at com.ibm.ejs.j2c.ConnectionManager.initializeForUOW(ConnectionManager.java:805)
at com.ibm.ejs.j2c.ConnectionManager.involveMCInTran(ConnectionManager.java:651)
at com.ibm.ejs.j2c.ConnectionManager.associateConnection(ConnectionManager.java:1183)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.reactivate(WSJdbcConnection.java:1338)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.java:1242)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.java:1222)
at jp.co.zeus.INT.N5B.fw.N5BZDBConnection.prepareStatement(N5BZDBConnection.java:168)
at jp.co.zeus.INT.N5B.fw.N5BZDBStatement.getPreparedStatement(N5BZDBStatement.java:69)
at jp.co.zeus.INT.N5B.fw.N5BZDBQuery.execute(N5BZDBQuery.java:74)
at jp.co.zeus.INT.NWD.api.NWDOBaseDAO.executeQuery(NWDOBaseDAO.java:102)
at jp.co.zeus.INT.NWD.api.NWDOBaseDAO.executeQuery(NWDOBaseDAO.java:55)
at jp.co.zeus.INT.NWD.api.NWDOffer_DAO.searchCnt(NWDOffer_DAO.java:1057)
at jp.co.zeus.INT.NWD.api.NWDDocumentAccess.searchDocList(NWDDocumentAccess.java:205)
at jp.co.zeus.INT.NYA.search.NYAHznDichSearchDao.search(NYAHznDichSearchDao.java:321)
at jp.co.zeus.INT.NYA.search.NYAHznDichSearch.execute(NYAHznDichSearch.java:66)
at jp.co.zeus.INT.NYA.main.NYAZHznDichControllerBean.prepareNYADPL1000_BACK(NYAZHznDichControllerBean.java:3344)
at jp.co.zeus.INT.NYA.main.NYAZHznDichControllerBean.prepareBackList(NYAZHznDichControllerBean.java:3305)
at jp.co.zeus.INT.NYA.main.NYAZHznDichControllerBean.gotoList(NYAZHznDichControllerBean.java:3291)
at jp.co.zeus.INT.NYA.main.NYAZHznDichControllerBean.doExecute(NYAZHznDichControllerBean.java:392)
at jp.co.zeus.INT.N5B.fw.N5BZEJBAppControllerBase.doExecute(N5BZEJBAppControllerBase.java:161)
at jp.co.zeus.ifit.fw.business.controller.EJBAppControllerBase.execute(Unknown Source)
at jp.co.zeus.ifit.fw.business.controller.EJSRemoteStatelessNYAZHznDichControllerBean_d99d9511.execute(Unknown Source)
at jp.co.zeus.ifit.fw.business.controller._EJBAppController_Stub.execute(Unknown Source)
at jp.co.zeus.ifit.fw.business.proxy.EJBAppProxy.doExecute(Unknown Source)
at jp.co.zeus.ifit.fw.business.proxy.AppProxy.execute(Unknown Source)
at jp.co.zeus.ifit.fw.web.action.InputAction.callApplication(Unknown Source)
at jp.co.zeus.INT.N5B.fw.N5BZInputAction.callApplication(N5BZInputAction.java:163)
at jp.co.zeus.ifit.fw.web.action.InputAction.doExecute(Unknown Source)
at jp.co.zeus.ifit.fw.web.action.InputAction.execute(Unknown Source)
at jp.co.zeus.ifit.fw.web.action.InputActionInvoker.invoke(Unknown Source)
at jp.co.zeus.ifit.fw.web.action.FrontController.doProcess(Unknown Source)
at jp.co.zeus.ifit.fw.web.action.FrontController.process(Unknown Source)
at jp.co.zeus.ifit.fw.web.action.FrontController.doPost(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174)
at com.ibm.ws.webcontainer.servlet.ServicingServletState.service(StrictLifecycleServlet.java:333)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116)
at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:283)
at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42)
at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:76)
at jp.co.zeus.ifit.fw.web.filter.BaseFilter.doFilter(Unknown Source)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:132)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:71)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:914)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:528)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:176)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:79)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:201)
at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71)
at com.ibm.ws.webcontainer.cache.invocation.CacheableInvocationContext.invoke(CacheableInvocationContext.java:114)
at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:186)
at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334)
at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56)
at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:516)
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:362)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:593)
at jp.co.zeus.INT.NWD.api.NWDDocumentAccess.searchDocList(NWDDocumentAccess.java:205)
at jp.co.zeus.INT.NYA.search.NYAHznDichSearchDao.search(NYAHznDichSearchDao.java:321)
NYAHznDichSearchDao.search(NYAHznDichSearchDao.java:321)が
NWDDocumentAccess.searchDocList(NWDDocumentAccess.java:205)を呼んでるところ。
具体的には、業務規制をかけると異常に速くなるので、
public Vector search(N5BZDBConnection connect, NYASearchConditions con, N5BZUserInfo userInfo)
throws SystemException, SQLException, Exception
{
start();
...
N5SBRegulationManager regMan = new N5SBRegulationManager();
int regResult = regMan.isRegulation(connect, "NWD", userInfo);
while(list.next())
{
NYAKihonListItem listItem = new NYAKihonListItem();
listItem.setID(list.getString("HZN_DICH_ID").trim());
listItem.setLBL_DICH_SBT(NYAKihonUtil.getLIST_DICH_SBT_NM(list.getString("DICH_SBT_CD").trim()));
listItem.setLBL_DICH_CD(list.getString("DICH_CD").trim());
listItem.setLBL_DICH_NM(list.getString("DICH_NM_ZNM").trim());
listItem.setLBL_STB_BIG_BNR_NM(NYAKihonUtil.value(list.getString("BNR_BIG_NM_ZNM")));
listItem.setLBL_STB_SML_BNR_NM(NYAKihonUtil.value(list.getString("BNR_SML_NM_ZNM")));
for(int i = 0; i < vecUnit.size(); i++)
{
NYACodeNameItem item = (NYACodeNameItem)vecUnit.elementAt(i);
if(!list.getString("UNT_CD").trim().equals(item.getCode().trim()))
continue;
listItem.setLBL_UNT_NM(item.getName());
break;
}
if(regResult == 1) // 業務規制をかけるとこっち
{
listItem.setLBL_DOC_NUM("0");
}
else // 業務規制をかけないとこっち
{
jp.co.zeus.INT.NWD.api.NWDDocumentSearchResultMap doc_list = null;
jp.co.zeus.INT.NWD.api.NWDDocumentSearchResultMap doc_list2 = null;
String str_Dich_ID[] = new String[1];
str_Dich_ID[0] = list.getString("HZN_DICH_ID").trim();
HashMap mapval = new HashMap();
doc_list = (new NWDDocumentAccess()).searchDocList(connect, userInfo, con.getHTD_CD(), "31", str_Dich_ID, str_Kouji_ID, intMax_doc, mapval);
doc_list2 = (new NWDDocumentAccess()).searchDocList(connect, userInfo, con.getHTD_CD(), "D1", str_Dich_ID, str_Kouji_ID, intMax_doc, mapval);
int doc_no = Integer.parseInt(doc_list.get("SEARCH_CNT").toString()) + Integer.parseInt(doc_list2.get("SEARCH_CNT").toString());
listItem.setLBL_DOC_NUM(Integer.toString(doc_no));
str_Dich_ID = null;
doc_list = null;
mapval = null;
doc_list2 = null;
}
retVect.add(listItem);
listItem = null;
}
end();
return retVect;
}
doc_list = (new NWDDocumentAccess()).searchDocList(connect, userInfo, con.getHTD_CD(), "31", str_Dich_ID, str_Kouji_ID, intMax_doc, mapval);
2003-07-29 *19:44:54,822 *ZEUS2 *Zeus2node *2129672 *T0346528 *[N] *SELECT SHUBETU_CD FROM NWTDDSCVT WHERE DOCTYPE_ID = '31'
2003-07-29 *19:44:54,841 *ZEUS2 *Zeus2node *2129672 *T0346528 *[N] *SELECT COUNT(DISTINCT REVISION_ID) AS CNT FROM NWTDDOCMT , NWTDDCREF WHERE CURRENT_FLG = 1 AND UPDATE_FLG = 0 AND DOC_STS = 1 AND HDN_SHO_CD = '503' AND SHUBETU_CD IN ('3A') AND (DAICHO_ID = 1401) AND NWTDDOCMT.DOC_ID = NWTDDCREF.DOC_ID
か、もしくは
doc_list2 = (new NWDDocumentAccess()).searchDocList(connect, userInfo, con.getHTD_CD(), "D1", str_Dich_ID, str_Kouji_ID, intMax_doc, mapval);
2003-07-29 *19:44:54,857 *ZEUS2 *Zeus2node *2129672 *T0346528 *[N] *SELECT SHUBETU_CD FROM NWTDDSCVT WHERE DOCTYPE_ID = 'D1'
2003-07-29 *19:44:54,894 *ZEUS2 *Zeus2node *2129672 *T0346528 *[N] *SELECT COUNT(DISTINCT REVISION_ID) AS CNT FROM NWTDDOCMT , NWTDDCREF WHERE CURRENT_FLG = 1 AND UPDATE_FLG = 0 AND DOC_STS = 1 AND HDN_SHO_CD = '503' AND SHUBETU_CD IN ('DA','DB','DC','DD','DE','DF','DG','DH','DI','DJ','DK','DL','DM','DN','DO','DP','DQ','DR','DS','DU','DV','DW','DZ','FA','FB','FC','FZ','TA','TB','TC','TZ') AND (DAICHO_ID = 1401) AND NWTDDOCMT.DOC_ID = NWTDDCREF.DOC_ID
のメソッドがタイムアウトしている。
たまたまテスト中に見ていたログは
2003-07-29 *19:44:54,894 *ZEUS2 *Zeus2node *2129672 *T0346528 *[N] *SELECT COUNT(DISTINCT REVISION_ID) AS CNT FROM NWTDDOCMT , NWTDDCREF WHERE CURRENT_FLG = 1 AND UPDATE_FLG = 0 AND DOC_STS = 1 AND HDN_SHO_CD = '503' AND SHUBETU_CD IN ('DA','DB','DC','DD','DE','DF','DG','DH','DI','DJ','DK','DL','DM','DN','DO','DP','DQ','DR','DS','DU','DV','DW','DZ','FA','FB','FC','FZ','TA','TB','TC','TZ') AND (DAICHO_ID = 1401) AND NWTDDOCMT.DOC_ID = NWTDDCREF.DOC_ID
で止まっていたように見えた。
NWTDDOCMT表と NWTDDCREF表のJOIN検索が問題みたい。
スタックとレースでタイムアウトしたSQLは
jp.co.zeus.INT.NWD.api.NWDOffer_DAO.searchCnt(NWDOffer_DAO.java:1057)
public N5BZResultDataList searchCnt(N5BZDBConnection connection, String strSql_Where)
throws SQLException
{
start();
StringBuffer strbSql = new StringBuffer();
strbSql.append("SELECT COUNT(DISTINCT ").append("REVISION_ID").append(") AS CNT");
strbSql.append(" FROM NWTDDOCMT ");
if(strSql_Where.length() != 0)
strbSql.append(strSql_Where);
N5BZResultDataList rs = executeQuery(connection, strbSql.toString());
end();
return rs;
}
単純にNWTDDOCMT表とNWTDDCREF表を何回もTabScanしてるから遅くなる。
しかし、C23にして検索ボタン押下は、同じNWDのAPIをリザルトセットの中で呼んでいて、
遅いが応答時間を見る限り平行動作している。
NWDの機能が階段状にシステム全体で排他制御が掛かっている理由にはならない。
さらに、修正ボタンのSQLを追っていくと
2003-07-29 *19:46:35,181 *ZEUS2 *Zeus2node *5322872 *T0370734 *[N] *SELECT COUNT
(*) FROM NYTZE0007 WHERE TNK_GRP_ID=14 AND DEL_FLG=0
2003-07-29 *19:47:13,429 *ZEUS2 *Zeus2node *5322872 *T0370734 *[N] *SELECT * FRO
M NYTBA0001 WHERE TNK_KJN_HJN_ID=1 AND DEL_FLG=0 FOR UPDATE WITH RS
このSQLが原因で処理の同時性が失われていることがわかる。
以前の１０種類の台帳のシナリオを検索すると
以下のようになってました。
今回のテストシナリオの問題ともいえるでしょうね。
このTXT_TNK_KJN_HJN_ID（単価基準標準ID？）単位に
排他制御する業務の仕様なんでしょうね。
$ grep TNK_KJN_HJN_ID */Action1.c
NY保全台帳2/Action1.c: "Name=TXT_TNK_KJN_HJN_ID", "Value=1", ENDITEM,
NY保全台帳3/Action1.c: "Name=TXT_TNK_KJN_HJN_ID", "Value=1", ENDITEM,
NY保全台帳4/Action1.c: "Name=TXT_TNK_KJN_HJN_ID", "Value=1", ENDITEM,
NY保全台帳5/Action1.c: "Name=TXT_TNK_KJN_HJN_ID", "Value=1", ENDITEM,
NY保全台帳6/Action1.c: "Name=TXT_TNK_KJN_HJN_ID", "Value=84", ENDITEM,
NY保全台帳7/Action1.c: "Name=TXT_TNK_KJN_HJN_ID", "Value=27", ENDITEM,
NY保全台帳8/Action1.c: "Name=TXT_TNK_KJN_HJN_ID", "Value=27", ENDITEM,
NY保全台帳9/Action1.c: "Name=TXT_TNK_KJN_HJN_ID", "Value=27", ENDITEM,
NY保全台帳10/Action1.c: "Name=TXT_TNK_KJN_HJN_ID", "Value=27", ENDITEM,
NY保全台帳11/Action1.c: "Name=TXT_TNK_KJN_HJN_ID", "Value=27", ENDITEM,
$
End of FILE.
2003/07/30
ugya@lycos.com