오라클 톰캣 에러 문의드립니다

DB가 끊어졌을때 태그안에 TEXT를 화면에 뿌려주고 있습니다.

DB가 끊어지는 현상이 여러가지가 있는데 그중에 안되는부분만 말씀드리면

톰캣설치PC와 오라클설치PC가 다릅니다.

내부네트워크망으로 내부ip 잡고 연결하고있습니다.

일부러 DB가 끊어지는 상황을 cmd에서 셧다운 어바웃 명령으로 만들면

톰캣쪽에 웹브라우저(jsp) 화면에서 태그가 활성화되면서 DB에러를 표시해줍니다.

그러다가 제가 다시 DB를 올리면(cmd 스타트업명령)

웹브라우저에 ajax가 돌고있는데 10초에 한번씩 게시판을 새로 그려주면서

그려진 게시판 안에 DB데이터를 뿌려주는데 여기서<--

아래와 같은 에러가 납니다.. 원래 한번끊어지면 톰캣을 STOP시켰다가 다시 RESTART

시키지 않으면 원복이 안되는건가요?? 톰캣을 재실행하니까 정상작동을 하더라구요..

근데 톰캣PC와 오라클 설치PC가 같은경우에는 또 정상적으로 DB끊어졌을때

에러태그가 활성화되었다가 DB가 재연결되면 ajax가 정상으로 돕니다

이부분은 jdk, jre, 톰캣 lib 폴더에 ojdbc6.jar 라이브러리 추가하는걸로 해결이됐구요..

혹시나 오라클설치PC쪽에도 ojdbc6.jar를 넣어줘야하는건지... 넣으다면 어디에 넣는건지..

아님 다른 에러사유가 있는건지 궁금합니다 ㅠㅠㅠ

java.sql.SQLRecoverableException: 소켓에서 읽을 데이터가 없습니다 	at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1142) 	at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1099) 	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:288) 	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191) 	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523) 	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207) 	at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:863) 	at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1153) 	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1275) 	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576) 	at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3620) 	at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491) 	at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) 	at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) 	at db.Dao.Count(Dao.java:121) 	at org.apache.jsp.param_jsp._jspService(param_jsp.java:167) 	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) 	at javax.servlet.http.HttpServlet.service(HttpServlet.java:731) 	at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:439) 	at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395) 	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339) 	at javax.servlet.http.HttpServlet.service(HttpServlet.java:731) 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) 	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) 	at filter.EncodingFilter.doFilter(EncodingFilter.java:41) 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) 	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) 	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) 	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505) 	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170) 	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) 	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956) 	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) 	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423) 	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079) 	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625) 	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318) 	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) 	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) 	at java.lang.Thread.run(Thread.java:745)