[Spring] [MyBatis 에러] 어이없는 실수

 

 

일단 내가 겪은 어이없는 실수를 공유하려고 한다.

포폴을  만들면서 잠시 세미프로젝트에 정신팔려있었다가

이제 파이널프로젝트를 포폴에 넣기위해 파이널프로젝트를 켰는데

이게 웬걸??? 다른 게시판들은 들어가지는데 내가 만든 보드게시판과 조장이 만든 예약게시판이 안들어가지는것이다.

그리고 브라우저 창에는 이런 에러가 뜨고 

org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: Cannot create PoolableConnectionFactory (IO 오류: The Network Adapter could not establish the connection (CONNECTION_ID=72Y+BlO9Twam4u3BMOTgEw==)) ### The error may exist in /mapper/board-mapper.xml ### The error may involve boardMapper.getTotal ### The error occurred while executing a query ### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: Cannot create PoolableConnectionFactory (IO 오류: The Network Adapter could not establish the connection (CONNECTION_ID=72Y+BlO9Twam4u3BMOTgEw==))

 

 

 

 

이클립스 콘솔창에는 이런 에러가 떴다.

 

 

org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException: 

### Error querying database.  Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: Cannot create PoolableConnectionFactory (IO 오류: The Network Adapter could not establish the connection (CONNECTION_ID=72Y+BlO9Twam4u3BMOTgEw==))

### The error may exist in /mapper/board-mapper.xml

### The error may involve boardMapper.getTotal

### The error occurred while executing a query

### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: Cannot create PoolableConnectionFactory (IO 오류: The Network Adapter could not establish the connection (CONNECTION_ID=72Y+BlO9Twam4u3BMOTgEw==))

at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:96)

at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)

at com.sun.proxy.$Proxy16.selectOne(Unknown Source)

at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:160)

at edu.kh.fin.band.board.model.dao.BoardDAO.getTotal(BoardDAO.java:65)

at edu.kh.fin.band.board.model.service.BoardServiceImpl.getTotal(BoardServiceImpl.java:65)

at edu.kh.fin.band.board.controller.BoardController.BoardList(BoardController.java:68)

at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.base/java.lang.reflect.Method.invoke(Method.java:566)

at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)

at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150)

at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)

at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)

at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)

at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)

at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1067)

at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:963)

at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)

at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:655)

at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)

at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)

at edu.kh.fin.band.common.filter.MainFilter.doFilter(MainFilter.java:40)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)

at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)

at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)

at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:687)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360)

at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399)

at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)

at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:890)

at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1789)

at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)

at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)

at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)

at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

at java.base/java.lang.Thread.run(Thread.java:829)

Caused by: org.apache.ibatis.exceptions.PersistenceException: 

### Error querying database.  Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: Cannot create PoolableConnectionFactory (IO 오류: The Network Adapter could not establish the connection (CONNECTION_ID=72Y+BlO9Twam4u3BMOTgEw==))

### The error may exist in /mapper/board-mapper.xml

### The error may involve boardMapper.getTotal

### The error occurred while executing a query

### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: Cannot create PoolableConnectionFactory (IO 오류: The Network Adapter could not establish the connection (CONNECTION_ID=72Y+BlO9Twam4u3BMOTgEw==))

at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)

at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:153)

at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)

at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)

at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:76)

at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.base/java.lang.reflect.Method.invoke(Method.java:566)

at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)

... 51 more

Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: Cannot create PoolableConnectionFactory (IO 오류: The Network Adapter could not establish the connection (CONNECTION_ID=72Y+BlO9Twam4u3BMOTgEw==))

at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:83)

at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:80)

at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:67)

at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:337)

at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:86)

at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62)

at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)

at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)

at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)

at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:89)

at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)

... 59 more

Caused by: java.sql.SQLException: Cannot create PoolableConnectionFactory (IO 오류: The Network Adapter could not establish the connection (CONNECTION_ID=72Y+BlO9Twam4u3BMOTgEw==))

at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:653)

at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:531)

at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:731)

at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:159)

at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:117)

at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)

... 69 more

Caused by: java.sql.SQLRecoverableException: IO 오류: The Network Adapter could not establish the connection (CONNECTION_ID=72Y+BlO9Twam4u3BMOTgEw==)

at oracle.jdbc.driver.T4CConnection.handleLogonNetException(T4CConnection.java:903)

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:708)

at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:1089)

at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:90)

at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:733)

at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:649)

at org.apache.commons.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:52)

at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:374)

at org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:106)

at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:649)

... 74 more

Caused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection (CONNECTION_ID=72Y+BlO9Twam4u3BMOTgEw==)

at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:687)

at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:569)

at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:933)

at oracle.net.ns.NSProtocol.connect(NSProtocol.java:346)

at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:2558)

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:667)

... 82 more

Caused by: java.io.IOException: Operation timed out, socket connect lapse 75151 ms. 112.220.137.37 1521  0 (1/1) true

at oracle.net.nt.TcpNTAdapter.establishSocket(TcpNTAdapter.java:422)

at oracle.net.nt.TcpNTAdapter.doLocalDNSLookupConnect(TcpNTAdapter.java:304)

at oracle.net.nt.TcpNTAdapter.connect(TcpNTAdapter.java:266)

at oracle.net.nt.ConnOption.connect(ConnOption.java:238)

at oracle.net.nt.ConnStrategy.executeConnOption(ConnStrategy.java:967)

at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:648)

... 87 more

Caused by: java.net.ConnectException: Operation timed out

at java.base/sun.nio.ch.Net.connect0(Native Method)

at java.base/sun.nio.ch.Net.connect(Net.java:476)

at java.base/sun.nio.ch.Net.connect(Net.java:468)

at java.base/sun.nio.ch.SocketChannelImpl.connect(SocketChannelImpl.java:692)

at java.base/java.nio.channels.SocketChannel.open(SocketChannel.java:194)

at oracle.net.nt.TimeoutSocketChannel.connect(TimeoutSocketChannel.java:184)

at oracle.net.nt.TimeoutSocketChannel.<init>(TimeoutSocketChannel.java:158)

at oracle.net.nt.TcpNTAdapter.establishSocket(TcpNTAdapter.java:381)

... 92 more

 

 

 

열심히 구글링해본결과

 

jdbc커넥터를 확인을 하던지

리스너가 잘 켜져있는지 확인하던지 

아님 프로퍼티스를 확인하던지 

sqlplus로 해당 계정에 들어가보던지

오라클이 잘 연결되어있는지 확인하던지 

sql 쿼리를  다시 확인해보던지

 

 

정말 신기하게 이중에 하나도 해당되는게 없었다.

board-mapper.xml는 너무나 정상이였다 

정말 모르겠어서 지피티한테도 물어봤으나 지피티도 저것들을 확인하라는 똑같은 말이였다 

이거로 하루를 꼬박 다 써갈때쯤 

드디어 정말 어이없는 실수를 발견했다 

 

 

root-context.xml 에  db연결부분이 학원에서 썼던 그 db주소였던것이다 ㅎㅎㅎㅎㅎㅎㅎㅎㅎㅎㅎ (지금은 저 주소안됨)

이걸 내 db주소로 바꿔야하는데 ㅎㅎㅎ 

이걸 안바꾸고 계속 다른것만 바꿨네 ㅎㅎㅎㅎㅎㅎ

 

 

복습을 좀 더 열심히 해야겠다 ㅎ

그래도 해결돼서 얼마나 다행이야 ㅠ