웹 JSP 500에러 DBCP연동중 에러 발생하였습니다. ㅠㅠ

Question

책의 내용을 거의 따라하고 오타도 확인한거같은데 안되네요..한가지 걸리는것은 책에 jstl.jar / standard.jar 라이브러리들을 어디서 복사해오라는데 자세한 설명이 없어서 인터넷 search.maven.org/#search%7Cga%7C1%7C에서 다운받아서 옮겼습니다. <%@page import="java.sql.Connection"%><%@page import="javax.sql.DataSource"%><%@page import="javax.naming.InitialContext"%><%@page import="javax.naming.Context"%><%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>Insert title here

디비 연동

<%Context initContext = new InitialContext();Context envContext = (Context)initContext.lookup("java:/comp/env");DataSource ds = (DataSource)envContext.lookup("jdbc/myoracle");Connection conn = ds.getConnection();out.println("DBCP 연동 성공");%> HTTP Status 500 – Internal Server Error Type Exception ReportMessage An exception occurred processing [/1_dbcp.jsp] at line [18]Description The server encountered an unexpected condition that prevented it from fulfilling the request.Exceptionorg.apache.jasper.JasperException: An exception occurred processing [/1_dbcp.jsp] at line [18] 15: Context initContext = new InitialContext(); 16: Context envContext = (Context)initContext.lookup("java:/comp/env"); 17: DataSource ds = (DataSource)envContext.lookup("jdbc/myoracle"); 18: Connection conn = ds.getConnection(); 19: out.println("DBCP 연동 성공"); 20: %> 21: Stacktrace: org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:593) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:467) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:386) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:330) javax.servlet.http.HttpServlet.service(HttpServlet.java:741) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) Root Causejavax.servlet.ServletException: java.sql.SQLException: Cannot create PoolableConnectionFactory (ORA-01017: invalid username/password; logon denied ) org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:667) org.apache.jsp._1_005fdbcp_jsp._jspService(_1_005fdbcp_jsp.java:151) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) javax.servlet.http.HttpServlet.service(HttpServlet.java:741) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:444) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:386) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:330) javax.servlet.http.HttpServlet.service(HttpServlet.java:741) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) Root Causejava.sql.SQLException: Cannot create PoolableConnectionFactory (ORA-01017: invalid username/password; logon denied ) org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2342) org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2067) org.apache.tomcat.dbcp.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1543) org.apache.jsp._1_005fdbcp_jsp._jspService(_1_005fdbcp_jsp.java:134) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) javax.servlet.http.HttpServlet.service(HttpServlet.java:741) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:444) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:386) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:330) javax.servlet.http.HttpServlet.service(HttpServlet.java:741) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) Root Causejava.sql.SQLException: ORA-01017: invalid username/password; logon denied oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440) oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:389) oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:382) oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:573) oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:431) oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445) oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191) oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:366) oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:752) oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:366) oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:536) oracle.jdbc.driver.T4CConnection.(T4CConnection.java:228) oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32) oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521) org.apache.tomcat.dbcp.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38) org.apache.tomcat.dbcp.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:262) org.apache.tomcat.dbcp.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2352) org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2338) org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2067) org.apache.tomcat.dbcp.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1543) org.apache.jsp._1_005fdbcp_jsp._jspService(_1_005fdbcp_jsp.java:134) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) javax.servlet.http.HttpServlet.service(HttpServlet.java:741) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:444) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:386) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:330) javax.servlet.http.HttpServlet.service(HttpServlet.java:741) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) Note The full stack trace of the root cause is available in the server logs.

lazer · Answer

invalid username/password; logon denied oracle 계정 정보가 책 소스에 적혀진 값이랑 실제 설치한 값이랑 다른가보네요. 그런데.. 언제적 책을 보시길레 이런 소스가..지금 공부 시작하시는데 이런 구시대 책을 보시면 곤란합니다.. &#61;_&#61;

UDT · Answer

말그대로 오라클 계정이 안 맞다는군요.sqldeveloper 설치해서 직접 연결해봐요.윗분말대로 이런소스는 어느회사가도 없을겁니다.

웹 JSP 500에러 DBCP연동중 에러 발생하였습니다. ㅠㅠ

2개의 답변

Q&A 목록