前幾天用spring+hibernate+struts寫了個增/刪/改/查的例子。調(diào)試期間問題就來了，當查詢結(jié)果翻頁好幾次就沒N久沒有響應了。最后控制報錯。網(wǎng)上查了，它說數(shù)據(jù)庫連接（池）問題。
出現(xiàn)錯誤如下:
[2007-9-30 下午12時03分03秒 CST] [Error] [WebLogicServer] [BEA-000337] [ExecuteThread: '13' for queue: 'weblogic.kernel.Default' has been busy for "901" seconds working on the request "Http Request: /admin/school.do", which is more than the configured time (StuckThreadMaxTime) of "600" seconds.]
<轉(zhuǎn)為[，>轉(zhuǎn)為]，才發(fā)得出以上面錯誤。可能是javaeye的bug。
先說下我配置
1.環(huán)境：
spring 2.0.6，hibernate 3.2.3，struts 1.2.9，oracle 10.2，weblogic 8.1.4
jdbc是ojdbc14.jar
2.連接池用DBCP
xml 代碼
- <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
- <property name="driverClassName" value="${jdbc.driverClassName}"/>
- <property name="url" value="${jdbc.url}"/>
- <property name="username" value="${jdbc.username}"/>
- <property name="password" value="${jdbc.password}"/>
- bean>
3.分頁方法（參考springside的），此類繼承HibernateDaoSupport
java 代碼
- public Page listByPage(Class entityClass, int pageNo, int pageSize, List criterions, List orders) {
- Criteria criteria = createCriteria(entityClass, criterions);
- CriteriaImpl impl = (CriteriaImpl) criteria;
-
-
- Projection projection = impl.getProjection();
-
- int totalCount = ((Integer) criteria.setProjection(Projections.rowCount()).uniqueResult()).intValue();
-
-
- if(totalCount < 1) {
- return new Page();
- }
-
-
- if(orders != null) {
- for(int i=0; i
- criteria.addOrder((Order) orders.get(i));
- }
- }
-
- criteria.setProjection(projection);
- int startIndex = Page.getStartOfPage(pageNo, pageSize);
-
- List list = criteria.setFirstResult(startIndex).setMaxResults(pageSize).list();
-
- return new Page(startIndex, totalCount, pageSize, list);
- }
-
- public Criteria createCriteria(Class entityClass, List criterions) {
- Criteria criteria = getSession().createCriteria(entityClass);
- if(criterions != null) {
- for(int i=0; i
- criteria.add((Criterion) criterions.get(i));
- }
- }
-
- return criteria;
- }
另外，沒有用OpenSessionInViewFilter，struts與spring的整合：DelegatingRequestProcessor、action path與bean name同名。
翻頁不過10次，服務器就沒響應了，最后出現(xiàn)上面的錯誤的了。
問題解決，問題的原因是數(shù)據(jù)庫連接耗盡，我用HiberanteDaoSupport的getSession()方法取得Session后沒有釋放Session。
出問題的代碼處：
java 代碼
- public Criteria createCriteria(Class entityClass, List criterions) {
- Criteria criteria = getSession().createCriteria(entityClass);
- if(criterions != null) {
- for(int i=0; i
- criteria.add((Criterion) criterions.get(i));
- }
- }
-
- return criteria;
- }
用完Session釋放后就沒事了，調(diào)用HiberanteDaoSupport的releaseSession(session);方法后即可解決。
現(xiàn)在正確的代碼：
java 代碼
- public Page listByPage(Class entityClass, int pageNo, int pageSize, List criterions, List orders) {
- Session session = getSession();
-
- Criteria criteria = session.createCriteria(entityClass);
-
- createCriteria(entityClass, criteria, criterions);
- CriteriaImpl impl = (CriteriaImpl) criteria;
-
-
- Projection projection = impl.getProjection();
-
- int totalCount = ((Integer) criteria.setProjection(Projections.rowCount()).uniqueResult()).intValue();
-
-
- if(totalCount < 1) {
- return new Page();
- }
-
-
- if(orders != null) {
- for(int i=0; i<orders.size(); i++) {
- criteria.addOrder((Order) orders.get(i));
- }
- }
-
- criteria.setProjection(projection);
- int startIndex = Page.getStartOfPage(pageNo, pageSize);
-
- List list = criteria.setFirstResult(startIndex).setMaxResults(pageSize).list();
-
- releaseSession(session);
- return new Page(startIndex, totalCount, pageSize, list);
- }
-
- public Criteria createCriteria(Class entityClass, Criteria criteria, List criterions) {
- if(criterions != null) {
- for(int i=0; i<criterions.size(); i++) {
- criteria.add((Criterion) criterions.get(i));
- }
- }
-
- return criteria;
- }