当前位置：编程学习 > JAVA >>

这个异常怎么解决？！？？！？？！？



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:599)

	org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:377)

	org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:263)

	org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:101)

	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)

	org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)

	$Proxy0.queryByPage(Unknown Source)

	com.zhwl168.action.user.ListPeIndexAction.execute(ListPeIndexAction.java:64)

	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

	sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

	java.lang.reflect.Method.invoke(Method.java:601)

	com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:452)

	com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:291)

	com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:254)

	com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:176)

	com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)

	com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)

	com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:263)

	org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68)

	com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)

	com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)

	com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:133)

	com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)

	com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:207)

	com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)

	com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)

	com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:207)

	com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)

	com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)

	com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:190)

	com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)

	org.apache.struts2.interceptor.MultiselectInterceptor.intercept(MultiselectInterceptor.java:75)

	com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)

	org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:94)

	com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)

	org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:243)

	com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)

	com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:100)

	com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)

	com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:141)

	com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)

	org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:267)

	com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)

	com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:142)

	com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)

	com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:166)

	com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)

	com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)

	com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:176)

	com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)

	org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164)

	com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)

	com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:190)

	com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)

	com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:187)

	com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)

	org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52)

	org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:485)

	org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77)

	org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:91)





root cause 



org.hibernate.exception.GenericJDBCException: Cannot open connection

	org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)

	org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)

	org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)

	org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)

	org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:426)

	org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)

	org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:119)

	org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57)

	org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326)

	org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:558)

	org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:377)

	org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:263)

	org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:101)

	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)

	org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)

	$Proxy0.queryByPage(Unknown Source)

	com.zhwl168.action.user.ListPeIndexAction.execute(ListPeIndexAction.java:64)

	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

	sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

	java.lang.reflect.Method.invoke(Method.java:601)

	com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:452)

	com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:291)

	com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:254)

	com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:176)

	com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)

	com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)

	com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:263)

	org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68)

	com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)

	com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)

	com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:133)

	com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)

	com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:207)

	com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)

	com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)

	com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:207)

	com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)

	com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)

	com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:190)

	com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
--------------------编程问答--------------------   刚开始能运行起来的，就加了一个WebWork.jar包和一个Ajax的js包，刚加的时候也能运行起来，加完，然后把这两个jar删除了，就给我报这样的异常！ --------------------编程问答-------------------- 




这个是配置文件！！！



<?xml version="1.0" encoding="UTF-8"?>

<beans xmlns="http://www.springframework.org/schema/beans"

	xmlns:aop="http://www.springframework.org/schema/aop" xmlns:context="http://www.springframework.org/schema/context"

	xmlns:tx="http://www.springframework.org/schema/tx" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

	xmlns:p="http://www.springframework.org/schema/p"

	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd    http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.5.xsd  

           http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.5.xsd  

           http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-2.5.xsd">



	



	<!-- Spring JDBC -->

	<context:property-placeholder location="classpath:jdbc.properties" />

	<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">

		<property name="driverClassName" value="${driverClassName}">

		</property>

		<property name="url" value="${url}">

		</property>

		<property name="username" value="${username}"></property>

		<property name="password" value="${password}"></property>

		<!-- 连接池启动时的初始值 -->

		<property name="initialSize" value="${initialSize}"></property>

		<!-- 连接池的最大值 -->

		<property name="maxActive" value="${maxActive}"></property>

		<!-- 最大空间值、当经过一个高峰时间后，连接池可以慢慢将已经用不到的连接慢慢释放一部分，直至减少的maxIdle为止 -->

		<property name="maxIdle" value="${maxIdle}"></property>

		<!-- 最小空间值，当空间的连接数少于阀值时，连接池就会预申请一些连接，以免洪峰来时 来不及申请 -->

		<property name="minIdle" value="${minIdle}"></property>

	</bean>

	<bean id="txManager"

		class="org.springframework.jdbc.datasource.DataSourceTransactionManager"

		abstract="false" lazy-init="default" dependency-check="default">

		<property name="dataSource">        <!-- 要求注入数据源，dataSource是我们自己定义的数据源 -->

			<ref bean="dataSource" />

		</property>

	</bean>

	<tx:annotation-driven transaction-manager="txManager" />   <!-- transaction-manager属性指定事务管理器 -->

	<bean id="sessionFactory"

		class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">

		<property name="dataSource" ref="dataSource" />

		<property name="mappingResources">

			<list>

				<value>com/zhwl168/bean/User.hbm.xml</value>

				<value>com/zhwl168/bean/DiagTypeDict.hbm.xml</value>

				<value>com/zhwl168/bean/PeIndex.hbm.xml</value>

				<value>com/zhwl168/bean/PeCheck.hbm.xml</value>

				<value>com/zhwl168/bean/PeDiag.hbm.xml</value>

				<value>com/zhwl168/bean/PeHosMoney.hbm.xml</value>

				<value>com/zhwl168/bean/PeOper.hbm.xml</value>

			</list>

		</property>

		<property name="hibernateProperties">

			<value>

				hibernate.autoReconnect=true

				hibernate.dialect=org.hibernate.dialect.SQLServerDialect

				hibernate.hbm2ddl.auto=update

				hibernate.show_sql=true

				hibernate.format_sql=false

				hibernate.cache.use_second_level_cache=false

				hibernate.cache.use_query_cache=false

				hibernate.cache.provider_class=org.hibernate.cache.OSCacheProvider

			</value>

		</property>

	</bean>



	<bean id="transactionManager"

		class="org.springframework.orm.hibernate3.HibernateTransactionManager">

		<property name="sessionFactory" ref="sessionFactory" />

	</bean>



	<bean id="userDao" class="com.zhwl168.dao.impl.UserDAOImpl" scope="singleton">

		<property name="sessionFactory">

			<ref bean="sessionFactory" />

		</property>

		<property name="dataSource">

			<ref bean="dataSource" />

		</property>

	</bean>



	<bean id="userServiceTarget" class="com.zhwl168.service.impl.UserServiceImpl">

		<property name="userDao" ref="userDao"></property>

	</bean>



	<bean id="userService"

		class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean">



		<property name="target" ref="userServiceTarget"></property>

		<property name="transactionManager" ref="transactionManager"></property>



		<property name="transactionAttributes">

			<props>

				<prop key="find*">PROPAGATION_REQUIRED,readOnly</prop>

				<prop key="*">PROPAGATION_REQUIRED</prop>

			</props>

		</property>

	</bean>



	<bean id="loginUserAction" class="com.zhwl168.action.user.LoginUserAction"

		scope="prototype">

		<property name="service" ref="userService"></property>

	</bean>

	<bean id="saveUserAction" class="com.zhwl168.action.user.SaveUserAction"

		scope="prototype">

		<property name="service" ref="userService"></property>

	</bean>



	<bean id="listUserAction" class="com.zhwl168.action.user.ListUserAction"

		scope="prototype">

		<property name="service" ref="userService"></property>

	</bean>



	<bean id="removeUserAction" class="com.zhwl168.action.user.RemoveUserAction"

		scope="prototype">

		<property name="service" ref="userService"></property>

	</bean>



	<bean id="updatePUserAction" class="com.zhwl168.action.user.UpdatePUser">

		<property name="service" ref="userService"></property>

	</bean>



	<bean id="updateUserAction" class="com.zhwl168.action.user.UpdateUserAction"

		scope="prototype">

		<property name="service" ref="userService"></property>

	</bean>

	<bean id="listPeIndexAction" class="com.zhwl168.action.user.ListPeIndexAction"

		scope="prototype">

		<property name="service" ref="userService"></property>

	</bean>

	<bean id="queryManyAction" class="com.zhwl168.action.user.QueryManyAction"

		scope="prototype">

		<property name="service" ref="userService"></property>

	</bean>

	<bean id="listAllPeAction" class="com.zhwl168.action.user.ListAllPeAction"

		scope="prototype">

		<property name="service" ref="userService"></property>

	</bean>

