困扰了我几天的问题了

[lin_eric]

本人现在开发一个商务网站，用的是SSH开发的，具体的配置文件如下：
spring：
<bean name="/fowardaction" class="com.exchange.struts.action.ForwardAction" scope="prototype">
<property name="tribesDAO" ref="TribesDAO"/>
<property name="tribesmessageDAO" ref="TribesmessageDAO"/>
</bean>
<bean id="dataSource"
class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName"
value="com.microsoft.jdbc.sqlserver.SQLServerDriver">
</property>
<property name="url"
value="jdbc:microsoft:sqlserver://localhost:1433">
</property>
<property name="username" value="sa"></property>
<property name="password" value="lxj"></property>
</bean>

<bean id="sessionFactory"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="dataSource">
<ref bean="dataSource" />
</property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">
org.hibernate.dialect.SQLServerDialect
</prop>
<prop key="cache.use_second_level_cache">
true
</prop>
<prop key="cache.provider_class">
org.hibernate.cache.EhCacheProvider
</prop>
<prop key="jdbc.batch_size">
50
</prop>
<prop key="connection.pool_size">
50
</prop>
<prop key="show_sql">
true
</prop>
</props>
</property>
<property name="mappingResources">
<list>
<value>com/exchange/model/Area.hbm.xml</value>
<value>com/exchange/model/Category.hbm.xml</value>
<value>com/exchange/model/Manager.hbm.xml</value>
<value>com/exchange/model/Message.hbm.xml</value>
<value>com/exchange/model/Notice.hbm.xml</value>
<value>com/exchange/model/Record.hbm.xml</value>
<value>com/exchange/model/Reply.hbm.xml</value>
<value>com/exchange/model/School.hbm.xml</value>
<value>com/exchange/model/Scorerecord.hbm.xml</value>
<value>com/exchange/model/Stuff.hbm.xml</value>
<value>com/exchange/model/Tribes.hbm.xml</value>
<value>com/exchange/model/Tribesmessage.hbm.xml</value>
<value>com/exchange/model/Users.hbm.xml</value>
<value>com/exchange/model/Tribesreply.hbm.xml</value>
</list>
</property>
</bean>
<bean id="TribesDAO" class="com.exchange.dao.TribesDAO">
<property name="sessionFactory">
<ref bean="sessionFactory" />
</property>
</bean>
<bean id="TribesmessageDAO"
class="com.exchange.dao.TribesmessageDAO">
<property name="sessionFactory">
<ref bean="sessionFactory" />
</property>
</bean>
struts:的配置文件：
<action path="/fowardaction"
type="org.springframework.web.struts.DelegatingActionProxy"
>
<forward name="createTopic" path="/tribes/createTopic.jsp"/>
<forward name="allTribes" path="/tribes/alltribes.jsp"/>
<forward name="tribesIndex" path="/tribes/tribesIndex.jsp"/>
<forward name="showTribes" path="/tribes/showTribes.jsp"/>
<forward name="showTribessMessage" path="/tribes/showTribesMessage.jsp"/>
</action>

类tribesDAO：
public class TribesDAO extends HibernateDaoSupport {
private static final Log log = LogFactory.getLog(TribesDAO.class);

public void save(Tribes tribes){
try{
getSession().save(tribes);
getSession().beginTransaction().commit();
}catch(Exception e){
e.printStackTrace();
getSession().getTransaction().rollback();
}finally{
getSession().close();
}
}

public List getTopNew(){
String queryString = "select t.TName,t.TLogo,t.TId from Tribes as t order by t.TDate desc";
Query query = getSession().createQuery(queryString);
query.setMaxResults(5);
List list = query.list();
getSession().close();
return list;
}

public List getTopWelcome(){
String queryString = "select t from Tribes as t order by t.TMembers desc";
Query query = getSession().createQuery(queryString);
List list = query.list();
getSession().close();
return list;
}

public Tribes getTribes(Long tid){
Tribes tribes = (Tribes)getHibernateTemplate().get(Tribes.class, tid);
getSession().close();
return tribes;
}

public List getNewJoinUsers(Long tid){
String queryString = "select u from Users as u where u.tribes.TId = ? order by u.UJoindate desc";
Query query = getSession().createQuery(queryString);
query.setLong(0, tid);
query.setMaxResults(5);
List list = query.list();
getSession().close();
return list;
}

public PageModel getAllTriges(int currentPage){
PageModel pageModel = new PageModel();
String queryString = "from Tribes";
Query query = getSession().createQuery(queryString);
query.setMaxResults(pageModel.getPageSize());
query.setFirstResult((currentPage-1)*pageModel.getPageSize());
pageModel.setPageNo(currentPage);
pageModel.setList(query.list());
pageModel.setTotalRecords(this.getAllTribesCount());
getSession().close();
return pageModel;
}

public int getAllTribesCount(){
String queryString = "select count(t.TId) from Tribes as t";
Query query = getSession().createQuery(queryString);
int count = (Integer)query.uniqueResult();
getSession().close();
return count;
}

运行后，通过http://localhost:8080/exchange/fowardaction.do?method=tribesIndex访问，能成功转向到相应的页面，但当刷新超过2次时，就不能转发到相应的页面了，而是停留不前，IE的那个进度条也几乎是不向前走的。重启下Tomcat又能打开了，但同样刷新2次后又没有反应了，在关闭Tomcat时有这样的提示信息
Waiting for 3 instance(s) to be deallocated

[windy731]

数据库连接没关闭？

[隐藏起来]

这种问题没有遇到过。学习中~~~~~

[抬头望远，低头沉思]

[Quote=引用楼主 lin_eric 的帖子:]
本人现在开发一个商务网站，用的是SSH开发的，具体的配置文件如下：
spring：
<bean name="/fowardaction" class="com.exchange.struts.action.ForwardAction" scope="prototype">
<property name="tribesDAO" ref="TribesDAO"/>
<property name="tribesmessageDAO" ref="TribesmessageDAO"/>
</bean>
<bean id="dataSource"
class="org.apache.commons.dbcp.BasicDataSource">
<property name="dri…
[/Quote]
自己第一感觉是数据库连接没有释放，导致拒绝响应。


第二个怀疑图片用中文来命名，或者是图片比较大导致out of memory。

[lin_eric]

数据库连接我都是关了的呀~~咋没人提出个解决方法啊！！

[lovetysx]

太长了看不懂

[lin_eric]

哪位高手快来帮俺解决解决啊！！