Spring - Oracle JPA 연동 문제입니다 ㅠ

Question

안녕하세요 현재 Spring과 Oracle을 JPA를 통해 연결해연결한 DB에 데이터 조작이 가능한상태인데요.문제는 자꾸만 Intelli J 콘솔에서 오류가 발생하는겁니다 ㅠㅠSELECT의 경우에는 별다른 오류가 뜨지않지만, INSERT 나 DELETE의 경우 곧바로 에러가 발생합니다.에러가 발생하면서도 실제 DB에 INSERT/DELETE는 잘 이루어지고 있습니다.. org.hibernate.exception.JDBCConnectionException: Unable to release JDBC Connection [ORA-17002: I/O 오류: Connection reset https://docs.oracle.com/error-help/db/ora-17002/] [n/a] at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:100) ~[hibernate-core-6.4.1.Final.jar:6.4.1.Final] at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:58) ~[hibernate-core-6.4.1.Final.jar:6.4.1.Final] at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:108) ~[hibernate-core-6.4.1.Final.jar:6.4.1.Final] at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:94) ~[hibernate-core-6.4.1.Final.jar:6.4.1.Final] at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.releaseConnection(LogicalConnectionManagedImpl.java:228) ~[hibernate-core-6.4.1.Final.jar:6.4.1.Final] at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.close(LogicalConnectionManagedImpl.java:258) ~[hibernate-core-6.4.1.Final.jar:6.4.1.Final] at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.close(JdbcCoordinatorImpl.java:161) ~[hibernate-core-6.4.1.Final.jar:6.4.1.Final] at org.hibernate.internal.AbstractSharedSessionContract.close(AbstractSharedSessionContract.java:421) ~[hibernate-core-6.4.1.Final.jar:6.4.1.Final] at org.hibernate.internal.SessionImpl.closeWithoutOpenChecks(SessionImpl.java:429) ~[hibernate-core-6.4.1.Final.jar:6.4.1.Final] at org.hibernate.internal.SessionImpl.close(SessionImpl.java:411) ~[hibernate-core-6.4.1.Final.jar:6.4.1.Final] at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:na] at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) ~[na:na] at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:na] at java.base/java.lang.reflect.Method.invoke(Method.java:568) ~[na:na] at org.springframework.orm.jpa.ExtendedEntityManagerCreator$ExtendedEntityManagerInvocationHandler.invoke(ExtendedEntityManagerCreator.java:364) ~[spring-orm-6.1.2.jar:6.1.2] at jdk.proxy3/jdk.proxy3.$Proxy96.close(Unknown Source) ~[na:na] at org.springframework.orm.jpa.EntityManagerFactoryUtils.closeEntityManager(EntityManagerFactoryUtils.java:424) ~[spring-orm-6.1.2.jar:6.1.2] at org.springframework.orm.jpa.support.OpenEntityManagerInViewInterceptor.afterCompletion(OpenEntityManagerInViewInterceptor.java:112) ~[spring-orm-6.1.2.jar:6.1.2] at org.springframework.web.servlet.handler.WebRequestHandlerInterceptorAdapter.afterCompletion(WebRequestHandlerInterceptorAdapter.java:73) ~[spring-webmvc-6.1.2.jar:6.1.2] at org.springframework.web.servlet.HandlerExecutionChain.triggerAfterCompletion(HandlerExecutionChain.java:176) ~[spring-webmvc-6.1.2.jar:6.1.2] at org.springframework.web.servlet.DispatcherServlet.processDispatchResult(DispatcherServlet.java:1185) ~[spring-webmvc-6.1.2.jar:6.1.2] at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1106) ~[spring-webmvc-6.1.2.jar:6.1.2] at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:979) ~[spring-webmvc-6.1.2.jar:6.1.2] at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1014) ~[spring-webmvc-6.1.2.jar:6.1.2] at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:914) ~[spring-webmvc-6.1.2.jar:6.1.2] at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:590) ~[tomcat-embed-core-10.1.17.jar:6.0] at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:885) ~[spring-webmvc-6.1.2.jar:6.1.2] at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:658) ~[tomcat-embed-core-10.1.17.jar:6.0] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:205) ~[tomcat-embed-core-10.1.17.jar:10.1.17] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:149) ~[tomcat-embed-core-10.1.17.jar:10.1.17] at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51) ~[tomcat-embed-websocket-10.1.17.jar:10.1.17] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:174) ~[tomcat-embed-core-10.1.17.jar:10.1.17] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:149) ~[tomcat-embed-core-10.1.17.jar:10.1.17] at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100) ~[spring-web-6.1.2.jar:6.1.2] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116) ~[spring-web-6.1.2.jar:6.1.2] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:174) ~[tomcat-embed-core-10.1.17.jar:10.1.17] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:149) ~[tomcat-embed-core-10.1.17.jar:10.1.17] at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93) ~[spring-web-6.1.2.jar:6.1.2] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116) ~[spring-web-6.1.2.jar:6.1.2] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:174) ~[tomcat-embed-core-10.1.17.jar:10.1.17] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:149) ~[tomcat-embed-core-10.1.17.jar:10.1.17] at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201) ~[spring-web-6.1.2.jar:6.1.2] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116) ~[spring-web-6.1.2.jar:6.1.2] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:174) ~[tomcat-embed-core-10.1.17.jar:10.1.17] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:149) ~[tomcat-embed-core-10.1.17.jar:10.1.17] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167) ~[tomcat-embed-core-10.1.17.jar:10.1.17] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) ~[tomcat-embed-core-10.1.17.jar:10.1.17] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482) ~[tomcat-embed-core-10.1.17.jar:10.1.17] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:115) ~[tomcat-embed-core-10.1.17.jar:10.1.17] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) ~[tomcat-embed-core-10.1.17.jar:10.1.17] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) ~[tomcat-embed-core-10.1.17.jar:10.1.17] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:340) ~[tomcat-embed-core-10.1.17.jar:10.1.17] at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:391) ~[tomcat-embed-core-10.1.17.jar:10.1.17] at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) ~[tomcat-embed-core-10.1.17.jar:10.1.17] at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:896) ~[tomcat-embed-core-10.1.17.jar:10.1.17] at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1744) ~[tomcat-embed-core-10.1.17.jar:10.1.17] at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) ~[tomcat-embed-core-10.1.17.jar:10.1.17] at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) ~[tomcat-embed-core-10.1.17.jar:10.1.17] at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) ~[tomcat-embed-core-10.1.17.jar:10.1.17] at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) ~[tomcat-embed-core-10.1.17.jar:10.1.17] at java.base/java.lang.Thread.run(Thread.java:842) ~[na:na] Caused by: java.sql.SQLRecoverableException: ORA-17002: I/O 오류: Connection reset https://docs.oracle.com/error-help/db/ora-17002/ at oracle.jdbc.driver.T4CConnection.logoff(T4CConnection.java:2376) ~[ojdbc8-23.3.0.23.09.jar:23.3.0.23.09] at oracle.jdbc.driver.PhysicalConnection.close(PhysicalConnection.java:2880) ~[ojdbc8-23.3.0.23.09.jar:23.3.0.23.09] at oracle.jdbc.driver.T4CConnection.close(T4CConnection.java:10834) ~[ojdbc8-23.3.0.23.09.jar:23.3.0.23.09] at org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.closeConnection(DatasourceConnectionProviderImpl.java:127) ~[hibernate-core-6.4.1.Final.jar:6.4.1.Final] at org.hibernate.internal.NonContextualJdbcConnectionAccess.releaseConnection(NonContextualJdbcConnectionAccess.java:64) ~[hibernate-core-6.4.1.Final.jar:6.4.1.Final] at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.releaseConnection(LogicalConnectionManagedImpl.java:224) ~[hibernate-core-6.4.1.Final.jar:6.4.1.Final] ... 56 common frames omitted Caused by: java.net.SocketException: Connection reset at java.base/sun.nio.ch.SocketChannelImpl.throwConnectionReset(SocketChannelImpl.java:394) ~[na:na] at java.base/sun.nio.ch.SocketChannelImpl.read(SocketChannelImpl.java:426) ~[na:na] at oracle.net.nt.TimeoutSocketChannel.readFromSocket(TimeoutSocketChannel.java:743) ~[ojdbc8-23.3.0.23.09.jar:23.3.0.23.09] at oracle.net.nt.TimeoutSocketChannel.doSelectForRead(TimeoutSocketChannel.java:604) ~[ojdbc8-23.3.0.23.09.jar:23.3.0.23.09] at oracle.net.nt.TimeoutSocketChannel.read(TimeoutSocketChannel.java:501) ~[ojdbc8-23.3.0.23.09.jar:23.3.0.23.09] at oracle.net.ns.NSProtocolNIO.doSocketRead(NSProtocolNIO.java:1228) ~[ojdbc8-23.3.0.23.09.jar:23.3.0.23.09] at oracle.net.ns.NIOPacket.readHeader(NIOPacket.java:271) ~[ojdbc8-23.3.0.23.09.jar:23.3.0.23.09] at oracle.net.ns.NIOPacket.readPacketFromSocketChannel(NIOPacket.java:204) ~[ojdbc8-23.3.0.23.09.jar:23.3.0.23.09] at oracle.net.ns.NIOPacket.readFromSocketChannel(NIOPacket.java:147) ~[ojdbc8-23.3.0.23.09.jar:23.3.0.23.09] at oracle.net.ns.NIOPacket.readFromSocketChannel(NIOPacket.java:120) ~[ojdbc8-23.3.0.23.09.jar:23.3.0.23.09] at oracle.net.ns.NIONSDataChannel.readDataFromSocketChannel(NIONSDataChannel.java:105) ~[ojdbc8-23.3.0.23.09.jar:23.3.0.23.09] at oracle.jdbc.driver.T4CMAREngineNIO.prepareForUnmarshall(T4CMAREngineNIO.java:893) ~[ojdbc8-23.3.0.23.09.jar:23.3.0.23.09] at oracle.jdbc.driver.T4CMAREngineNIO.unmarshalUB1(T4CMAREngineNIO.java:464) ~[ojdbc8-23.3.0.23.09.jar:23.3.0.23.09] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:949) ~[ojdbc8-23.3.0.23.09.jar:23.3.0.23.09] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:456) ~[ojdbc8-23.3.0.23.09.jar:23.3.0.23.09] at oracle.jdbc.driver.T4C7Ocommoncall.doOLOGOFF(T4C7Ocommoncall.java:64) ~[ojdbc8-23.3.0.23.09.jar:23.3.0.23.09] at oracle.jdbc.driver.T4CConnection.logoff(T4CConnection.java:2366) ~[ojdbc8-23.3.0.23.09.jar:23.3.0.23.09] ... 61 common frames omitted문제는 위와같습니다 ㅠㅠUnable to release JDBC Connection [ORA-17002: I/O 오류: Connection reset 자꾸 이오류가 발생하는데.. 실제 DB처리는 잘되는데 왜자꾸 이 오류가 나오는지 모르겠습니다구글링을 통해 제 window의 서비스에서 ora관련된 서비스들을 모두 [실행]으로 유지하였고,listener.ora와 tnsnames.ora 역시 확인하였습니다.. 그래서 Spring 및 제 로컬에서 oracle db와 잘 연결이 되고있구요 ㅠㅠㅠ혹시 몰라 일단 두 ora 파일 내용도 기재하겠습니다.# listener.ora Network Configuration File: D:\oracleSetup\product\12.2.0\dbhome_1
etwork\admin\listener.ora # Generated by Oracle configuration tools. SID_LIST_LISTENER &#61; (SID_LIST &#61; (SID_DESC &#61; (SID_NAME &#61; CLRExtProc) (ORACLE_HOME &#61; D:\oracleSetup\product\12.2.0\dbhome_1) (PROGRAM &#61; extproc) (ENVS &#61; &#34;EXTPROC_DLLS&#61;ONLY:D:\oracleSetup\product\12.2.0\dbhome_1\bin\oraclr12.dll&#34;) ) ) LISTENER &#61; (DESCRIPTION_LIST &#61; (DESCRIPTION &#61; (ADDRESS &#61; (PROTOCOL &#61; TCP)(HOST &#61; localhost)(PORT &#61; 1521)) (ADDRESS &#61; (PROTOCOL &#61; IPC)(KEY &#61; EXTPROC1521)) ) ) # tnsnames.ora Network Configuration File: D:\oracleSetup\product\12.2.0\dbhome_1
etwork\admin	nsnames.ora # Generated by Oracle configuration tools. MESDB &#61; (DESCRIPTION &#61; (ADDRESS_LIST &#61; (ADDRESS &#61; (PROTOCOL &#61; TCP)(HOST &#61; 192.168.5.31)(PORT &#61; 1521)) ) (CONNECT_DATA &#61; (SERVICE_NAME &#61; MESDB) ) ) MESDEV &#61; (DESCRIPTION &#61; (ADDRESS_LIST &#61; (ADDRESS &#61; (PROTOCOL &#61; TCP)(HOST &#61; 192.168.5.15)(PORT &#61; 1521)) ) (CONNECT_DATA &#61; (SERVICE_NAME &#61; MESDEV) ) ) 차라리 db랑 연동자체가 안되거나했으면 모르겠는데.. 조작어를 잘 처리하면서도spring에서 오류를 띄우니.. 어찌해야할지 모르겠습니다무시하고 진행하기도 그렇구요..혹시 이문제 해결해보신분 계실까요?

Clickin · Answer

오라클 에러코드 검색해보시면 대부분 답이 있습니다당장 오키에도 똑같은 오류가 있네요https://okky.kr/questions/137240

Spring - Oracle JPA 연동 문제입니다 ㅠ

1개의 답변

Q&A 목록