刚部署到阿里云centos的网站访问数据库出问题了

[尘世间迷途的小码农]

项目是springmvc+spring+hibernate的不知道是不是我的配置问题，第一次在阿里云部署网站
HTTP Status 500 – Internal Server Error

Type Exception Report

Message Request processing failed; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet

Description The server encountered an unexpected condition that prevented it from fulfilling the request.

Exception

org.springframework.web.util.NestedServletException: Request processing failed; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:982)
org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861)
javax.servlet.http.HttpServlet.service(HttpServlet.java:635)
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
org.springframework.orm.jpa.support.OpenEntityManagerInViewFilter.doFilterInternal(OpenEntityManagerInViewFilter.java:178)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
org.springframework.orm.hibernate5.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:151)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

Root Cause

javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:147)
org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:155)
org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1419)
org.hibernate.query.internal.AbstractProducedQuery.uniqueResult(AbstractProducedQuery.java:1453)
com.dao.UserDao.getUserByLoginId(UserDao.java:28)
com.service.UserService.getUserByLoginId(UserService.java:31)
com.service.UserService$$FastClassBySpringCGLIB$$4e68a2a4.invoke(<generated>)
org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:721)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:656)
com.service.UserService$$EnhancerBySpringCGLIB$$936a3e6f.getUserByLoginId(<generated>)
com.controller.LoginController.submit(LoginController.java:43)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method.invoke(Method.java:498)
org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)
org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:116)
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)
org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:963)
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:897)
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861)
javax.servlet.http.HttpServlet.service(HttpServlet.java:635)
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
org.springframework.orm.jpa.support.OpenEntityManagerInViewFilter.doFilterInternal(OpenEntityManagerInViewFilter.java:178)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
org.springframework.orm.hibernate5.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:151)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

[李德胜1995]

javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet。。。 Hibernate的问题吧。。。。Hibernate配置文件爱你贴出看看

[尘世间迷途的小码农]

引用 1 楼 pany1209 的回复:

javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet。。。 Hibernate的问题吧。。。。Hibernate配置文件爱你贴出看看

<!--连接池配置--> <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"> <property name="driverClass" value="com.mysql.cj.jdbc.Driver"/> <property name="jdbcUrl" value="jdbc:mysql://localhost:3306/shop?serverTimezone=GMT%2b8&useSSL=true&characterEncoding=UTF-8"/> <property name="user" value="root"/> <property name="password" value="lifuxi"/> </bean> <!--Hibernate配置--> <bean id="sessionFactory" class="org.springframework.orm.hibernate5.LocalSessionFactoryBean"> <property name="dataSource" ref="dataSource"/> <property name="hibernateProperties"> <props> <prop key="hibernate.connection.autocommit">true</prop> <prop key="hibernate.dialect">org.hibernate.dialect.MySQL5InnoDBDialect</prop> <prop key="hibernate.show_sql">true</prop> <prop key="hibernate.format_sql">true</prop> <prop key="hibernate.current_session_context_class"> org.springframework.orm.hibernate5.SpringSessionContext </prop> <prop key="hibernate.connection.url">jdbc:mysql://localhost:3306/shop</prop> <prop key="hibernate.connection.driver_class">com.mysql.jdbc.Driver</prop> </props> </property> <property name="packagesToScan"> <list> <value>com.entity</value> </list> </property> </bean> 这是我的applicationContext.xml的配置

[李德胜1995]

引用 2 楼 qq_36834487 的回复:

[quote=引用 1 楼 pany1209 的回复:] javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet。。。 Hibernate的问题吧。。。。Hibernate配置文件爱你贴出看看

<!--连接池配置--> <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"> <property name="driverClass" value="com.mysql.cj.jdbc.Driver"/> <property name="jdbcUrl" value="jdbc:mysql://localhost:3306/shop?serverTimezone=GMT%2b8&useSSL=true&characterEncoding=UTF-8"/> <property name="user" value="root"/> <property name="password" value="lifuxi"/> </bean> <!--Hibernate配置--> <bean id="sessionFactory" class="org.springframework.orm.hibernate5.LocalSessionFactoryBean"> <property name="dataSource" ref="dataSource"/> <property name="hibernateProperties"> <props> <prop key="hibernate.connection.autocommit">true</prop> <prop key="hibernate.dialect">org.hibernate.dialect.MySQL5InnoDBDialect</prop> <prop key="hibernate.show_sql">true</prop> <prop key="hibernate.format_sql">true</prop> <prop key="hibernate.current_session_context_class"> org.springframework.orm.hibernate5.SpringSessionContext </prop> <prop key="hibernate.connection.url">jdbc:mysql://localhost:3306/shop</prop> <prop key="hibernate.connection.driver_class">com.mysql.jdbc.Driver</prop> </props> </property> <property name="packagesToScan"> <list> <value>com.entity</value> </list> </property> </bean> 这是我的applicationContext.xml的配置[/quote] com.mysql.cj.jdbc.Driver这里的问题吗？？？如果不是估计和mysql的wait_timeout有关。。。。

[尘世间迷途的小码农]

引用 3 楼 pany1209 的回复:

[quote=引用 2 楼 qq_36834487 的回复:] [quote=引用 1 楼 pany1209 的回复:] javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet。。。 Hibernate的问题吧。。。。Hibernate配置文件爱你贴出看看

<!--连接池配置--> <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"> <property name="driverClass" value="com.mysql.cj.jdbc.Driver"/> <property name="jdbcUrl" value="jdbc:mysql://localhost:3306/shop?serverTimezone=GMT%2b8&useSSL=true&characterEncoding=UTF-8"/> <property name="user" value="root"/> <property name="password" value="lifuxi"/> </bean> <!--Hibernate配置--> <bean id="sessionFactory" class="org.springframework.orm.hibernate5.LocalSessionFactoryBean"> <property name="dataSource" ref="dataSource"/> <property name="hibernateProperties"> <props> <prop key="hibernate.connection.autocommit">true</prop> <prop key="hibernate.dialect">org.hibernate.dialect.MySQL5InnoDBDialect</prop> <prop key="hibernate.show_sql">true</prop> <prop key="hibernate.format_sql">true</prop> <prop key="hibernate.current_session_context_class"> org.springframework.orm.hibernate5.SpringSessionContext </prop> <prop key="hibernate.connection.url">jdbc:mysql://localhost:3306/shop</prop> <prop key="hibernate.connection.driver_class">com.mysql.jdbc.Driver</prop> </props> </property> <property name="packagesToScan"> <list> <value>com.entity</value> </list> </property> </bean> 这是我的applicationContext.xml的配置[/quote] com.mysql.cj.jdbc.Driver这里的问题吗？？？如果不是估计和mysql的wait_timeout有关。。。。[/quote] 我是在自己电脑上是没问题的，放到阿里云CentOS上就不行了