JSP 커넥션풀 이용할때 DataSource.getConnection() 에러 질문드립니다.

Question

안녕하세요 초보개발자입니다...mvc를 이용한 회원가입과 로그인 을 구현중에 커넥션풀이라는걸 배워서 사용하려고했는데아래와 같이 getConnection이라는 함수를 만들었습니다. public Connection getConnection(){ Connection connection &#61; null; DataSource datasource&#61;null; Context context&#61;null; try{ context &#61; new InitialContext(); System.out.println(&#34;context 생성&#34;); datasource&#61; (DataSource)context.lookup(&#34;java:comp/env/jdbc/Oracle11g&#34;); System.out.println(&#34; datasource 생성&#34;); connection&#61;datasource.getConnection(); System.out.println(&#34; connetion 생성&#34;); }catch(Exception e){ System.out.println(&#34;getConnection Exception&#34;); e.printStackTrace(); } return connection; } } 에러가 나는 부분은 datasource.getConnection(); <- 이부분입니다 에러 내용은 아래와 같습니다. 혹시 몰라서 context.xml 의 Resource 내용도 올리겠습니다.심각: Servlet.service() for servlet [jsp] in context with path [/onlinejsp] threw exception [javax.servlet.ServletException: java.lang.AbstractMethodError: oracle.jdbc.driver.T4CConnection.isValid(I)Z] with root cause java.lang.AbstractMethodError: oracle.jdbc.driver.T4CConnection.isValid(I)Z at org.apache.tomcat.dbcp.dbcp2.DelegatingConnection.isValid(DelegatingConnection.java:924) at org.apache.tomcat.dbcp.dbcp2.PoolableConnection.validate(PoolableConnection.java:282) at org.apache.tomcat.dbcp.dbcp2.PoolableConnectionFactory.validateConnection(PoolableConnectionFactory.java:359) at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2316) at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2299) at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2043) at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1543) at com.signup.ex.MemberDAO.getConnection(MemberDAO.java:73) at com.signup.ex.MemberDAO.insertMember(MemberDAO.java:32) at org.apache.jsp.signupEx.signupOk_jsp._jspService(signupOk_jsp.java:128) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:443) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:385) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:329) at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:474) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:624) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:349) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:783) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:798) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1434) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Unknown Source) context.xml의 resource 내용입니다. <Resource auth&#61;&#34;Container&#34; driverClassName&#61;&#34;oracle.jdbc.driver.OracleDriver&#34; url&#61;&#34;jdbc:oracle:thin:&#64;localhost:1521:orcl&#34; username&#61;&#34;jjh&#34; password&#61;&#34;xxxxxxxx&#34; name&#61;&#34;jdbc/Oracle11g&#34; type&#61;&#34;javax.sql.DataSource&#34; maxActive&#61;&#34;50&#34; maxWait&#61;&#34;1000&#34; />초보다 보니까 구글링 검색중 오라클드라이버를 찾지 못한다고 한 내용있어서 jre System library에다가 ojdbc6.jar을 추가하였는데 변화는 없습니다. 에러의 첫줄인 심각: Servlet.service() for servlet [jsp] in context with path [/onlinejsp]이 구문을 보니 먼가 context파일의 위치가 잘못됬다는것인지 아니면 그밑에 드라이버문제라는건지 도저히 며칠동안 알수가없네요 ㅠㅠ context파일은 servers 의 tomcat 폴더에있습니다고수님들 조언좀 부탁드립니다.

Applecode · Accepted Answer

oracle 11g 사용중인것 맞으시죠 ?

야근좀비 · Answer

네 11g 사용하는거 맞습니다 혹시나해서 방금다시 sqlplus에서 확인해보니 11g 맞습니다ㅜ

야근좀비 · Answer

해결됬습니다 정확한 원인은 모르겠지만 tomcat 서버가 관계가 있었던것 같습니다.tomcat 8.0 쓰다가 7.0으로 바꾸니 해결이 됬네요

고스트레이서 · Answer

context.xml에다가 factory&#61;&#34;org.apache.tomcat.jdbc.pool.DataSourceFactory&#34; 넣으면 될 겁니다. 저도 몇 시간 동안 삽질하다 겨우 해결했네요..

유키 · Answer

고스트레이서님 덕분에 해결하고 갑니다.

JSP 커넥션풀 이용할때 DataSource.getConnection() 에러 질문드립니다.

5개의 답변

Q&A 목록