엑셀 다운로드.. 되는 계정과 안되는 계정 차이를 모르겠습니다..
[ jsp , js ]
엑셀 다운로드 버튼을 누르면,
<form:form commandName="vnaraExmnnFlntVO" name="vnaraExmnnFlntVO" method="post" action="#">
~~~
</form:form>
form태그의 입력값을 가지고,
document.vnaraExmnnFlntVO.action = "<c:url value='/book/weakFieldListExcel.do'/>";
document.vnaraExmnnFlntVO.submit();
[ java ]
controller에서도 쿼리들을 돌고 돌아
controller 마지막에
excelDownloadView.renderMergedOutputModel(beans, request, response);
---
이클립스 엑셀다운로드 되는 계정의 콘솔창 마지막부분.
93. SELECT DETAIL_CODE AS KEY , CODE_NM AS VALUE FROM COMTCCMMNDETAILCODE WHERE USE_YN = 'Y' AND
CODE_ID = 'COM025' {executed in 2 msec}
2020-11-10 16:56:35 [http-bio-8097-exec-10] DEBUG org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:139) - <== Total: 4
2020-11-10 16:56:39 [http-bio-8097-exec-10] INFO go.forest.mhms.cmm.view.ExcelDownloadView.buildExcelOrgWeakBookList(ExcelDownloadView.java:9238) - ### 취약지역조사야장 엑셀다운로드 : END(2020-11-10 16:56:39:453)
2020-11-10 16:56:44 [http-bio-8097-exec-10] DEBUG go.forest.mhms.cmm.interceptor.CommonInterceptor.postHandle(CommonInterceptor.java:189) - ############################################
2020-11-10 16:56:44 [http-bio-8097-exec-10] DEBUG go.forest.mhms.cmm.interceptor.CommonInterceptor.postHandle(CommonInterceptor.java:190) - # 뷰 (null)
2020-11-10 16:56:44 [http-bio-8097-exec-10] DEBUG go.forest.mhms.cmm.interceptor.CommonInterceptor.postHandle(CommonInterceptor.java:191) - ############################################
---
***
엑셀다운로드 안되는 계정의 콘솔창 마지막부분
356. SELECT DETAIL_CODE AS KEY , CODE_NM AS VALUE FROM COMTCCMMNDETAILCODE WHERE USE_YN = 'Y' AND
CODE_ID = 'COM025' {executed in 1 msec}
2020-11-10 16:45:21 [http-bio-8097-exec-1] DEBUG org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:139) - <== Total: 4
2020-11-10 16:45:29 [http-bio-8097-exec-1] INFO go.forest.mhms.cmm.view.ExcelDownloadView.buildExcelOrgWeakBookList(ExcelDownloadView.java:9238) - ### 취약지역조사야장 엑셀다운로드 : END(2020-11-10 16:45:29:308)
현재 시각 : 202011101650
2020-11-10 16:50:54 [jobScheduler-1] DEBUG go.forest.mhms.cmm.web.SateliteController.createCloudBin(SateliteController.java:82) - /webdata/common/ffas/SaveFiles/coms_mi_le2_cld_cn_202011101645.h5
2020-11-10 16:52:15 [jobScheduler-1] DEBUG go.forest.mhms.cmm.web.SateliteController.createCloudBin(SateliteController.java:83) - file.exists() : false
***
중간중간 쿼리들을 6번쯤 타고..
하나하나 비교해가면서 봐도봐도 모르겠네요..
이럴땐 어떻게 해야하는지 조언 부탁드립니다