The server encountered an internal error () that prevented it from fulfilling this request Name java:comp is not bound ....
HTTP Status 500 -
--------------------------------------------------------------------------------
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
javax.servlet.ServletException: Name java:comp is not bound in this Context
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)
org.apache.jsp.test_jsp._jspService(test_jsp.java:111)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause
javax.naming.NameNotFoundException: Name java:comp is not bound in this Context
org.apache.naming.NamingContext.lookup(NamingContext.java:768)
org.apache.naming.NamingContext.lookup(NamingContext.java:151)
javax.naming.InitialContext.lookup(InitialContext.java:351)
org.apache.jsp.test_jsp._jspService(test_jsp.java:59)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
note The full stack trace of the root cause is available in the Apache Tomcat/5.0.28 logs.
alert으로 한글을 출력하니까 깨지길래 한글관련 설치했는데 갑자기 jdbc가 안되는듯 하네요.
web.xml에 많은 내용이 있었는데 필요없다고 생각되는 부분을 지우기 전에는 404에러가 떠서 아예 파일을 찾을수 없다고 나와서
web.xml에서 web-app 첫머리 부분하고 resource부분만 남겨두고 나니까 jsp파일을 읽어오는데 jdbc (db-pool)을 못읽어오는듯 하네요 어떻게 된건지 모르겠습니다.-_-
소스파일
<%@ page contentType="text/html; charset=euc-kr" language="java" import="java.sql.*, javax.naming.*, javax.sql.*" errorPage="" %>
<%request.setCharacterEncoding("euc-kr");%>
<%
Context initCtx = new InitialContext();
/*
Context envContext = (Context)initContext.lookup("java:/comp/env");
DataSource ds = (DataSource)envContext.lookup("jdbc/web");
*/
DataSource ds = (DataSource)initCtx.lookup("java:comp/env/jdbc/web");
Connection conn = ds.getConnection();
Statement stmt = conn.createStatement();
//PreparedStatement pstmt = null;
int flag = 0;
String id = request.getParameter("id"), password = request.getParameter("password");
String query1 = "select * from members";
//String query2 = "insert into members(id,password) values(" + id + "," + password + ")";
ResultSet rs = stmt.executeQuery(query1);
while(rs.next())
{
if(id.equals(rs.getString(1)))
{
if(password.equals(rs.getString(2)))
{
out.println("<script language=javascript> alert('" + rs.getString(1) + "님께서 로그인 하셨습니다.');</script>");
flag=1;
}
}
}
if(flag==0)
{
out.println("<script language=javascript> alert('아이디없거나 비밀번호가 틀렸습니다.');history.go(-1);</script>");
}
/*pstmt = conn.prepareStatement(query2);
pstmt.executeUpdate();
pstmt.setString(1, id);
pstmt.setString(2, password);
*/
rs.close();
stmt.close();
//pstmt.close();
conn.close();
%>


댓글 달기