[BACK]
------------------------------------------------------ Error Message ------------------------------------------------------
crossd.util.DbAccessException: °úÁ¤Á¤º¸Á¶È¸, query = select * , case when status = 'Close' then 'Á¢¼ö¸¶°¨(°ü¸®ÀÚ ÁöÁ¤)' when date_format(now(), '%Y-%m-%d') < applystartday then 'Á¢¼öÀü' when date_format(now(), '%Y-%m-%d') > applyendday then 'Á¢¼ö¸¶°¨' else 'Á¢¼öÁß' end realstatus from subjectcode where no = :subjno, map = amp;onoff = [Off]
_leftmenu = [1]
_topmenu = [3]
onoff = [Off]
amp;pageNo = [1]
amp;kind = [job]
amp;subjno = [480]
kind_txt = [±³À°]
listSize = [10]; nested exception is org.springframework.dao.InvalidDataAccessApiUsageException: No value supplied for the SQL parameter 'subjno': No value registered for key 'subjno'
------------------------------------------------------ Detail ---------------------------------------------------------------
*** ¿À·ù - GET /offline/edu_view.jsp?listSize=10&pageNo=1&onoff=Off&kind=job&subjno=480 ***
MESSAGE : crossd.util.DbAccessException: °úÁ¤Á¤º¸Á¶È¸, query = select * , case when status = 'Close' then 'Á¢¼ö¸¶°¨(°ü¸®ÀÚ ÁöÁ¤)' when date_format(now(), '%Y-%m-%d') < applystartday then 'Á¢¼öÀü' when date_format(now(), '%Y-%m-%d') > applyendday then 'Á¢¼ö¸¶°¨' else 'Á¢¼öÁß' end realstatus from subjectcode where no = :subjno, map = amp;onoff = [Off]
_leftmenu = [1]
_topmenu = [3]
onoff = [Off]
amp;pageNo = [1]
amp;kind = [job]
amp;subjno = [480]
kind_txt = [±³À°]
listSize = [10]; nested exception is org.springframework.dao.InvalidDataAccessApiUsageException: No value supplied for the SQL parameter 'subjno': No value registered for key 'subjno'
--- FORM VALUE ---
amp;onoff = [Off]
amp;pageNo = [1]
amp;kind = [job]
amp;subjno = [480]
listSize = [10]
--- HTTP HEADER ---
content-length = [0]
accept = [*/*]
host = [edu.ssro.net]
user-agent = [claudebot]
--- REQUEST ATTRIBUTE ---
IP: 35.170.81.62javax.servlet.forward.request_uri = [/offline/edu_view.jsp]
javax.servlet.forward.context_path = []
javax.servlet.forward.servlet_path = [/offline/edu_view.jsp]
javax.servlet.forward.path_info = [/error/500.jsp]
javax.servlet.forward.query_string = [listSize=10&pageNo=1&onoff=Off&kind=job&subjno=480]
javax.servlet.error.servlet_name = [jsp]
javax.servlet.error.request_uri = [/offline/edu_view.jsp]
org.springframework.web.context.request.async.WebAsyncManager.WEB_ASYNC_MANAGER = [org.springframework.web.context.request.async.WebAsyncManager@cfefe2]
javax.servlet.error.message = []
javax.servlet.error.status_code = [500]
__sitemesh__filterapplied = [true]
javax.servlet.error.exception = [org.apache.jasper.JasperException: crossd.util.DbAccessException: °úÁ¤Á¤º¸Á¶È¸, query = select * , case when status = 'Close' then 'Á¢¼ö¸¶°¨(°ü¸®ÀÚ ÁöÁ¤)' when date_format(now(), '%Y-%m-%d') < applystartday then 'Á¢¼öÀü' when date_format(now(), '%Y-%m-%d') > applyendday then 'Á¢¼ö¸¶°¨' else 'Á¢¼öÁß' end realstatus from subjectcode where no = :subjno, map = amp;onoff = [Off]
_leftmenu = [1]
_topmenu = [3]
onoff = [Off]
amp;pageNo = [1]
amp;kind = [job]
amp;subjno = [480]
kind_txt = [±³À°]
listSize = [10]; nested exception is org.springframework.dao.InvalidDataAccessApiUsageException: No value supplied for the SQL parameter 'subjno': No value registered for key 'subjno']
--- SESSION ATTRIBUTE ---
--- STACK TRACE ---
org.apache.jasper.JasperException: crossd.util.DbAccessException: °úÁ¤Á¤º¸Á¶È¸, query = select * , case when status = 'Close' then 'Á¢¼ö¸¶°¨(°ü¸®ÀÚ ÁöÁ¤)' when date_format(now(), '%Y-%m-%d') < applystartday then 'Á¢¼öÀü' when date_format(now(), '%Y-%m-%d') > applyendday then 'Á¢¼ö¸¶°¨' else 'Á¢¼öÁß' end realstatus from subjectcode where no = :subjno, map = amp;onoff = [Off]
_leftmenu = [1]
_topmenu = [3]
onoff = [Off]
amp;pageNo = [1]
amp;kind = [job]
amp;subjno = [480]
kind_txt = [±³À°]
listSize = [10]; nested exception is org.springframework.dao.InvalidDataAccessApiUsageException: No value supplied for the SQL parameter 'subjno': No value registered for key 'subjno'
- org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:502)
- org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:430)
- org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
- org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
- javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
- org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
- org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
- com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:119)
- com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:55)
- org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
- org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
- org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
- org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
- org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
- org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
- org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
- org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
- org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
- org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
- org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:615)
- org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
- org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
- org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:448)
- org.apache.coyote.ajp.AjpAprProtocol$AjpConnectionHandler.process(AjpAprProtocol.java:399)
- org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1675)
- java.lang.Thread.run(Thread.java:662)
crossd.util.DbAccessException: °úÁ¤Á¤º¸Á¶È¸, query = select * , case when status = 'Close' then 'Á¢¼ö¸¶°¨(°ü¸®ÀÚ ÁöÁ¤)' when date_format(now(), '%Y-%m-%d') < applystartday then 'Á¢¼öÀü' when date_format(now(), '%Y-%m-%d') > applyendday then 'Á¢¼ö¸¶°¨' else 'Á¢¼öÁß' end realstatus from subjectcode where no = :subjno, map = amp;onoff = [Off]
_leftmenu = [1]
_topmenu = [3]
onoff = [Off]
amp;pageNo = [1]
amp;kind = [job]
amp;subjno = [480]
kind_txt = [±³À°]
listSize = [10]; nested exception is org.springframework.dao.InvalidDataAccessApiUsageException: No value supplied for the SQL parameter 'subjno': No value registered for key 'subjno'
- crossd.util.DbUtils.queryForMap(DbUtils.java:94)
- crossd.util.WCmd.queryForMap(WCmd.java:144)
- org.apache.jsp.offline.edu_005fview_jsp._jspService(edu_005fview_jsp.java:139)
- org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
- javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
- org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:388)
- org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
- org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
- javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
- org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
- org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
- com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:119)
- com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:55)
- org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
- org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
- org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
- org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
- org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
- org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
- org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
- org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
- org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
- org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
- org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:615)
- org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
- org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
- org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:448)
- org.apache.coyote.ajp.AjpAprProtocol$AjpConnectionHandler.process(AjpAprProtocol.java:399)
- org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1675)
- java.lang.Thread.run(Thread.java:662)
org.springframework.dao.InvalidDataAccessApiUsageException: No value supplied for the SQL parameter 'subjno': No value registered for key 'subjno'
- org.springframework.jdbc.core.namedparam.NamedParameterUtils.buildValueArray(NamedParameterUtils.java:335)
- org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.getPreparedStatementCreator(NamedParameterJdbcTemplate.java:337)
- org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.queryForObject(NamedParameterJdbcTemplate.java:195)
- org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.queryForObject(NamedParameterJdbcTemplate.java:202)
- org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.queryForMap(NamedParameterJdbcTemplate.java:222)
- org.springframework.jdbc.core.simple.SimpleJdbcTemplate.queryForMap(SimpleJdbcTemplate.java:213)
- crossd.util.DbUtils.queryForMap(DbUtils.java:90)
- crossd.util.WCmd.queryForMap(WCmd.java:144)
- org.apache.jsp.offline.edu_005fview_jsp._jspService(edu_005fview_jsp.java:139)
- org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
- javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
- org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:388)
- org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
- org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
- javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
- org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
- org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
- com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:119)
- com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:55)
- org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
- org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
- org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
- org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
- org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
- org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
- org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
- org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
- org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
- org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
- org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:615)
- org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
- org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
- org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:448)
- org.apache.coyote.ajp.AjpAprProtocol$AjpConnectionHandler.process(AjpAprProtocol.java:399)
- org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1675)
- java.lang.Thread.run(Thread.java:662)
---------------------------------------------------------------------------------------------------------------------------
crossd.util.DbAccessException: °úÁ¤Á¤º¸Á¶È¸, query = select * , case when status = 'Close' then 'Á¢¼ö¸¶°¨(°ü¸®ÀÚ ÁöÁ¤)' when date_format(now(), '%Y-%m-%d') < applystartday then 'Á¢¼öÀü' when date_format(now(), '%Y-%m-%d') > applyendday then 'Á¢¼ö¸¶°¨' else 'Á¢¼öÁß' end realstatus from subjectcode where no = :subjno, map = amp;onoff = [Off]
_leftmenu = [1]
_topmenu = [3]
onoff = [Off]
amp;pageNo = [1]
amp;kind = [job]
amp;subjno = [480]
kind_txt = [±³À°]
listSize = [10]; nested exception is org.springframework.dao.InvalidDataAccessApiUsageException: No value supplied for the SQL parameter 'subjno': No value registered for key 'subjno'
ÀÌ¿ë¿¡ ºÒÆíÀ» µå·Á Á˼ÛÇÕ´Ï´Ù.
Áö±Ý º¸½Å ¿À·ù¿¡ ´ëÇÑ ¸ðµç ³»¿ëÀº °³¹ßÀÚ¿¡°Ô ÀÚµ¿ Àü´Þ µÇ¾úÀ¸¸ç ½Å¼ÓÇÏ°Ô ¼öÁ¤µÉ ¼ö ÀÖµµ·Ï ³ë·ÂÇÏ°Ú½À´Ï´Ù