我使用的是数据库连接池,hibernate中使用的是c3p0,在操作一段时间后就读不出数据了。
------------------连接池的配置-------------------------------------------------
<Context path="/****" docBase="****" reloadable="true">
<Resource
name="jdbc/mydb"
auth="Container"
type="javax.sql.DataSource"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/jx00186?characterEncoding=UTF-8"
username="jx00"
password="abc123"
removeAbandonedTimeout="30"
removeAbandoned="true"
logAbandoned="false"
maxActive="50"
maxIdle="3"
maxWait="-1"/>
</Context>
--------------------c3p0配置---------------------------------------------------------
<property name="hibernate.c3p0.min_size">8</property>
<property name="hibernate.c3p0.max_size">50</property>
<property name="hibernate.c3p0.timeout">30</property>
<property name="hibernate.c3p0.max_statements">49</property>
<property name="hibernate.c3p0.idle_test_period">120</property>
<property name="hibernate.c3p0.acquire_increment">2</property>
<property name="hibernate.c3p0.validate">true</property>
<property name="hibernate.cache.use_query_cache">false</property>谢谢帮助。
------------------连接池的配置-------------------------------------------------
<Context path="/****" docBase="****" reloadable="true">
<Resource
name="jdbc/mydb"
auth="Container"
type="javax.sql.DataSource"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/jx00186?characterEncoding=UTF-8"
username="jx00"
password="abc123"
removeAbandonedTimeout="30"
removeAbandoned="true"
logAbandoned="false"
maxActive="50"
maxIdle="3"
maxWait="-1"/>
</Context>
--------------------c3p0配置---------------------------------------------------------
<property name="hibernate.c3p0.min_size">8</property>
<property name="hibernate.c3p0.max_size">50</property>
<property name="hibernate.c3p0.timeout">30</property>
<property name="hibernate.c3p0.max_statements">49</property>
<property name="hibernate.c3p0.idle_test_period">120</property>
<property name="hibernate.c3p0.acquire_increment">2</property>
<property name="hibernate.c3p0.validate">true</property>
<property name="hibernate.cache.use_query_cache">false</property>谢谢帮助。
jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=gb2312是不是这个问题