Software, Support, Documentation
|
|
News,
Internal,
Projects,
Home Software, Support, Documentation |
apache : 1.3.27
java : 1.4.1_01
tomcat : 3.3.1
mysql : 3.23.54
jdbc driver : mysql-connector-java-3.0.9-stable-bin.jar
포트로 j2sdk1.4.1_01,tomcat3.3.1을 설치한 후 jdbc driver가
연결되지 않네요... 죽어라 안붙어요...
8080으로 디폴트페이지(고양이)는 잘 보입니다. jsp, servlet도 잘 보이고요...
jdbc connection test 페이지에서...
private String driver = "org.gjt.mm.mysql.Driver";
Class.forName(driver);
여기서 드라이버를 찾지를 못하네요...
뭐가 문제인지... 원인을 모르겠습니다.
올해 4-5월쯤에 RH8에서 똑같은 환경을 테스트를 해봤을때는
전혀문제없이 연결되었는데... FreeBSD5.0에서는 쉽게 되지 않네요...
제발 좀 되었으면 좋겠어요...
>>>>> /etc/profile
JAVA_HOME=/usr/local/linux-sun-jdk1.4.1
TOMCAT_HOME=/usr/local/jakarta-tomcat3.3
CLASSPATH=/usr/local/linux-sun-jdk1.4.1/jre/lib/rt.jar
CLASSPATH=$CLASSPATH:/usr/local/linux-sun-jdk1.4.1/lib/mysql-connector-java-3.0.9-stabl
e-bin.jar
CLASSPATH=$CLASSPATH:/usr/local/jakarta-tomcat3.3/lib/common/servlet.jar
#CLASSPATH=$CLASSPATH:/usr/local/jakarta-tomcat3.3/lib/mm.mysql.jdbc
#CLASSPATH=$CLASSPATH:/usr/local/jakarta-tomcat3.3/lib/mysql-connector-java-3.0.9-stabl
e-bin.jar
CLASSPATH=$CLASSPATH:.
export JAVA_HOME TOMCAT_HOME CLASSPATH
=========================================
>>>>>>>>>>>>>>>>> httpd.conf (마지막줄 추가)
include /usr/local/jakarta-tomcat3.3/conf/jk/mod_jk.conf
include /usr/local/jakarta-tomcat3.3/conf/jserv/tomcat.conf
>>>>>>>>>>>>>>>>> mod_jk.so
이건 톰캣/native/mod_jk에서 직접 컴파일 했고요...
/usr/local/libexec/apache 에 잘 들어있고요...
>>>>>>>>>>>>>>>>> jdbc_test.jsp
<%@ page contentType="text/html;
charset=euc-kr" import="java.sql.*"
%>
<%!
private String driver = "org.gjt.mm.mysql.Driver";
private String user = "linuk2";
private String pass = "dmgm";
private String dbURL = "jdbc:mysql://localhost:3306/test";
private String sql = "Select * from guest";
private Connection connection ;
private Statement stmt;
private ResultSet result;
private String id;
private String name;
private String comment;
%>
<html>
<style type="text/css">td {font-size:9pt}</style>
<body><p> </p><center><font color="darkblue">스타크래프트 유닛</font>
</center><br>
<table width="60%" border="1" bordercolor="#A0BCFF" align="center">
<tr bgcolor="#0054A8">
<td> <div align="center"><font color="#FFFFFF">ID </font></div></td>
<td> <div align="center"><font color="#FFFFFF">유닛명 </font></div></td>
<td> <div align="center"><font color="#FFFFFF">가격 </font></div></td></tr>
<%
try{
Class.forName(driver);
connection = DriverManager.getConnection(dbURL, user, pass);
out.println("3");
stmt = connection.createStatement();
out.println("4");
result = stmt.executeQuery(sql);
out.println("5");
while(result.next()){
id = result.getString("id");
name = result.getString("name");
comment = result.getString("comment");
%> <tr bgcolor="#9BBCFF"> <td> <div align="center"><font
color="#000000"><%= id
%> </font></div></td><td>
<div align="center"><font color="#000000"><%= name %>
</font></div></td><td>
<div align="center"><font color="#000000"><%= comment %>
</font></div></td></tr
><%}
}
catch(SQLException se)
{
out.println("sql error");
}
catch(ClassNotFoundException cne)
{out.println("jdbc driver not founded!");}
%>
</table>
</body>
</html>
_______________________________________________
한국 FreeBSD 사용자 그룹(KFUG) questions 메일링 리스트
questions at kr.FreeBSD.org
http://www.kr.FreeBSD.org/mailman/listinfo/questions
|
Copyright © 1998-2005 Korea FreeBSD Users Group. All rights reserved. webmaster at kr.FreeBSD.org $Date: 2003/11/11 07:30:40 $ |
|