转载：解决org.hibernate.exception.GenericJDBCException: Cannot open connection

转载于：http://longinus315-hotmail-com.iteye.com/blog/849061
使用SSH开发项目时发现多次从后台取数据时就会报org.hibernate.exception.GenericJDBCException: Cannot open connection错误，解决办法如下：在web.xml中配置配置OpenSessionInViewFilter，将如下代码加入到web.xml中

1. <filter>  
2.         <filter-name>OpenSessionInViewFilter</filter-name>  
3.         <filter-class>  
4.             org.springframework.orm.hibernate3.support.OpenSessionInViewFilter</filter-class>  
5.         <!-- singleSession默认为true,若设为false则等于没用OpenSessionInView -->  
6.         <init-param>  
7.             <param-name>singleSession</param-name>  
8.             <param-value>true</param-value>  
9.         </init-param>  
10.     </filter>  
11.     <filter-mapping>  
12.         <filter-name>OpenSessionInViewFilter</filter-name>  
13.         <url-pattern>/*</url-pattern>  
14.     </filter-mapping>  
15.   
16.     <!--Spring Context listener-->  
17.     <listener>  
18.         <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>  
19.     </listener>  
20.   
21.     <context-param>  
22.         <param-name>contextConfigLocation</param-name>  
23.         <param-value>/WEB-INF/applicationContext-*.xml</param-value>  
24.     </context-param>