글쓴이 :이경화 1999년 3월 25일 14:50:14
*** Source는 아래와 같습니다.***
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Connection;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
public class JdbcCon1 extends HttpServlet
{
Connection con;
Statement stmt;
public void init(ServletConfig config) throws ServletException {
super.init(config);
}
public void doGet(HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException {
res.setContentType("text/html");
PrintWriter out;
out = new PrintWriter(new OutputStreamWriter(res.getOutputStream(), "KSC5601"));
out.println("<html><body>");
try{
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
con = DriverManager.getConnection ("jdbc:oracle:thin:@130.1.1.1:1521:ora1",
"yousr", "yousr");
stmt = con.createStatement();
} catch(Exception e) {
out.println("<p>Oracle JDBC Thin Driver load faild....<p>");
}
out.println("<p>The End</p>");
out.println("</BODY></HTML>");
out.flush();
out.close();
}
public String getServletInfo() {
return "sampleServlet Information";
}
}
결과는 아래와 같은 에러가 발생합니다.
'''
500 Internal Server Error
JdbcCon1:
java.lang.NoClassDefFoundError: oracle/jdbc/driver/OracleDriver
'''
참고(저의 컴퓨터 환경입니다!)
OS : NT4.0
Web Server : IIS4.0
Servler Engine : JRUN : 2.3
Java Development Tools : JDK1.2, JSDK2.0, JDBC-Thin(Oracle)
path와 classpath는 정상적으로 표기한 것 같습니다.
아래와 같은 어플리케이션은 정상적으로 실행됩니다.
import java.sql.*;
class JdbcTest {
public static void main (String args []) throws SQLException {
DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver());
Connection conn = DriverManager.getConnection
("jdbc:oracle:thin:@130.1.1.1:1521:ora1","yousr", "yousr");
Statement stmt = conn.createStatement ();
ResultSet rset = stmt.executeQuery ("select name from tblhuman");
while (rset.next ())
System.out.println (rset.getString (1));
}
}