linux에서 jdbc를 연동할려고 합니다.
저의 환경은 다음과 같습니다.
mysql_3.23.39//jdk1.2.2//apache_1.3.12
님의 강좌에서 도움을 받아 mysql과 jdbc를 설치했습니다...
(CLASSPATH에서 classes.zip파일이 없어졌는데요..파일좀 올려주세요.ㅠ.
ㅠ;
mm.mysql-2.0.2-bin.jar 파일은 jdk(=java)폴더 밑에 jdbc폴더 아래에
넣어 났습니다. 소스도 만들어서 테스트를 해봤습니다.
그런데... 500 error가 나타납니다.(에러 메세지는 밑에 있습니다.)
이것 땜에 하루종일 아니 이틀째 고생하고 있슴다...너무 쉬운거 같은데
잘 안되는군요...
님의 답변 부탁드립니다.
****** profile은 패스는 다음과 같이 추가했습니다. *******************
export PATH="$PATH:/usr/local/java/bin"
export PATH USER LOGNAME MAIL HOSTNAME HISTSIZE INPUTRC
export JAVA_HOME="usr/local;/java"
export
CLASSPATH="./:$CLASSPATH:$JAVA_HOME/jdbc/classes.zip:$JAVA_HOME/jdbc/mm
.mysql-2.0.2-bin.jar"
export TOMCAT_HOME="usr/local/jakarta"
********************************************************************
Error: 500
Location:/test.jsp
Internal Servlet Error:
javax.servlet.ServletException: Unable to load class
org.git.mm.mysql.Driver
at org.apache.jasper.runtime.PageContextImpl.handlePageException
(PageContextImpl.java:459)
at _0002ftest_0002ejsptest_jsp_2._jspService
(_0002ftest_0002ejsptest_jsp_2.java:82)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServlet$JspCountedServlet.service
(JspServlet.java:130)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service
(JspServlet.java:282)
at org.apache.jasper.servlet.JspServlet.serviceJspFile
(JspServlet.java:429)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:500)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.tomcat.core.ServletWrapper.doService
(ServletWrapper.java:405)
at org.apache.tomcat.core.Handler.service(Handler.java:287)
at org.apache.tomcat.core.ServletWrapper.service
(ServletWrapper.java:372)
at org.apache.tomcat.core.ContextManager.internalService
(ContextManager.java:797)
at org.apache.tomcat.core.ContextManager.service
(ContextManager.java:743)
at
org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConne
ction(Ajp12ConnectionHandler.java:166)
at org.apache.tomcat.service.TcpWorkerThread.runIt
(PoolTcpEndpoint.java:416)
at org.apache.tomcat.util.ThreadPool$ControlRunnable.run
(ThreadPool.java:501)
at java.lang.Thread.run(Thread.java:479)
Root cause:
java.lang.ClassNotFoundException: Unable to load class
org.git.mm.mysql.Driver
at org.apache.jasper.servlet.JasperLoader.findClass
(JasperLoader.java:223)
at org.apache.jasper.servlet.JasperLoader.loadClass
(JasperLoader.java:147)
at java.lang.ClassLoader.loadClass(ClassLoader.java:255)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:314)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:124)
at _0002ftest_0002ejsptest_jsp_2._jspService
(_0002ftest_0002ejsptest_jsp_2.java:61)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServlet$JspCountedServlet.service
(JspServlet.java:130)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service
(JspServlet.java:282)
at org.apache.jasper.servlet.JspServlet.serviceJspFile
(JspServlet.java:429)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:500)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.tomcat.core.ServletWrapper.doService
(ServletWrapper.java:405)
at org.apache.tomcat.core.Handler.service(Handler.java:287)
at org.apache.tomcat.core.ServletWrapper.service
(ServletWrapper.java:372)
at org.apache.tomcat.core.ContextManager.internalService
(ContextManager.java:797)
at org.apache.tomcat.core.ContextManager.service
(ContextManager.java:743)
at
org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConne
ction(Ajp12ConnectionHandler.java:166)
at org.apache.tomcat.service.TcpWorkerThread.runIt
(PoolTcpEndpoint.java:416)
at org.apache.tomcat.util.ThreadPool$ControlRunnable.run
(ThreadPool.java:501)
at java.lang.Thread.run(Thread.java:479)