jax-rs 웹 서비스는 최대 절전 모드를 사용하여 데이터베이스에 연결할 수 없습니다.

나는 이것을 위해 무엇을 할 수 있는가?

유형 예외 보고서

메시지 org.springframework.transaction.CannotCreateTransactionException : 트랜잭션을 위해 Hibernate 세션을 열 수 없습니다; 중첩 된 예외는 org.hibernate.exception.SQLGrammarException : 연결을 열 수 없습니다.

설명 서버에서이 요청을 수행하지 못하게하는 내부 오류가 발생했습니다.

예외

org.jboss.resteasy.spi.UnhandledException : org.springframework.transaction.CannotCreateTransactionException : 트랜잭션을 위해 Hibernate 세션을 열 수 없습니다; 중첩 된 예외는 org.hibernate.exception.SQLGrammarException : 연결을 열 수 없습니다. org.jboss.resteasy.core.ExceptionHandler.handleApplicationException (ExceptionHandler.java:76) org.jboss.resteasy.core.ExceptionHandler.handleException (ExceptionHandler.java:212 ) org.jboss.resteasy.core.SynchronousDispatcher.writeException (SynchronousDispatcher.java:149) org.jboss.resteasy.core.SynchronousDispatcher.invoke (SynchronousDispatcher.java:372) org.jboss.resteasy.core.SynchronousDispatcher.invoke (SynchronousDispatcher .java : 179) org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service (ServletContainerDispatcher.java:220) org.jboss.resteasy.plugins.server.servlet.

근본 원인

org.springframework.transaction.CannotCreateTransactionException : 트랜잭션을 위해 Hibernate 세션을 열 수 없습니다; 중첩 된 예외는 org.hibernate.exception.SQLGrammarException : 연결을 열 수 없습니다. org.springframework.orm.hibernate4.HibernateTransactionManager.doBegin (HibernateTransactionManager.java:515) org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction (AbstractPlatformTransactionManager.java:372) ) org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary (TransactionAspectSupport.java:417) org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction (TransactionAspectSupport.java:255) org.springframework.transaction.interceptor.TransactionInterceptor .java : 94) org.springframework.aop.framework.

근본 원인

org.hibernate.exception.SQLGrammarException : 연결을 열 수 없습니다. org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert (SQLExceptionTypeDelegate.java:82) org.hibernate.exception.internal.StandardSQLExceptionConverter.convert (StandardSQLExceptionConverter.java:49) org. hibernate.engine.jdbc.spi.SqlExceptionHelper.convert (SqlExceptionHelper.java:124) org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert (SqlExceptionHelper.java:109) org.hibernate.engine.jdbc.internal.LogicalConnectionImpl. getConnection (LogicalConnectionImpl.java:221) org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.getConnection (LogicalConnectionImpl.java:157) org.hibernate.internal.SessionImpl.connection (SessionImpl.java:427) org.springframework.orm. hibernate4.HibernateTransactionManager.doBegin (HibernateTransactionManager.java:429) org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction (AbstractPlatformTransactionManager.java:372) org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary (TransactionAspectSupport.java:417) org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction (TransactionAspector.TransactionAspectSupport.invokeWithinTransaction) org.springframework.transaction.interceptor.TransactionInterceptor.invoke (TransactionInterceptor.java:94) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed (ReflectiveMethodInvocation.java:172) org.springframework.aop.framework.JdkDynamicAopProxy.invoke (JynamicAopProxy.dk java : 204) com.sun.proxy. $ Proxy34.getCustomer (알 수없는 출처) com.resteasy.series.spring.hibernate.service.CustomerServiceImpl.getCustomerInfo (CustomerServiceImpl.java:33) sun.reflect.NativeMethodAccessorImpl.invoke0 (Native Method) sun.reflect.NativeMethodAccessorImpl.invoke (NativeMethodAccessorImpl.java:62) sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:43) java.4lang.reflect.Method.invoke (MethodAccessorImpl.java:43) java.4lang.reflect.MethodAccessorImpl.invoke (NativeMethodAccessorImpl.java:62) ) org.jboss.resteasy.core.MethodInjectorImpl.invoke (MethodInjectorImpl.java:137) org.jboss.resteasy.core.ResourceMethodInvoker.invokeOnTarget (ResourceMethodInvoker.java:296) org.jboss.resteasy.core.ResourceMethodInvoker.invoke .java : 250) org.jboss.resteasy.core.ResourceMethodInvoker.invoke (ResourceMethodInvoker.java:237) org.jboss.resteasy.core.SynchronousDispatcher.invoke (SynchronousDispatcher.java:356) org.jboss.resteasy.core.SynchronousDispatcher .invoke (SynchronousDispatcher.java:179) org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service (ServletContainerDispatcher.java:220) org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service (HttpServletDispatcher.java:56) org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service (HttpServletDispatcher.java : 51) javax.servlet.http.HttpServlet.service (HttpServlet.java:729) org.apache.tomcat.websocket.server.WsFilter.doFilter (WsFilter.java:52)

