글쓴이 :손지영 2000년 2월 16일 11:23:50
아래는 jsp소스와 에러메세지입니다.
어디가 잘못되어서 이럴까요?
<%@ page language="java" import="java.sql.*,java.io.*" %>
<%
java.sql.Connection conn =null;
java.sql.PreparedStatement ps =null;
java.sql.ResultSet rs = null;
String Stmt = null;
String strRet = null;
try{
Class.forName("oracle.jdbc.driver.oracleDriver");
}catch(ClassNotFoundException e){
out.println(e);
}
try{
conn = DriverManager.getConnection("jdbc:oracle:thin:@128.134.192.39:1521:ORCL","scott","tiger");
}catch(java.sql.SQLException ee){
out.println(ee);
}
try{
ps=conn.prepareStatement("select * from mile");
rs=ps.executeQuery();
int i=1;
while(rs.next()){
strRet = rs.getString("id");
out.println("name"+i+": "+strRet+"<br>");
i++;
}
rs.close();
ps.close();
conn.close();
}catch(java.sql.SQLException ef){
out.println(ef);
}catch(java.io.UnsupportedEncodingException eg){
out.println(eg);
}
%>
Error during JSP page processing
java.lang.NullPointerException
at pagecompile.jsp._m__corr._sqldb._jspService(Compiled Code)
at com.sun.server.http.pagecompile.jsp.runtime.HttpJspBase.service(HttpJspBase.java:87)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:840)
at com.sun.server.http.pagecompile.jsp.runtime.JspServlet.runServlet(JspServlet.java:469)
at com.sun.server.http.pagecompile.jsp.runtime.JspServlet.processJspPage(JspServlet.java:259)
at com.sun.server.http.pagecompile.jsp.runtime.JspServlet.service(JspServlet.java:97)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:840)
at com.sun.server.ServletState.callService(ServletState.java:226)
at com.sun.server.ServletManager.callServletService(ServletManager.java:936)
at com.sun.server.ProcessingState.invokeTargetServlet(ProcessingState.java:423)
at com.sun.server.http.HttpProcessingState.execute(HttpProcessingState.java:79)
at com.sun.server.http.stages.Runner.process(Runner.java:79)
at com.sun.server.ProcessingSupport.process(Compiled Code)
at com.sun.server.Service.process(Service.java:204)
at com.sun.server.http.HttpServiceHandler.handleRequest(HttpServiceHandler.java:374)
at com.sun.server.http.HttpServiceHandler.handleRequest(Compiled Code)
at com.sun.server.HandlerThread.run(Compiled Code)