[JSP] 자바 빈즈로 디비 연결시 가끔나는 500 Internal server error ORA-17009 용-ILE/LANG-JAVA(JSP)2008. 5. 15. 20:26
http://suite.tistory.com/ fs 2007 12
환경 : 오라클 10G
was: jeus 5
jsp jdbc 디비연결 모듈을 자바 빈즈로 두고 사용하다가 가끔 아래와 같은 500 Internal server error 에러를 내보낸다.
몇가지 테스트를 하다보니
userBean 옵션중에 scope를 "request"로 변경하니 에러가 완전 사라짐
ex ) <jsp:useBean id="DBC_BEAN" class="fs_pkg.DBClass" scope="session"/>
변경 => <jsp:useBean id="DBC_BEAN" class="fs_pkg.DBClass" scope="request"/>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
?? ??: next
error dump javax.servlet.ServletException: ?? ??: next
at jeus.servlet.jsp2.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:859)
at jeus.servlet.jsp2.runtime.PageContextImpl.handlePageException(PageContextImpl.java:789)
at jeus_jspwork._srch_5fmgr._klaw_5finfo._500_left_5fbottom_5fjsp._jspService(_500_left_5fbottom_5fjsp.java:635)
at jeus.servlet.jsp.HttpJspBase.service(HttpJspBase.java:53)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at jeus.servlet.jsp.JspServletWrapper.executeServlet(JspServletWrapper.java:94)
at jeus.servlet.engine.ServletWrapper.execute(ServletWrapper.java:213)
at jeus.servlet.jsp.JspServletWrapper.execute(JspServletWrapper.java:140)
at jeus.servlet.engine.WebtobRequestProcessor.run(WebtobRequestProcessor.java:185)
root cause java.sql.SQLException: ?? ??: next
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:1130)
at oracle.jdbc.driver.OracleResultSetImpl.next(OracleResultSetImpl.java:202)
at jeus_jspwork._srch_5fmgr._klaw_5finfo._500_left_5fbottom_5fjsp._jspService(_500_left_5fbottom_5fjsp.java:440)
at jeus.servlet.jsp.HttpJspBase.service(HttpJspBase.java:53)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at jeus.servlet.jsp.JspServletWrapper.executeServlet(JspServletWrapper.java:94)
at jeus.servlet.engine.ServletWrapper.execute(ServletWrapper.java:213)
at jeus.servlet.jsp.JspServletWrapper.execute(JspServletWrapper.java:140)
at jeus.servlet.engine.WebtobRequestProcessor.run(WebtobRequestProcessor.java:185)
|
Closed Statement
Ora 17009
|
Closed Statement
'용-ILE > LANG-JAVA(JSP)' 카테고리의 다른 글
JSP XML DOM 파서 활용 예제 (0) | 2008.07.06 |
---|---|
[JSP] http URL 텍스트 -> 스트링으로 (0) | 2008.05.15 |
[ JSP ] - 톰켓 한글 파일 이름 다운로드 인코딩 문제 (0) | 2008.05.15 |
[JSP] - weblogic 웹로직 재 시작 ( Redeploy ) (0) | 2008.05.15 |
[ JSP ] C sprintf 와 같은 String.format 사용 예제 (0) | 2008.05.15 |