- 论坛徽章:
- 0
|
我的程序构架在structs+spring+hibernate框架下
现在出现一个棘手的问题,就是连接池,在向数据库申请新的连接的时候,应用会突然阻塞,变的很慢
用户登陆都无法进行
请各位帮我分析分析原因,谢谢了:)
这是我的spring配置文件的一部分
我申请了两个连接池,一个做日志,一个是应用用的
<!--拦截器-->
<bean id="mySessionFactory2" class="org.springframework.orm.hibernate.LocalSessionFactoryBean">
<property name="mappingResources">
<list>
<value>com/zhs/hbms/entity/LogBasechkSub.hbm.xml</value>
<value>com/zhs/hbms/entity/LogBasebookChk.hbm.xml</value>
<value>com/zhs/hbms/entity/LogBasebook.hbm.xml</value>
<value>com/zhs/hbms/entity/LogBaseSub.hbm.xml</value>
<value>com/zhs/hbms/entity/LogConAdvitem.hbm.xml</value>
<value>com/zhs/hbms/entity/LogConBackcash.hbm.xml</value>
<value>com/zhs/hbms/entity/LogConBookinfo.hbm.xml</value>
<value>com/zhs/hbms/entity/LogConHbinfo.hbm.xml</value>
<value>com/zhs/hbms/entity/LogConInvoice.hbm.xml</value>
<value>com/zhs/hbms/entity/LogConSpecinfo.hbm.xml</value>
<value>com/zhs/hbms/entity/LogConTailorStep.hbm.xml</value>
<value>com/zhs/hbms/entity/LogContract.hbm.xml</value>
<value>com/zhs/hbms/entity/LogCustomerBase.hbm.xml</value>
<value>com/zhs/hbms/entity/LogCustSub.hbm.xml</value>
<value>com/zhs/hbms/entity/LogStoreBill.hbm.xml</value>
</list>
</property>
<property name="dataSource"> <ref bean="myDataSource2"/> </property>
<property name="hibernateProperties">
<ref bean="exampleHibernateProperties" />
</property>
</bean>
<bean id="myTransactionManager2" class="org.springframework.orm.hibernate.HibernateTransactionManager">
<property name="sessionFactory"><ref local="mySessionFactory2"/></property>
</bean>
<bean id="makeLogInterceptor" class="com.zhs.hbms.env.MakeLogInterceptor" singleton="true">
</bean>
<bean id="myDataSource2" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<property name="driverClassName"> <value>com.sybase.jdbc2.jdbc.SybDriver</value></property>
<property name="url"><value>jdbc:sybase:Tds:128.129.0.204:5000/hbtest?charset=cp936</value></property>
<property name="username"><value>sa</value></property>
<property name="password"><value></value></property>
<property name="maxActive"><value>100</value></property>
</bean>
<!-- Database Property -->
<bean id="exampleHibernateProperties"
class="org.springframework.beans.factory.config.PropertiesFactoryBean">
<property name="properties">
<props>
<prop
key="hibernate.dialect">net.sf.hibernate.dialect.SybaseDialect</prop>
<prop
key="hibernate.query.substitutions">true 'T', false 'F'</prop>
<prop key="hibernate.show_sql">false</prop>
<prop key="hibernate.c3p0.minPoolSize">1</prop>
<prop key="hibernate.c3p0.maxPoolSize">2</prop>
<prop key="hibernate.c3p0.timeout">600</prop>
<prop key="hibernate.c3p0.max_statement">50</prop>
<prop
key="hibernate.c3p0.testConnectionOnCheckout">false</prop>
</props>
</property>
</bean>
<bean id="myDataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<property name="driverClassName"> <value>com.sybase.jdbc2.jdbc.SybDriver</value></property>
<property name="url"><value>jdbc:sybase:Tds:128.129.0.204:5000/hbtest?charset=cp936</value></property>
<property name="username"><value>sa</value></property>
<property name="password"><value></value></property>
<property name="maxActive"><value>100</value></property>
</bean>
<!-- Transaction manager for a single Hibernate SessionFactory (alternative to JTA) -->
<bean id="myTransactionManager" class="org.springframework.orm.hibernate.HibernateTransactionManager">
<property name="sessionFactory"><ref local="mySessionFactory"/></property>
</bean> |
|