最近在学习SSH(真落后,现在才开始学),决定把所遇到的一个问题都整理出来希望对看到的人有所有帮助。
昨天费了很大功夫才把SSH给配置出来,能运行一个简单的Login例子。今天决定把Hibernate中默认使用的DBCP连接池换成我所喜欢的proxool连接池。
第一步:把原来的dataSource的配置删除
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName">
<value>com.inet.tds.TdsDriver</value>
</property>
<property name="url" value="jdbc:inetdae7:192.168.3.251:1433?database=educ&charset=GBK" />
<property name="username">
<value>sa</value>
</property>
<property name="password">
<value>job36web</value>
</property>
</bean>
删除 <property name="dataSource">
<ref bean="dataSource" />
</property>
修改<property name="hibernateProperties">元素
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">org.hibernate.dialect.SQLServerDialect</prop>
<prop key="hibernate.show_sql">true</prop>
<prop key="hibernate.cglib.use_reflection_optimizer">true</prop>
<prop key="hibernate.connection.provider_class">
org.hibernate.connection.ProxoolConnectionProvider
</prop>
<prop key="hibernate.proxool.properties">proxool.properties</prop>
<prop key="hibernate.proxool.pool_alias">DBPool</prop>
</props>
</property>
其中有几点要注意的:
(一)
hibernate.connection.provider_class必须改为org.hibernate.connection.ProxoolConnectionProvider
当然也可以是其它的连接池提供程序,看你的实际情况而定,下面列出了Hibernate支持几种连接池。
Hibernate支持如下的连接池:
DriverManagerConnectionProvider:代表由Hibernate提供的默认的数据库连接池
C3P0ConnectionProvider:代表C3P0连接池
ProxoolConnectionProvider:代表Proxool连接池
DBCPConnectionProvider:代表DBCP连接池
(二)
<prop key="hibernate.proxool.properties">proxool.properties</prop>
如果proxool的配置文件为XML,要对应<prop key="hibernate.proxool.xml">proxool.xml</prop>
(三)
<prop key="hibernate.proxool.pool_alias">DBPool</prop> DBPool要根据proxool配置文件中的别名保持一致
附proxool配置文件:
jdbc-0.proxool.alias=DBPool
jdbc-0.proxool.driver-url=jdbc:inetdae7:192.168.3.251:1433?database=educ&charset=GBK
jdbc-0.proxool.driver-class=com.inet.tds.TdsDriver
jdbc-0.user=sa
jdbc-0.password=job36web
jdbc-0.proxool.house-keeping-sleep-time=40000
jdbc-0.proxool.house-keeping-test-sql=SELECT GETDATE()
jdbc-0.proxool.maximum-connection-count=100
jdbc-0.proxool.minimum-connection-count=25
jdbc-0.proxool.maximum-connection-lifetime=18000000
jdbc-0.proxool.simultaneous-build-throttle=5
jdbc-0.proxool.recently-started-threshold=40000
jdbc-0.proxool.overload-without-refusal-lifetime=50000
jdbc-0.proxool.maximum-active-time=60000
jdbc-0.proxool.verbose=true
jdbc-0.proxool.trace=true
jdbc-0.proxool.fatal-sql-exception=Fatal error
jdbc-0.proxool.prototype-count=2
jdbc-0.proxool.statistics-log-level=ERROR
jdbc-0.proxool.test-before-use=true
jdbc-0.proxool.test-after-use=true
至此配置都已完成。
可能出现在问题[程序第一次运行正常,但多刷几次之后就会出现以下错误提示]
(其实上面的配置已解决下面所示问题):
500 Servlet Exception
500 Servlet Exception
org.hibernate.exception.JDBCConnectionException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:66)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:1596)
at org.hibernate.loader.Loader.list(Loader.java:1577)
at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:111)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1322)
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:300)
at com.ssh.dao.AdminUsersDAO.findByExample(AdminUsersDAO.java:67)
at com.ssh.service.ValidataLogin.isValidata(ValidataLogin.java:20)
at com.ssh.struts.action.LoginAction.execute(LoginAction.java:53)
at org.springframework.web.struts.DelegatingActionProxy.execute(DelegatingActionProxy.java:106)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:165)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:103)
at com.caucho.server.http.FilterChainServlet.doFilter(FilterChainServlet.java:96)
at com.caucho.server.http.Invocation.service(Invocation.java:315)
at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135)
at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:253)
at com.caucho.server.http.HttpRequest.handleConnection(HttpRequest.java:171)
at com.caucho.server.TcpConnection.run(TcpConnection.java:139)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: [TDS Driver]Connection is closed
at com.inet.tds.e.a(Unknown Source)
at com.inet.tds.b.do(Unknown Source)
at com.inet.tds.b.executeQuery(Unknown Source)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:120)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1272)
at org.hibernate.loader.Loader.doQuery(Loader.java:391)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:218)
at org.hibernate.loader.Loader.doList(Loader.java:1593)
... 21 more
就我所遇到情况,分析原因可能是:
1、先查看applicationContext.xml中配置是否正确
2、lib中是否有proxool-0.9.0RC3.jar
3、 jdbc-0.proxool.test-before-use=true
jdbc-0.proxool.test-after-use=true