근본 원인

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException : 알 수없는 데이터베이스 'benchresources'sun.reflect.NativeConstructorAccessorImpl.newInstance0 (Native Method) sun.reflect.NativeConstructorAccessorImpl.newInstance (NativeConstructorAccessorImpl.java:62) sun.reflect.DelegatingConstructorAccessorImpl. DelegatingConstructorAccessorImpl.java:45) java.lang.reflect.Constructor.newInstance (Constructor.java:422) com.mysql.jdbc.Util.handleNewInstance (Util.java:408) com.mysql.jdbc.Util.getInstance (Util. java : 383) com.mysql.jdbc.SQLError.createSQLException (SQLError.java:1062) com.mysql.jdbc.MysqlIO.checkErrorPacket (MysqlIO.java:4208) com.mysql.jdbc.MysqlIO.checkErrorPacket (MysqlIO.java : 4140) com.mysql.jdbc.MysqlIO.checkErrorPacket (MysqlIO.java:925) com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication (MysqlIO.java:1747) com.mysql.jdbc.MysqlIO.doHandshake (MysqlIO.java:1287) com.mysql.jdbc.ConnectionImpl.coreConnect (ConnectionImpl.java:2494) com.mysql.jdbc.ConnectionImpl.connectOneTryOnly (ConnectionImpl.java:2527) com.mysql. jdbc.ConnectionImpl.createNewIO (ConnectionImpl.java:2309) com.mysql.jdbc.ConnectionImpl. (ConnectionImpl.java:834) com.mysql.jdbc.JDBC4Connection. (JDBC4Connection.java:46) sun.reflect.NativeConstructorAccessorImpl.newInstance0 ( 네이티브 메서드) sun.reflect.NativeConstructorAccessorImpl.newInstance (NativeConstructorAccessorImpl.java:62) sun.reflect.DelegatingConstructorAccessorImpl.newInstance (DelegatingConstructorAccessorImpl.java:45) java.lang.reflect.Constructor.newInstance (Constructor.java:422) com.mysql .jdbc.Util.handleNewInstance (Util.java:408) com.mysql.jdbc.ConnectionImpl.getInstance (ConnectionImpl.java:419) com.mysql.jdbc.NonRegisteringDriver.connect (NonRegisteringDriver.java:344) java.sql.DriverManager.getConnection (DriverManager.java:664) java.sql.DriverManager.getConnection (DriverManager.java:208) org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager (DriverManagerDataSource. java : 173) org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver (DriverManagerDataSource.java:164) org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnectionFromDriver (AbstractDriverBasedDataSource.java:153) org.springframework.jdbc.datasource.AbstractDriver getConnection (AbstractDriverBasedDataSource.java:119) org.hibernate.service.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection (DatasourceConnectionProviderImpl.java:141) org.hibernate.internal.AbstractSessionImpl $ NonContextualJdbcConnectionAccess.obtainConnection (AbstractSessionImpl.java:301) org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection (LogicalConnectionImpl.java:214) org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.getConnection (LogicalConnectionImpl.getConnection (LogicalConnectionImpl.getConnection) 157) org.hibernate.internal.SessionImpl.connection (SessionImpl.java:427) org.springframework.orm.hibernate4.HibernateTransactionManager.doBegin (HibernateTransactionManager.java:429) org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction (Abstract) java : 372) org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary (TransactionAspectSupport.java:417) org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction (TransactionAspectSupport.java:255) org.springframework.transaction.interceptor.TransactionInterceptor.invoke (TransactionInterceptor.java:94) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed (ReflectiveMethodInvocation.java:172) org.springframework.aop framework.JdkDynamicAopProxy.invoke (JdkDynamicAopProxy.java:204) com.sun.proxy. $ Proxy34.getCustomer (Unknown Source) com.resteasy.series.spring.hibernate.service.CustomerServiceImpl.getCustomerInfo (CustomerServiceImpl.java:33) sun. reflect.NativeMethodAccessorImpl.invoke0 (Native Method) sun.reflect.NativeMethodAccessorImpl.invoke (NativeMethodAccessorImpl.java:62) sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:43.java.lang.reflect.Method) java.lang.reflect.Method : 497) org.jboss.resteasy.core.MethodInjectorImpl.invoke (MethodInjectorImpl.java:137) org.jboss.resteasy.core.ResourceMethodInvoker.invokeOnTarget (ResourceMethodInvoker.java:296) org.jboss.resteasy.core.ResourceMethodInvoker.invoke (ResourceMethodInvoker.java:250) org.jboss.resteasy. core.ResourceMethodInvoker.invoke (ResourceMethodInvoker.java:237) org.jboss.resteasy.core.SynchronousDispatcher.invoke (SynchronousDispatcher.java:356) org.jboss.resteasy.core.SynchronousDispatcher.invoke (SynchronousDispatcher.java:179) org. jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service (ServletContainerDispatcher.java:220) org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service (HttpServletDispatcher.java:56) org.jboss.resteasy.plugins. server.servlet.HttpServletDispatcher.service (HttpServletDispatcher.java:51) javax.servlet.http.HttpServlet.service (HttpServlet.java:729) org.apache.tomcat.websocket.server.WsFilter.doFilter (WsFilter.java:52)

note 근본 원인의 전체 스택 추적은 Apache Tomcat / 8.0.23 로그에서 사용할 수 있습니다.