proxool配置文件如下:----------------------------------------
<?xml version="1.0" encoding="UTF-8"?>
<!-- the proxool configuration can be embedded within your own application's.
Anything outside the "proxool" tag is ignored. --><proxool>
<alias>spring</alias>
<driver-url>jdbc:mysql://localhost:3306/xxx</driver-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<driver-properties>
<property name="connection.autoReconnect" value="true"/>
<property name="connection.useUnicode" value="true"/>
<property name="connection.characterEncoding" value="utf-8"/>
<property name="connection.useNewIO" value="false"/>
<property name="connection.zeroDateTimeBehavior" value="convertToNull"/>
<property name="connection.useServerPrepStmts" value="false"/>
<property name="user" value="xx" />
<property name="password" value="xx" />
</driver-properties>
<minimum-connection-count>2</minimum-connection-count>
<maximum-connection-count>20</maximum-connection-count>
<maximum-connection-lifetime>18000000</maximum-connection-lifetime> <!-- 5 hours -->
<house-keeping-test-sql>values(current TimeStamp)</house-keeping-test-sql>
<statistics>1m,15m,1d</statistics>
<statistics-log-level>INFO</statistics-log-level>
<fatal-sql-exception>Connection is closed,SQLSTATE=08003,Error opening socket. SQLSTATE=08S01,SQLSTATE=08S01</fatal-sql-exception>
<fatal-sql-exception-wrapper-class>org.logicalcobwebs.proxool.FatalRuntimeException</fatal-sql-exception-wrapper-class>
<verbose>false</verbose>
</proxool>
<?xml version="1.0" encoding="UTF-8"?>
<!-- the proxool configuration can be embedded within your own application's.
Anything outside the "proxool" tag is ignored. --><proxool>
<alias>spring</alias>
<driver-url>jdbc:mysql://localhost:3306/xxx</driver-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<driver-properties>
<property name="connection.autoReconnect" value="true"/>
<property name="connection.useUnicode" value="true"/>
<property name="connection.characterEncoding" value="utf-8"/>
<property name="connection.useNewIO" value="false"/>
<property name="connection.zeroDateTimeBehavior" value="convertToNull"/>
<property name="connection.useServerPrepStmts" value="false"/>
<property name="user" value="xx" />
<property name="password" value="xx" />
</driver-properties>
<minimum-connection-count>2</minimum-connection-count>
<maximum-connection-count>20</maximum-connection-count>
<maximum-connection-lifetime>18000000</maximum-connection-lifetime> <!-- 5 hours -->
<house-keeping-test-sql>values(current TimeStamp)</house-keeping-test-sql>
<statistics>1m,15m,1d</statistics>
<statistics-log-level>INFO</statistics-log-level>
<fatal-sql-exception>Connection is closed,SQLSTATE=08003,Error opening socket. SQLSTATE=08S01,SQLSTATE=08S01</fatal-sql-exception>
<fatal-sql-exception-wrapper-class>org.logicalcobwebs.proxool.FatalRuntimeException</fatal-sql-exception-wrapper-class>
<verbose>false</verbose>
</proxool>
解决方案 »
- treeitem为什么添加不了单击事件?
- 通过hibernate的多表链接查询出List页面怎么循环写列表
- 用框架提交日期不能执行实体BEAN中的setter方法问题!(高手指教)
- 应聘JAVA/WEB游戏服务器端的开发
- weblogic9上部署web应用,运行速度缓慢,急!
- XMPP协议问题
- 因为有大家的积极参与,程序员在深圳QQ群已经到第十群了,达1400人,第十群群号是:17541586
- 采用 c/s三层模式,怎样识别客户端是否在线啊?
- sax解析出错,请大侠帮忙!
- java无法生成可滚动结果集,ResultSet为空
- websphere5.1连接access问题,提示null?
- 求os的quartz中文文档
----------------------------------------------------------------------------
<bean id="mySessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="mappingDirectoryLocations">
<list>
<value>classpath:/com/xx/model/businessobject</value>
</list>
</property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
<prop key="hibernate.show_sql">false</prop>
<prop key="hibernate.cglib.use_reflection_optimizer">true</prop>
<prop key="hibernate.cache.use_query_cache">true</prop>
<prop key="hibernate.cache.provider_class">org.hibernate.cache.OSCacheProvider</prop>
<prop key="hibernate.proxool.pool_alias">spring</prop>
<prop key="hibernate.proxool.xml">proxool.xml</prop>
</props>
</property>
</bean>