<!-- 配置SessionFactory --> |
< bean id = "sessionFactory" class = "org.springframework.orm.hibernate3.LocalSessionFactoryBean" > |
<!-- 指定hibernate的配置文件位置 --> |
< property name = "configLocation" value = "classpath:hibernate.cfg.xml" ></ property > |
<!-- 配置c3p0数据库连接池 --> |
< property name = "dataSource" > |
< bean class = "com.mchange.v2.c3p0.ComboPooledDataSource" > |
<!-- 数据连接信息 --> |
< property name = "jdbcUrl" value = "${jdbcUrl}" ></ property > |
< property name = "driverClass" value = "${driverClass}" ></ property > |
< property name = "user" value = "${user}" ></ property > |
< property name = "password" value = "${password}" ></ property > |
<!-- 其他配置 --> |
<!--初始化时获取三个连接,取值应在minPoolSize与maxPoolSize之间。Default: 3 --> |
< property name = "initialPoolSize" value = "3" ></ property > |
<!--连接池中保留的最小连接数。Default: 3 --> |
< property name = "minPoolSize" value = "3" ></ property > |
<!--连接池中保留的最大连接数。Default: 15 --> |
< property name = "maxPoolSize" value = "5" ></ property > |
<!--当连接池中的连接耗尽的时候c3p0一次同时获取的连接数。Default: 3 --> |
< property name = "acquireIncrement" value = "3" ></ property > |
<!-- 控制数据源内加载的PreparedStatements数量。如果maxStatements与maxStatementsPerConnection均为0,则缓存被关闭。Default: 0 --> |
< property name = "maxStatements" value = "8" ></ property > |
<!--maxStatementsPerConnection定义了连接池内单个连接所拥有的最大缓存statements数。Default: 0 --> |
< property name = "maxStatementsPerConnection" value = "5" ></ property > |
<!--最大空闲时间,1800秒内未使用则连接被丢弃。若为0则永不丢弃。Default: 0 --> |
< property name = "maxIdleTime" value = "1800" ></ property > |
</ bean > |
</ property > |
</ bean > |