org.apache.jasper.JasperException: 행 [19]에서 [/01_dbcp.jsp]을(를) 처리하는 중 예외 발생 16: Context initContext = new InitialContext(); 17: Context envContext = (Context)initContext.lookup("java:/comp/env"); 18: DataSource ds = (DataSource)envContext.lookup("jdbc/myoracle"); 19: Connection conn = ds.getConnection(); 20: out.println("연동성공"); 21: %> 22: </body> Stacktrace: org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:610) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:489) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:379) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:327) javax.servlet.http.HttpServlet.service(HttpServlet.java:764) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)

根本原因

javax.servlet.ServletException: java.sql.SQLException: Cannot create PoolableConnectionFactory (IO 오류: The Network Adapter could not establish the connection (CONNECTION_ID=WrDkTytoQjydLxkHT3R7tw==)) org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:657) org.apache.jsp._01_005fdbcp_jsp._jspService(_01_005fdbcp_jsp.java:158) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) javax.servlet.http.HttpServlet.service(HttpServlet.java:764) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:466) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:379) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:327) javax.servlet.http.HttpServlet.service(HttpServlet.java:764) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)

根本原因

java.sql.SQLException: Cannot create PoolableConnectionFactory (IO 오류: The Network Adapter could not establish the connection (CONNECTION_ID=WrDkTytoQjydLxkHT3R7tw==)) org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:655) org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:533) org.apache.tomcat.dbcp.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:733) org.apache.jsp._01_005fdbcp_jsp._jspService(_01_005fdbcp_jsp.java:141) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) javax.servlet.http.HttpServlet.service(HttpServlet.java:764) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:466) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:379) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:327) javax.servlet.http.HttpServlet.service(HttpServlet.java:764) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)

根本原因

java.sql.SQLRecoverableException: IO 오류: The Network Adapter could not establish the connection (CONNECTION_ID=WrDkTytoQjydLxkHT3R7tw==) oracle.jdbc.driver.T4CConnection.handleLogonNetException(T4CConnection.java:870) oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:675) oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:1032) oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:90) oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:681) oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:602) org.apache.tomcat.dbcp.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:52) org.apache.tomcat.dbcp.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:369) org.apache.tomcat.dbcp.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:102) org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:651) org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:533) org.apache.tomcat.dbcp.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:733) org.apache.jsp._01_005fdbcp_jsp._jspService(_01_005fdbcp_jsp.java:141) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) javax.servlet.http.HttpServlet.service(HttpServlet.java:764) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:466) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:379) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:327) javax.servlet.http.HttpServlet.service(HttpServlet.java:764) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)

根本原因

oracle.net.ns.NetException: The Network Adapter could not establish the connection (CONNECTION_ID=WrDkTytoQjydLxkHT3R7tw==) oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:594) oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:565) oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:937) oracle.net.ns.NSProtocol.connect(NSProtocol.java:346) oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1967) oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:640) oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:1032) oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:90) oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:681) oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:602) org.apache.tomcat.dbcp.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:52) org.apache.tomcat.dbcp.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:369) org.apache.tomcat.dbcp.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:102) org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:651) org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:533) org.apache.tomcat.dbcp.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:733) org.apache.jsp._01_005fdbcp_jsp._jspService(_01_005fdbcp_jsp.java:141) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) javax.servlet.http.HttpServlet.service(HttpServlet.java:764) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:466) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:379) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:327) javax.servlet.http.HttpServlet.service(HttpServlet.java:764) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)

根本原因

java.io.IOException: Connection refused: connect, socket connect lapse 1 ms. 127.0.0.1 1522 0 (1/1) true oracle.net.nt.TcpNTAdapter.establishSocket(TcpNTAdapter.java:421) oracle.net.nt.TcpNTAdapter.doLocalDNSLookupConnect(TcpNTAdapter.java:303) oracle.net.nt.TcpNTAdapter.connect(TcpNTAdapter.java:265) oracle.net.nt.ConnOption.connect(ConnOption.java:229) oracle.net.nt.ConnStrategy.executeConnOption(ConnStrategy.java:814) oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:555) oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:565) oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:937) oracle.net.ns.NSProtocol.connect(NSProtocol.java:346) oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1967) oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:640) oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:1032) oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:90) oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:681) oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:602) org.apache.tomcat.dbcp.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:52) org.apache.tomcat.dbcp.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:369) org.apache.tomcat.dbcp.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:102) org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:651) org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:533) org.apache.tomcat.dbcp.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:733) org.apache.jsp._01_005fdbcp_jsp._jspService(_01_005fdbcp_jsp.java:141) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) javax.servlet.http.HttpServlet.service(HttpServlet.java:764) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:466) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:379) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:327) javax.servlet.http.HttpServlet.service(HttpServlet.java:764) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)

根本原因

java.net.ConnectException: Connection refused: connect java.base/sun.nio.ch.Net.connect0(Native Method) java.base/sun.nio.ch.Net.connect(Net.java:576) java.base/sun.nio.ch.Net.connect(Net.java:583) java.base/sun.nio.ch.SocketChannelImpl.connect(SocketChannelImpl.java:851) java.base/java.nio.channels.SocketChannel.open(SocketChannel.java:285) oracle.net.nt.TimeoutSocketChannel.connect(TimeoutSocketChannel.java:184) oracle.net.nt.TimeoutSocketChannel.<init>(TimeoutSocketChannel.java:158) oracle.net.nt.TcpNTAdapter.establishSocket(TcpNTAdapter.java:380) oracle.net.nt.TcpNTAdapter.doLocalDNSLookupConnect(TcpNTAdapter.java:303) oracle.net.nt.TcpNTAdapter.connect(TcpNTAdapter.java:265) oracle.net.nt.ConnOption.connect(ConnOption.java:229) oracle.net.nt.ConnStrategy.executeConnOption(ConnStrategy.java:814) oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:555) oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:565) oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:937) oracle.net.ns.NSProtocol.connect(NSProtocol.java:346) oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1967) oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:640) oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:1032) oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:90) oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:681) oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:602) org.apache.tomcat.dbcp.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:52) org.apache.tomcat.dbcp.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:369) org.apache.tomcat.dbcp.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:102) org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:651) org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:533) org.apache.tomcat.dbcp.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:733) org.apache.jsp._01_005fdbcp_jsp._jspService(_01_005fdbcp_jsp.java:141) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) javax.servlet.http.HttpServlet.service(HttpServlet.java:764) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:466) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:379) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:327) javax.servlet.http.HttpServlet.service(HttpServlet.java:764) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)



왜 안되는거야... ㅜㅜㅜ