[BACK]
<![CDATA[
------------------------------------------------------ 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 = _leftmenu = [1]
_topmenu = [3]
onoff = [Off]
kind_txt = [교육]; nested exception is org.springframework.dao.InvalidDataAccessApiUsageException: No value supplied for the SQL parameter 'subjno': No value registered for key 'subjno'
------------------------------------------------------ Detail ---------------------------------------------------------------
*** 오류 - GET /offline/apply_ca_view.jsp ***
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 = _leftmenu = [1]
_topmenu = [3]
onoff = [Off]
kind_txt = [교육]; nested exception is org.springframework.dao.InvalidDataAccessApiUsageException: No value supplied for the SQL parameter 'subjno': No value registered for key 'subjno'
--- FORM VALUE ---
--- HTTP HEADER ---
Cache-Control = [max-age=259200]
connection = [keep-alive]
Via = [1.1 squid-proxy-5b96dc6d46-gpvdn (squid/6.13)]
content-length = [0]
accept = [*/*]
host = [edu.ssro.net]
user-agent = [Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)]
X-Forwarded-For = [10.9.234.167]
--- REQUEST ATTRIBUTE ---
IP: 216.73.216.245javax.servlet.forward.request_uri = [/offline/apply_ca_view.jsp]
javax.servlet.forward.context_path = []
javax.servlet.forward.servlet_path = [/offline/apply_ca_view.jsp]
javax.servlet.forward.path_info = [/error/500.jsp]
javax.servlet.error.servlet_name = [jsp]
javax.servlet.error.request_uri = [/offline/apply_ca_view.jsp]
org.springframework.web.context.request.async.WebAsyncManager.WEB_ASYNC_MANAGER = [org.springframework.web.context.request.async.WebAsyncManager@1470bc]
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 = _leftmenu = [1]
_topmenu = [3]
onoff = [Off]
kind_txt = [교육]; 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 = _leftmenu = [1]
_topmenu = [3]
onoff = [Off]
kind_txt = [교육]; 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 = _leftmenu = [1]
_topmenu = [3]
onoff = [Off]
kind_txt = [교육]; 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.apply_005fca_005fview_jsp._jspService(apply_005fca_005fview_jsp.java:135)
- 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.apply_005fca_005fview_jsp._jspService(apply_005fca_005fview_jsp.java:135)
- 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 = _leftmenu = [1]
_topmenu = [3]
onoff = [Off]
kind_txt = [교육]; nested exception is org.springframework.dao.InvalidDataAccessApiUsageException: No value supplied for the SQL parameter 'subjno': No value registered for key 'subjno'
이용에 불편을 드려 죄송합니다.
지금 보신 오류에 대한 모든 내용은 개발자에게 자동 전달 되었으며 신속하게 수정될 수 있도록 노력하겠습니다