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

逛街的猫 2013-04-01 01:34:28 


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)
...全文
125 6 打赏 收藏 转发到动态 举报
写回复
用AI写文章
6 条回复
切换为时间正序
请发表友善的回复…
发表回复
IMBA__小八 2013-04-01
  • 打赏
  • 举报
 回复
dataSource指向的org.apache.commons.dbcp.BasicDataSource不推荐使用了 配连接池我一般用org.springframework.jndi.JndiObjectFactoryBean这个
licip 2013-04-01
  • 打赏
  • 举报
 回复
单独测试一下你的数据源，看对不对。
s478853630 2013-04-01
  • 打赏
  • 举报
 回复
逛街的猫 2013-04-01
  • 打赏
  • 举报
 回复
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>
逛街的猫 2013-04-01
  • 打赏
  • 举报
 回复 


这个是配置文件！！！

<?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>
逛街的猫 2013-04-01
  • 打赏
  • 举报
 回复
刚开始能运行起来的，就加了一个WebWork.jar包和一个Ajax的js包，刚加的时候也能运行起来，加完，然后把这两个jar删除了，就给我报这样的异常！
跟汤老师学Java（第14季）：异常
本课程从零开始，以通俗易懂的方式讲解Java技术，手把手教你掌握每一个知识点。 真正做到零基础入门学习，适合初学者的教程！...异常的定位和解决 教学全程采用笔记+代码案例的形式讲解，通俗易懂！！！
Kotlin中 ? 和 !! 的区别，?和?:使用
Kotlin中 ? 和 !! 的区别 前言： 很早就听说Kotlin对java NullPointerException有一定的..." : 加在变量名后，系统在任何情况不会报它的空指针异常 "!!" : 加在变量名后，如果对象为null，那么系统一定会报异常 通过j
C#中?、 ??、 ? ：!
一、？ 1、在值类型中添加？，代表没给值类型分配内存空间，如int?a = null 2、在引用对象中添加？，如string a = null,a.append()方法则报空引用异常错误，如果使用a?....Display()来解决波浪线的问题
Kotlin系列之?、?:、!!、:: 特殊符号
符号七：… range表达式 表示多少到多少之间 if(num in 10..100)//表示10..100 表示 10到100 符号八：`` 反引号 1、Kotlin中可以用反引号解决关键字冲突问题 2、将一个不合法的字符变为合法字符，这种情况一般可以用...
【原创】Flyway 8.2.1及以后版本不再支持MySQL？！
Flyway 8.2.1及以后版本不再支持MySQL？！如何解决？
Java EE

67,515

社区成员

225,878

社区内容

发帖
与我相关
我的任务
社区描述
J2EE只是Java企业应用。我们需要一个跨J2SE/WEB/EJB的微容器，保护我们的业务核心组件（中间件），以延续它的生命力，而不是依赖J2SE/J2EE版本。
社区管理员
  • Java EE
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章