jsp로 mysql연동 되는지 실습하는데 모르겠습니다 ㅜㅜ..
아래 문제는 지리즈님 덕분에 잘 해결하였습니다. ^^
그래서 이제
http://www.kimho.pe.kr/jsp/jsp_mysql_jdbc.html
여기 있는 것을 실습해 보았습니다..
mysql에 있는 success를 출력해내는 매우 간단한 프로그램입니다.
create로 데이터 베이스 만들고
insert로 kimho , 1234 yyyyyyy이거 하구요..
mysql -u kimho -p testdb 하고 1234 치니까 잘 되더군요
mytest에 myword에 success도 집어 넣구요.
이제 따라 쳤습니다.
<% page.............
..........
Conn.close();
%>
하고 실행을 해봤는데..
Internal Servlet Error:
javax.servlet.ServletException: Server configuration denies access to data source
at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java, Compiled Code)
at _0002ftest_0002ejsptest_jsp_0._jspService(_0002ftest_0002ejsptest_jsp_0.java, Compiled Code)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java, Compiled Code)
at javax.servlet.http.HttpServlet.service(HttpServlet.java, Compiled Code)
at org.apache.jasper.runtime.JspServlet$JspServletWrapper.service(JspServlet.java, Compiled Code)
at org.apache.jasper.runtime.JspServlet.serviceJspFile(JspServlet.java, Compiled Code)
at org.apache.jasper.runtime.JspServlet.service(JspServlet.java, Compiled Code)
at javax.servlet.http.HttpServlet.service(HttpServlet.java, Compiled Code)
at org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWrapper.java, Compiled Code)
at org.apache.tomcat.core.ContextManager.service(ContextManager.java, Compiled Code)
at org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnection(Ajp12ConnectionHandler.java, Compiled Code)
at org.apache.tomcat.service.TcpConnectionThread.run(SimpleTcpEndpoint.java, Compiled Code)
at java.lang.Thread.run(Thread.java, Compiled Code)
Root cause:
java.sql.SQLException: Server configuration denies access to data source
at org.gjt.mm.mysql.MysqlIO.init(MysqlIO.java, Compiled Code)
at org.gjt.mm.mysql.Connection.connectionInit(Connection.java, Compiled Code)
at org.gjt.mm.mysql.jdbc2.Connection.connectionInit(Connection.java, Compiled Code)
at org.gjt.mm.mysql.Driver.connect(Driver.java, Compiled Code)
at java.sql.DriverManager.getConnection(DriverManager.java, Compiled Code)
at java.sql.DriverManager.getConnection(DriverManager.java, Compiled Code)
at _0002ftest_0002ejsptest_jsp_0._jspService(_0002ftest_0002ejsptest_jsp_0.java, Compiled Code)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java, Compiled Code)
at javax.servlet.http.HttpServlet.service(HttpServlet.java, Compiled Code)
at org.apache.jasper.runtime.JspServlet$JspServletWrapper.service(JspServlet.java, Compiled Code)
at org.apache.jasper.runtime.JspServlet.serviceJspFile(JspServlet.java, Compiled Code)
at org.apache.jasper.runtime.JspServlet.service(JspServlet.java, Compiled Code)
at javax.servlet.http.HttpServlet.service(HttpServlet.java, Compiled Code)
at org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWrapper.java, Compiled Code)
at org.apache.tomcat.core.ContextManager.service(ContextManager.java, Compiled Code)
at org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnection(Ajp12ConnectionHandler.java, Compiled Code)
at org.apache.tomcat.service.TcpConnectionThread.run(SimpleTcpEndpoint.java, Compiled Code)
at java.lang.Thread.run(Thread.java, Compiled Code)
라고 나오는군요.. ㅡㅡ...
왕초보인 저로서는 어딜 어떻게 손봐야 할지 모르겠습니다... ㅜㅜ...
apache 1.3.28
jdk 1.2.2-rc4
tomcat 3.1
mysql 3.23.58
사용합니다.. ㅜㅜ
[code:1]<!-- mysql+jdbc 연동 테스트 - fr
<!-- mysql+jdbc 연동 테스트 - from http://okjsp.pe.kr/ --> <%@ page import="java.sql.*" contentType="text/html; charset=euc-kr" %> <% String DB_URL = "jdbc:mysql://localhost/DB_NAME"; String DB_USER = "DB_USER"; String DB_PASSWORD= "DB_PASSWORD"; Connection conn; Statement stmt; try { Class.forName("org.gjt.mm.mysql.Driver"); conn = DriverManager.getConnection(DB_URL, DB_USER, DB_PASSWORD); stmt = conn.createStatement(); conn.close(); out.println("mysql jdbc test: connect ok!!"); } catch(Exception e) { out.println(e.getMessage()); } %>이 소스로 한번 테스트 해보심이..
--
이 아이디는 이제 쓰이지 않습니다.
댓글 달기