자바 오라클 db연결이 갑자기 안됩니다

Question

서블릿 연습하면서 멤버나 회원입력이나 게시판 글 등록 db를 입력하는 작업을 하였는데요갑자기 GET 요청을 보냈을 때, 상태 코드 500 Internal Server Error가 발생한다고 하고 글목록 들이 안뜨고 회원가입이나 글쓰기 데이터 입력이 안됩니다 오늘 낮 까진 잘되었는데 시스템복구를 해도 여전하네요 어떻게 해야하는지 혹시 아시나요?이클립스 에러는 driver 성공MemberController()...doGet()...selectAllpage()....cpage1pageBlock51,52월 25, 2024 1:52:59 오전 org.apache.catalina.core.StandardWrapperValve invokeSEVERE: 경로가 [/web08Servlet_member]인 컨텍스트의 서블릿 [test.com.member.MemberController]을(를) 위한 Servlet.service() 호출이 예외를 발생시켰습니다.java.security.AccessControlException: access denied ("java.util.PropertyPermission" "oracle.jdbc.RetainV9LongBindBehavior" "read")at java.base/java.security.AccessControlContext.checkPermission(AccessControlContext.java:472)at java.base/java.security.AccessController.checkPermission(AccessController.java:895)at java.base/java.lang.SecurityManager.checkPermission(SecurityManager.java:322)at java.base/java.lang.SecurityManager.checkPropertyAccess(SecurityManager.java:1066)at java.base/java.lang.System.getProperty(System.java:845)at oracle.jdbc.driver.PhysicalConnection$1.run(PhysicalConnection.java:3117)at java.base/java.security.AccessController.doPrivileged(Native Method)at oracle.jdbc.driver.PhysicalConnection.getSystemProperty(PhysicalConnection.java:3113)at oracle.jdbc.driver.PhysicalConnection.readConnectionProperties(PhysicalConnection.java:734)at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:517)at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:228)at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677)at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:228)at test.com.member.MemberDAOimpl.selectAll(MemberDAOimpl.java:438)at test.com.member.MemberController.doGet(MemberController.java:51)at javax.servlet.http.HttpServlet.service(HttpServlet.java:529)at javax.servlet.http.HttpServlet.service(HttpServlet.java:623)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.apache.catalina.security.SecurityUtil.lambda$execute$0(SecurityUtil.java:222)at java.base/java.security.AccessController.doPrivileged(Native Method)at java.base/javax.security.auth.Subject.doAsPrivileged(Subject.java:550)at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:250)at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:142)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:207)at org.apache.catalina.core.ApplicationFilterChain.lambda$doFilter$0(ApplicationFilterChain.java:137)at java.base/java.security.AccessController.doPrivileged(Native Method)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:136)at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)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.apache.catalina.security.SecurityUtil.lambda$execute$0(SecurityUtil.java:222)at java.base/java.security.AccessController.doPrivileged(Native Method)at java.base/javax.security.auth.Subject.doAsPrivileged(Subject.java:550)at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:250)at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:202)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:176)at org.apache.catalina.core.ApplicationFilterChain.lambda$doFilter$0(ApplicationFilterChain.java:137)at java.base/java.security.AccessController.doPrivileged(Native Method)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:136)at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168)at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481)at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:670)at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:390)at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:928)at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1794)at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)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:834) 이렇게 뜹니다 ㅠㅠ

Clickin · Answer

oracle.jdbc.RetainV9LongBindBehavior 속성은 true 혹은 false 아닌가요?이걸 사용하도록 로직을 짜놨는데 설정파일 건들면서 빼먹었거나아니면 오라클에서 사용 안하게 막아뒀는데 억지로 설정해보려 하거나 둘중 하나지 싶네요

자바 오라클 db연결이 갑자기 안됩니다

1개의 답변

기타 목록