Need a unique gift idea?
A Pastebin account makes a great Christmas gift
SHARE
TWEET

Untitled

a guest Nov 14th, 2018 86 Never
Upgrade to PRO!
ENDING IN00days00hours00mins00secs
 
  1. path : -1
  2. ****** doFilter!!!!!!!!!!!!!!!!!!!
  3. 2018-11-15 10:52:56,949 DEBUG [com.isu.ifm.wrapper.RequestWrapper::<init>:85] URI : /ifm/Board.do
  4. 2018-11-15 10:52:56,949 DEBUG [com.isu.ifm.wrapper.RequestWrapper::<init>:86] METHOD : GET
  5. 2018-11-15 10:52:56,950 DEBUG [com.isu.ifm.wrapper.RequestWrapper::<init>:126] PARAM : comments : [a]
  6. enterCd : [ISU_PS]
  7. bbsCd : [10003]
  8. bbsSeq : [1]
  9. cmd : [saveCmt]
  10. sabun : [91006]
  11.  
  12. preHandler ::::::::::::::http://localhost:8083/ifm/Board.do
  13. ISU_PS
  14. 91006
  15. preHandler ::::::::::::::/ifm/Board.do
  16. [2018-11-15 10:52:56] [DEBUG]『org.apache.commons.dbcp.PoolingDataSource:getConnection(106)』 Elapsed Time [0:00:00.007]
  17.  
  18.     select
  19.         1
  20.     from
  21.         dual
  22.  
  23.  
  24. [2018-11-15 10:52:56] [DEBUG]『org.springframework.jdbc.core.JdbcTemplate:execute(644)』 Elapsed Time [0:00:00.023]
  25.  
  26.  
  27.                         INSERT INTO TSYS730(ENTER_CD, SABUN, BBS_SEQ, COMMENTS_SEQ, COMMENTS, CHKDATE, CHKID, BBS_CD)
  28.                         VALUES( 'ISU_PS' /**PARAM*/,  '91006' /**PARAM*/,  '1' /**PARAM*/, BOARD_COMTSEQ.nextval,  'a' /**PARAM*/, sysdate,  '91006' /**PARAM*/,  '10003' /**PARAM*/)
  29.  
  30.  
  31.  
  32. Query Result[INSERT]: 1row
  33.  
  34. 2018-11-15 10:52:56,984 DEBUG [com.isu.ifm.wrapper.ResponseWrapper::toByteArray:95] RETURN VALUE : {"message":"","map":{"comments":"a","enterCd":"ISU_PS","bbsCd":"10003","bbsSeq":"1","cmd":"saveCmt","sabun":"91006","ssnEnterCd":"ISU_PS","ssnSabun":"91006"},"code":1}
  35.    
  36. 2018-11-15 10:49:19,669 DEBUG [com.isu.dao.Dao::getList:48] ┌────────────────── getCmtList Result List Start────────────────────────
  37. 2018-11-15 10:49:19,670 DEBUG [com.isu.dao.Dao::getList:74] └────────────────── getCmtList Result List End──────────────────────────
  38.  
  39. MockHttpServletRequest:
  40.          HTTP Method = GET
  41.          Request URI = /Board.do
  42.           Parameters = {cmd=[getCmtList], enterCd=[ISU_PS], sabun=[91006], bbsCd=[10001], bbsSeq=[1]}
  43.              Headers = {}
  44.  
  45.              Handler:
  46.                 Type = com.isu.ifm.controller.BoardController
  47.               Method = public org.springframework.web.servlet.ModelAndView com.isu.ifm.controller.BoardController.getCmtList(javax.servlet.http.HttpSession,javax.servlet.http.HttpServletRequest,java.util.Map<java.lang.String, java.lang.Object>) throws java.lang.Exception
  48.  
  49.                Async:
  50.        Async started = false
  51.         Async result = null
  52.  
  53.   Resolved Exception:
  54.                 Type = null
  55.  
  56.         ModelAndView:
  57.            View name = jsonView
  58.                 View = null
  59.            Attribute = DATA
  60.                value = []
  61.            Attribute = Message
  62.                value =
  63.  
  64.             FlashMap:
  65.  
  66. MockHttpServletResponse:
  67.               Status = 200
  68.        Error message = null
  69.              Headers = {}
  70.         Content type = null
  71.                 Body =
  72.        Forwarded URL = jsonView
  73.       Redirected URL = null
  74.              Cookies = []
  75. 2018-11-15 10:49:19,706  INFO [org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter::initControllerAdviceCache:517] Looking for @ControllerAdvice: org.springframework.test.web.servlet.setup.StubWebApplicationContext@39c1fe0b
  76. 2018-11-15 10:49:19,753 ERROR [org.anyframe.query.QueryService::processException:1889] Query Service : Fail to [update [query id = 'saveCmt'],
  77.  
  78.                         INSERT INTO TSYS730(ENTER_CD, SABUN, BBS_SEQ, COMMENTS_SEQ, COMMENTS, CHKDATE, CHKID, BBS_CD)
  79.                         VALUES(:ssnEnterCd, :ssnSabun, :bbsSeq, BOARD_COMTSEQ.nextval, :comments, sysdate, :ssnSabun, :bbsCd)
  80.  
  81.  
  82.             , PreparedStatementCallback; SQL [
  83.  
  84.                         INSERT INTO TSYS730(ENTER_CD, SABUN, BBS_SEQ, COMMENTS_SEQ, COMMENTS, CHKDATE, CHKID, BBS_CD)
  85.                         VALUES(?, ?, ?, BOARD_COMTSEQ.nextval, ?, sysdate, ?, ?)
  86.  
  87.  
  88.             ]; ORA-01400: cannot insert NULL in ("EHR_ISU4"."TSYS730"."ENTER_CD")
  89. ; nested exception is java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL in ("EHR_ISU4"."TSYS730"."ENTER_CD")
  90. ].
  91.  Query = [org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [
  92.  
  93.                         INSERT INTO TSYS730(ENTER_CD, SABUN, BBS_SEQ, COMMENTS_SEQ, COMMENTS, CHKDATE, CHKID, BBS_CD)
  94.                         VALUES(?, ?, ?, BOARD_COMTSEQ.nextval, ?, sysdate, ?, ?)
  95.  
  96.  
  97.             ]; ORA-01400: cannot insert NULL in ("EHR_ISU4"."TSYS730"."ENTER_CD")
  98. ; nested exception is java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL in ("EHR_ISU4"."TSYS730"."ENTER_CD")
  99. ]
  100.  Reason = [{}].
  101.  
  102. MockHttpServletRequest:
  103.          HTTP Method = GET
  104.          Request URI = /Board.do
  105.           Parameters = {cmd=[saveCmt], enterCd=[ISU_PS], sabun=[91006], bbsCd=[10001], bbsSeq=[1], comments=[a]}
  106.              Headers = {}
  107.  
  108.              Handler:
  109.                 Type = com.isu.ifm.controller.BoardController
  110.               Method = public org.springframework.web.servlet.ModelAndView com.isu.ifm.controller.BoardController.saveCmt(javax.servlet.http.HttpSession,javax.servlet.http.HttpServletRequest,java.util.Map<java.lang.String, java.lang.Object>) throws java.lang.Exception
  111.  
  112.                Async:
  113.        Async started = false
  114.         Async result = null
  115.  
  116.   Resolved Exception:
  117.                 Type = null
  118.  
  119.         ModelAndView:
  120.            View name = jsonView
  121.                 View = null
  122.            Attribute = code
  123.                value = -1
  124.            Attribute = message
  125.                value = fail
  126.            Attribute = map
  127.                value = {cmd=saveCmt, enterCd=ISU_PS, sabun=91006, bbsCd=10001, bbsSeq=1, comments=a, ssnEnterCd=null, ssnSabun=null}
  128.  
  129.             FlashMap:
  130.  
  131. MockHttpServletResponse:
  132.               Status = 200
  133.        Error message = null
  134.              Headers = {}
  135.         Content type = null
  136.                 Body =
  137.        Forwarded URL = jsonView
  138.       Redirected URL = null
  139.              Cookies = []
  140. 2018-11-15 10:49:19,788  INFO [org.springframework.context.support.GenericApplicationContext::doClose:862] Closing org.springframework.context.support.GenericApplicationContext@9660f4e: startup date [Thu Nov 15 10:49:14 KST 2018]; root of context hierarchy
  141.    
  142. public MockMvc mockMvc;
  143.  
  144. public void testGetMethod_param(String url, UnaryOperator<MockHttpServletRequestBuilder> operator)
  145.             throws Exception {
  146.         mockMvc.perform(operator.apply(get(url))).andDo(print()).andExpect(status().isOk());
  147.     }
  148.  
  149.  
  150.  
  151.  
  152.  @ContextConfiguration("file:src/main/webapp/WEB-INF/**/*.xml")
  153. public class BoardControllerTest extends HttpRequestTestMethod implements CoreParameters, AdapterServiceParameters{
  154.  
  155.     @Autowired
  156.     public BoardController boardController;
  157.  
  158.  
  159.     @Before
  160.     public void setUp() throws Exception {
  161.         mockMvc = MockMvcBuilders.standaloneSetup(boardController).build();
  162.     }
  163.     @Test
  164.     public void savecmt() throws Exception {
  165.         testGetMethod_param("/Board.do", builder->builder
  166.                 .param("cmd", "saveCmt")
  167.                 .param("enterCd", enterCd)
  168.                 .param("sabun", sabun)
  169.                 .param("bbsCd", bbsCd)
  170.                 .param("bbsSeq", bbsSeq)
  171.                 .param("comments", comments));
  172.     }
  173.    
  174. [2018-11-15 11:06:02] [ERROR]『oracle.jdbc.driver.T4CTTIoer:processError(439)』
  175. java.sql.SQLIntegrityConstraintViolationException
  176.  
  177.  
  178.                         INSERT INTO TSYS730(ENTER_CD, SABUN, BBS_SEQ, COMMENTS_SEQ, COMMENTS, CHKDATE, CHKID, BBS_CD)
  179.                         VALUES( null /**PARAM*/,  '91006' /**PARAM*/,  '1' /**PARAM*/, BOARD_COMTSEQ.nextval,  'a' /**PARAM*/, sysdate,  '91006' /**PARAM*/,  '10003' /**PARAM*/)
  180.  
  181.  
  182.  
  183. ORA-01400: cannot insert Null in ("EHR_ISU4"."TSYS730"."ENTER_CD")
  184.    
  185. Query = [org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [
  186.  
  187.                         INSERT INTO TSYS730(ENTER_CD, SABUN, BBS_SEQ, COMMENTS_SEQ, COMMENTS, CHKDATE, CHKID, BBS_CD)
  188.                         VALUES(?, ?, ?, BOARD_COMTSEQ.nextval, ?, sysdate, ?, ?)
  189.  
  190.  
  191.             ]; ORA-01400: cannot insert Null in ("EHR_ISU4"."TSYS730"."ENTER_CD")
  192. ; nested exception is java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert Null in ("EHR_ISU4"."TSYS730"."ENTER_CD")
  193. ]
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top