</beans>
--------------------编程问答--------------------
web.xml




<?xml version="1.0" encoding="UTF-8"?>

<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

	xmlns="http://java.sun.com/xml/ns/javaee" xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"

	xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"

	id="WebApp_ID" version="2.5"

	>

	<display-name>QueryFrames</display-name>



	<filter>

		<filter-name>struts2</filter-name>

		<filter-class>

			org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter</filter-class>

	</filter>



	<filter-mapping>

		<filter-name>struts2</filter-name>

		<url-pattern>/*</url-pattern>

	</filter-mapping>



	<listener>

		<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>

	</listener>







	<welcome-file-list>

		<welcome-file>index.html</welcome-file>

		<welcome-file>index.htm</welcome-file>

		<welcome-file>index.jsp</welcome-file>

		<welcome-file>default.html</welcome-file>

		<welcome-file>default.htm</welcome-file>

		<welcome-file>default.jsp</welcome-file>

	</welcome-file-list>

</web-app>
--------------------编程问答-------------------- --------------------编程问答-------------------- 单独测试一下你的数据源，看对不对。 --------------------编程问答-------------------- dataSource指向的org.apache.commons.dbcp.BasicDataSource不推荐使用了
配连接池我一般用org.springframework.jndi.JndiObjectFactoryBean这个
补充：Java ,  Java EE

上一个：怎么访问一个网址并下载该网站上特定的图片
下一个：想用矩阵解一个最常见的线性方程组，还没有完成，大侠们帮忙看看错哪了？？？

更多图片编程知识:
更多JAVA疑问解答：
java怎么在线读取ftp服务器上的文件内容
关于程序员的职业规划
HTML和JSP矛盾吗？
java小程序如何打包？
java怎么split路径文件名？
jsp+javaBean中Column 'ordersPrice' specified twice的错误
Java TCP/IP Socket网络编程系列
大家来讨论一下我到底该用什么好?Swing 还是 JavaFX
关于Hibernate实体自身多对一的抓取问题
关于apache2+tomcat群集出现的问题
spring 获取上下文问题
SSH 导入导出excel 谁有这块的资料吗?
Ext TreePanel 刷新问题
springmvc 加载一个jsp页面执行多个方法 报404
checkbox数组action怎么向页面传值
asp
php
Delphi
Matlab
JSP
Foxpro
JS
C/C++
C#/ASP.NET
VC++
JAVA
VB
汇编语言
html/css
CGI
XML/UML
wap
网站相关
网页素材
python
微信小程序
thinkphp
如果你遇到编程学习难题：
访问www.zzzyk.com 试试
CopyRight © 2022 站长资源库 编程知识问答 zzzyk.com All Rights Reserved
部分文章来自网络，