当用户和数据库断又重启的时候,用户无法重新从数据库读取数据,只有重新启动tomcat后,用户才能从数据库读取数据,用数据库连接池可以解决这一问题。
<property name="hibernate.connection.provider_class">org.hibernate.connection.C3P0ConnectionProvider</property>
<property name="hibernate.c3p0.max_size">20</property>
<property name="hibernate.c3p0.min_size">5</property>
<property name="hibernate.c3p0.timeout">120</property>
<property name="hibernate.c3p0.max_statements">100</property>
<property name="hibernate.c3p0.idle_test_period">120</property>
<property name="hibernate.c3p0.acquire_increment">2</property>
并且引入架包c3p0-0.9.1.2.jar
解决乱码问题,加入配置代码:
<property name="connection.useUnicode">true</property>
<property name="connection.characterEncoding">UTF-8</property>