spring的配置: <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close" dependency-check="none">
<property name="driverClass">
<value>${datasource.driverClassName}</value>
</property>
<property name="jdbcUrl">
<value>${datasource.url}</value>
</property>
<property name="user">
<value>${datasource.username}</value>
</property>
<property name="password">
<value>${datasource.password}</value>
</property>
<property name="acquireIncrement">
<value>${c3p0.acquireIncrement}</value>
</property>
<property name="initialPoolSize">
<value>${c3p0.initialPoolSize}</value>
</property>
<property name="minPoolSize">
<value>${c3p0.minPoolSize}</value>
</property>
<property name="maxPoolSize">
<value>${c3p0.maxPoolSize}</value>
</property>
<property name="maxIdleTime">
<value>${c3p0.maxIdleTime}</value>
</property>
<property name="idleConnectionTestPeriod">
<value>${c3p0.idleConnectionTestPeriod}</value>
</property>
<property name="maxStatements">
<value>${c3p0.maxStatements}</value>
</property>
<property name="numHelperThreads">
<value>${c3p0.numHelperThreads}</value>
</property>
</bean>
<bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="dataSource">
<ref local="dataSource"/>
</property>
<property name="mappingResources">
<list>
<value>com/laoer/bbscs/bean/UserInfo.hbm.xml</value>
<value>com/laoer/bbscs/bean/UserDetail.hbm.xml</value>
<value>com/laoer/bbscs/bean/Config.hbm.xml</value>
<value>com/laoer/bbscs/bean/Board.hbm.xml</value>
<value>com/laoer/bbscs/bean/BoardMaster.hbm.xml</value>
<value>com/laoer/bbscs/bean/BoardTag.hbm.xml</value>
<value>com/laoer/bbscs/bean/Permission.hbm.xml</value>
<value>com/laoer/bbscs/bean/Role.hbm.xml</value>
<value>com/laoer/bbscs/bean/UserGroup.hbm.xml</value>
<value>com/laoer/bbscs/bean/UserOnline.hbm.xml</value>
<value>com/laoer/bbscs/bean/LoginError.hbm.xml</value>
<value>com/laoer/bbscs/bean/BoardPermission.hbm.xml</value>
<value>com/laoer/bbscs/bean/Friend.hbm.xml</value>
<value>com/laoer/bbscs/bean/Note.hbm.xml</value>
<value>com/laoer/bbscs/bean/BookMark.hbm.xml</value>
<value>com/laoer/bbscs/bean/Forum.hbm.xml</value>
<value>com/laoer/bbscs/bean/ForumHistory.hbm.xml</value>
<value>com/laoer/bbscs/bean/Subscibe.hbm.xml</value>
<value>com/laoer/bbscs/bean/AgreeAgainst.hbm.xml</value>
<value>com/laoer/bbscs/bean/Vote.hbm.xml</value>
<value>com/laoer/bbscs/bean/VoteItem.hbm.xml</value>
<value>com/laoer/bbscs/bean/VoteUser.hbm.xml</value>
<value>com/laoer/bbscs/bean/BoardSave.hbm.xml</value>
<value>com/laoer/bbscs/bean/BoardAuthUser.hbm.xml</value>
<value>com/laoer/bbscs/bean/Elite.hbm.xml</value>
<value>com/laoer/bbscs/bean/Commend.hbm.xml</value>
<value>com/laoer/bbscs/bean/ChoiceCategory.hbm.xml</value>
<value>com/laoer/bbscs/bean/Choice.hbm.xml</value>
<value>com/laoer/bbscs/bean/SysNumStat.hbm.xml</value>
<value>com/laoer/bbscs/bean/UserTop.hbm.xml</value>
<value>com/laoer/bbscs/bean/ForumBuy.hbm.xml</value>
<value>com/laoer/bbscs/bean/UserLevel.hbm.xml</value>
</list>
</property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">${hibernate.dialect}</prop>
<prop key="hibernate.show_sql">${hibernate.show_sql}</prop>
<prop key="hibernate.jdbc.fetch_size">${hibernate.jdbc.fetch_size}</prop>
<prop key="hibernate.jdbc.batch_size">${hibernate.jdbc.batch_size}</prop>
<!--<prop key="hibernate.proxool.pool_alias">bbscs7db</prop>
<prop key="hibernate.proxool.xml">proxool.xml</prop>
-->
<prop key="hibernate.connection.release_mode">${hibernate.connection.release_mode}</prop>
</props>
</property>
</bean>
<bean id="myTransactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
<property name="sessionFactory">
<ref local="sessionFactory"/>
</property>
</bean>
<bean id="ajaxMessagesXML" class="com.laoer.bbscs.comm.AjaxMessagesXML" singleton="false"/>
<bean id="eliteXML" class="com.laoer.bbscs.service.db2xml.EliteXML" singleton="false"/>
<bean id="boardCache" class="com.laoer.bbscs.service.imp.OsCacheImp">
<constructor-arg>
<value>${cache.config}</value>
</constructor-arg>
</bean>
<bean id="userPermissionCache" class="com.laoer.bbscs.service.imp.OsCacheImp">
<constructor-arg>
<value>${cacheup.config}</value>
</constructor-arg>
</bean>
<bean id="scriptForumCache" class="com.laoer.bbscs.service.imp.OsCacheImp">
<constructor-arg>
<value>${cachefl.config}</value>
</constructor-arg>
</bean>
hibernate的配置是:datasource.driverClassName=org.gjt.mm.mysql.Driver
datasource.url=jdbc:mysql://localhost:3306/bbscs7?useUnicode=true&characterEncoding=UTF-8
datasource.username=root
datasource.password=010613datasource.maxActive=10
datasource.maxIdle=2
datasource.maxWait=120000
datasource.whenExhaustedAction=1
datasource.validationQuery=select 1 from dual
datasource.testOnBorrow=true
datasource.testOnReturn=falsec3p0.acquireIncrement=3
c3p0.initialPoolSize=3
c3p0.idleConnectionTestPeriod=900
c3p0.minPoolSize=2
c3p0.maxPoolSize=50
c3p0.maxStatements=100
c3p0.numHelperThreads=10
c3p0.maxIdleTime=600#hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect
#hibernate.dialect=org.hibernate.dialect.MySQLMyISAMDialect
hibernate.dialect=org.hibernate.dialect.MySQLDialect
hibernate.jdbc.batch_size=25
hibernate.jdbc.fetch_size=50
hibernate.show_sql=false
hibernate.connection.release_mode=after_transactionbbscs.isloadconfig=false
bbscs.safePath=C:/tmp/cache.config=oscache.properties
cacheup.config=oscache_up.properties
cachefl.config=oscache_fl.properties
<property name="driverClass">
<value>${datasource.driverClassName}</value>
</property>
<property name="jdbcUrl">
<value>${datasource.url}</value>
</property>
<property name="user">
<value>${datasource.username}</value>
</property>
<property name="password">
<value>${datasource.password}</value>
</property>
<property name="acquireIncrement">
<value>${c3p0.acquireIncrement}</value>
</property>
<property name="initialPoolSize">
<value>${c3p0.initialPoolSize}</value>
</property>
<property name="minPoolSize">
<value>${c3p0.minPoolSize}</value>
</property>
<property name="maxPoolSize">
<value>${c3p0.maxPoolSize}</value>
</property>
<property name="maxIdleTime">
<value>${c3p0.maxIdleTime}</value>
</property>
<property name="idleConnectionTestPeriod">
<value>${c3p0.idleConnectionTestPeriod}</value>
</property>
<property name="maxStatements">
<value>${c3p0.maxStatements}</value>
</property>
<property name="numHelperThreads">
<value>${c3p0.numHelperThreads}</value>
</property>
</bean>
<bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="dataSource">
<ref local="dataSource"/>
</property>
<property name="mappingResources">
<list>
<value>com/laoer/bbscs/bean/UserInfo.hbm.xml</value>
<value>com/laoer/bbscs/bean/UserDetail.hbm.xml</value>
<value>com/laoer/bbscs/bean/Config.hbm.xml</value>
<value>com/laoer/bbscs/bean/Board.hbm.xml</value>
<value>com/laoer/bbscs/bean/BoardMaster.hbm.xml</value>
<value>com/laoer/bbscs/bean/BoardTag.hbm.xml</value>
<value>com/laoer/bbscs/bean/Permission.hbm.xml</value>
<value>com/laoer/bbscs/bean/Role.hbm.xml</value>
<value>com/laoer/bbscs/bean/UserGroup.hbm.xml</value>
<value>com/laoer/bbscs/bean/UserOnline.hbm.xml</value>
<value>com/laoer/bbscs/bean/LoginError.hbm.xml</value>
<value>com/laoer/bbscs/bean/BoardPermission.hbm.xml</value>
<value>com/laoer/bbscs/bean/Friend.hbm.xml</value>
<value>com/laoer/bbscs/bean/Note.hbm.xml</value>
<value>com/laoer/bbscs/bean/BookMark.hbm.xml</value>
<value>com/laoer/bbscs/bean/Forum.hbm.xml</value>
<value>com/laoer/bbscs/bean/ForumHistory.hbm.xml</value>
<value>com/laoer/bbscs/bean/Subscibe.hbm.xml</value>
<value>com/laoer/bbscs/bean/AgreeAgainst.hbm.xml</value>
<value>com/laoer/bbscs/bean/Vote.hbm.xml</value>
<value>com/laoer/bbscs/bean/VoteItem.hbm.xml</value>
<value>com/laoer/bbscs/bean/VoteUser.hbm.xml</value>
<value>com/laoer/bbscs/bean/BoardSave.hbm.xml</value>
<value>com/laoer/bbscs/bean/BoardAuthUser.hbm.xml</value>
<value>com/laoer/bbscs/bean/Elite.hbm.xml</value>
<value>com/laoer/bbscs/bean/Commend.hbm.xml</value>
<value>com/laoer/bbscs/bean/ChoiceCategory.hbm.xml</value>
<value>com/laoer/bbscs/bean/Choice.hbm.xml</value>
<value>com/laoer/bbscs/bean/SysNumStat.hbm.xml</value>
<value>com/laoer/bbscs/bean/UserTop.hbm.xml</value>
<value>com/laoer/bbscs/bean/ForumBuy.hbm.xml</value>
<value>com/laoer/bbscs/bean/UserLevel.hbm.xml</value>
</list>
</property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">${hibernate.dialect}</prop>
<prop key="hibernate.show_sql">${hibernate.show_sql}</prop>
<prop key="hibernate.jdbc.fetch_size">${hibernate.jdbc.fetch_size}</prop>
<prop key="hibernate.jdbc.batch_size">${hibernate.jdbc.batch_size}</prop>
<!--<prop key="hibernate.proxool.pool_alias">bbscs7db</prop>
<prop key="hibernate.proxool.xml">proxool.xml</prop>
-->
<prop key="hibernate.connection.release_mode">${hibernate.connection.release_mode}</prop>
</props>
</property>
</bean>
<bean id="myTransactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
<property name="sessionFactory">
<ref local="sessionFactory"/>
</property>
</bean>
<bean id="ajaxMessagesXML" class="com.laoer.bbscs.comm.AjaxMessagesXML" singleton="false"/>
<bean id="eliteXML" class="com.laoer.bbscs.service.db2xml.EliteXML" singleton="false"/>
<bean id="boardCache" class="com.laoer.bbscs.service.imp.OsCacheImp">
<constructor-arg>
<value>${cache.config}</value>
</constructor-arg>
</bean>
<bean id="userPermissionCache" class="com.laoer.bbscs.service.imp.OsCacheImp">
<constructor-arg>
<value>${cacheup.config}</value>
</constructor-arg>
</bean>
<bean id="scriptForumCache" class="com.laoer.bbscs.service.imp.OsCacheImp">
<constructor-arg>
<value>${cachefl.config}</value>
</constructor-arg>
</bean>
hibernate的配置是:datasource.driverClassName=org.gjt.mm.mysql.Driver
datasource.url=jdbc:mysql://localhost:3306/bbscs7?useUnicode=true&characterEncoding=UTF-8
datasource.username=root
datasource.password=010613datasource.maxActive=10
datasource.maxIdle=2
datasource.maxWait=120000
datasource.whenExhaustedAction=1
datasource.validationQuery=select 1 from dual
datasource.testOnBorrow=true
datasource.testOnReturn=falsec3p0.acquireIncrement=3
c3p0.initialPoolSize=3
c3p0.idleConnectionTestPeriod=900
c3p0.minPoolSize=2
c3p0.maxPoolSize=50
c3p0.maxStatements=100
c3p0.numHelperThreads=10
c3p0.maxIdleTime=600#hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect
#hibernate.dialect=org.hibernate.dialect.MySQLMyISAMDialect
hibernate.dialect=org.hibernate.dialect.MySQLDialect
hibernate.jdbc.batch_size=25
hibernate.jdbc.fetch_size=50
hibernate.show_sql=false
hibernate.connection.release_mode=after_transactionbbscs.isloadconfig=false
bbscs.safePath=C:/tmp/cache.config=oscache.properties
cacheup.config=oscache_up.properties
cachefl.config=oscache_fl.properties
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货