글쓴이 :정종민 1999년 10월 09일 10:51:46
윈도우즈 98에 아파이 웹서버 1.3.6을 설치하고
JServ를 1.0을 설치하여 서블릿을 테스트 중입니다.
서블릿에서 간단히 오라클을 접속을 테스트하더중...
다음과 같은 에러가 발생됩니다...
[09/10/1999 10:31:25:680 GMT+09:00] java.lang.UnsatisfiedLinkError: no ocijdbc8 in shared library path
at org.apache.jserv.JServConnection.processRequest(JServConnection.java)
at org.apache.jserv.JServConnection.run(JServConnection.java)
at java.lang.Thread.run(Thread.java:466)
프로그램의 소스는 jserv설치 데모로 설치된
IsItWorking을 jdbc예제를 추가해서
오라클 접속을 단순히 테스트하기 위한 프로그램입니다.
에러 원인좀 찾아주세요....
public class IsItWorking extends HttpServlet {
public static final String TITLE = "Yes, It's working!";
int count = 0;
public void service (HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException
{
// set content type and other response header fields first
response.setContentType("text/html");
// get the communication channel with the requesting client
PrintWriter out = response.getWriter();
// get the server identification
String server = getServletConfig().getServletContext().getServerInfo();
count++;
// write the data
out.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 3.2//EN\">"
+ "<HTML>"
+ "<HEAD>"
+ " <TITLE>" + TITLE + "</TITLE>"
+ " <META NAME=\"Author\" CONTENT=\"" + server + "\">"
+ "</HEAD>"
+ "<BODY BGCOLOR=\"#FFFFFF\">"
+ " <CENTER>"
+ " <IMG SRC=\"/jserv/status?image\" BORDER=\"0\">"
+ " <H1>" + TITLE + "</H1>" + count
+ " <H2>Congratulations, " + server + " is working!</H2>"
+ " <FONT SIZE=\"-1\">Copyright (c) 1997-99"
+ " <A HREF=\"http://java.apache.org/\">The Java Apache Project</a><br>"
+ " All rights reserved.</FONT>"
+ " </CENTER>"
+ "</BODY>"
+ "</HTML>");
try
{
// Load the Oracle JDBC driver
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
// Connect to the database
// You can put a database name after the @ sign in the connection URL.
Connection conn =
DriverManager.getConnection ("jdbc:oracle:oci8:@KFOOD", "scott", "tiger");
// Create a Statement
Statement stmt = conn.createStatement ();
// Select the ENAME column from the EMP table
ResultSet rset = stmt.executeQuery ("select ENAME from EMP");
// Iterate through the result and print the employee names
while (rset.next ())
System.out.println (rset.getString (1));
// Close the RseultSet
rset.close();
// Close the Statement
stmt.close();
// Close the connection
conn.close();
}
catch(SQLException exc)
{
}
}
}