81,122
社区成员




<bean id="sessionFactory"
class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
<property name="dataSource">
<ref bean="dataSource" />
</property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">
${hibernate.dialect}
</prop>
<prop key="hibernate.show_sql">${hibernate.show_sql}</prop>
<!-- 可以自动创建数据库表(create),不创建(none) -->
<!--<prop key="hibernate.hbm2ddl.auto">${hibernate.hbm2ddl.auto}</prop> -->
<!-- 开启二级缓存 -->
<prop key="hibernate.cache.use_second_level_cache">true</prop>
<!-- 关掉查询时的二级缓存 -->
<prop key="hibernate.cache.use_query_cache">false</prop>
<!-- 缓存类 -->
<prop key="hibernate.cache.provider_class">org.hibernate.cache.EhCacheProvider</prop>
<prop key="hibernate.connection.release_mode">after_statement</prop>
</props>
</property>
<!-- 包扫描的方式加载注解类(推荐) -->
<property name="packagesToScan">
<list>
<value>${packagesToScan}</value>
</list>
</property>
</bean>
<!-- 数据库配置 -->
<bean id="dataSource"
class="com.mchange.v2.c3p0.ComboPooledDataSource">
<property name="driverClass">
<value>oracle.jdbc.driver.OracleDriver</value>
</property>
<property name="jdbcUrl">
<value>${url}</value>
</property>
<property name="user"><value>${username}</value></property>
<property name="password"><value>${password}</value></property>
<!-- 初始化链接数 -->
<property name="initialPoolSize" ><value>10</value></property>
<!-- 连接池可分配最大连接数 -->
<property name="maxPoolSize" ><value>100</value></property>
<!-- 连接池可分配最小连接数 -->
<property name="minPoolSize" ><value>10</value></property>
<!--最大空闲时间,1800秒内未使用则连接被丢弃。若为0则永不丢弃。Default: 0 -->
<property name="maxIdleTime" value="1800" />
<!--当连接池中的连接耗尽的时候c3p0一次同时获取的连接数。Default: 3 -->
<property name="acquireIncrement" value="3" />
<property name="maxStatements" value="1000" />
<!--每60秒检查所有连接池中的空闲连接。Default: 0 -->
<property name="idleConnectionTestPeriod" value="60" />
<!--定义在从数据库获取新连接失败后重复尝试的次数。Default: 30 -->
<property name="acquireRetryAttempts" value="30" />
<property name="breakAfterAcquireFailure" value="true" />
<property name="testConnectionOnCheckout" value="false" />
</bean>