日期:2014-05-16  浏览次数:20398 次

解决 连接关闭问题

root cause

org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection
?org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:541)
?org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:350)
?org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:262)
?org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:101)
?org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
?org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:631)
?com.ztl.book3un.usermanager.user.bo.impl.ShowStoreContentBOImpl$$EnhancerByCGLIB$$796e6ea3.getStoreInfoByStoreID(<generated>)
?com.ztl.book3un.admin.action.CreateShopHtmlAction.createBookDetail01(CreateShopHtmlAction.java:490)
?com.ztl.book3un.admin.action.CreateShopHtmlAction.execute(CreateShopHtmlAction.java:164)
?sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
?sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
?sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
?java.lang.reflect.Method.invoke(Method.java:597)
?com.opensymphony.xwork.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:358)
?com.opensymphony.xwork.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:218)
?com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:192)
?com.ztl.book3un.common.interceptor.ValidationWorkflowInterceptor.doIntercept(ValidationWorkflowInterceptor.java:73)
?com.opensymphony.xwork.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:86)
?com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
?com.opensymphony.xwork.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:115)
?com.opensymphony.xwork.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:86)
?com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
?com.ztl.platform.web.interceptor.AnnotationWorkflowInterceptor.intercept(AnnotationWorkflowInterceptor.java:61)
?com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
?com.ztl.platform.web.interceptor.PagerInfoInterceptor.intercept(PagerInfoInterceptor.java:67)
?com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
?com.ztl.platform.web.interceptor.InjectInterceptor.intercept(InjectInterceptor.java:91)
?com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
?com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
?com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
?com.ztl.platform.web.interceptor.FileItemUploadInterceptor.intercept(FileItemUploadInterceptor.java:70)
?com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
?com.ztl.platform.web.interceptor.PropertyInterceptor.intercept(PropertyInterceptor.java:51)
?com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
?com.ztl.platform.web.interceptor.RequestParamsInterceptor.intercept(RequestParamsInterceptor.java:44)
?com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
?com.ztl.platform.web.interceptor.NoCacheInterceptor.intercept(NoCacheInterceptor.java:48)
?com.opensymphony.xwork.DefaultActionInvocatio