【SSH】hibernate中Oracle数据库配置文件详解

hibernate的属性设置

## hibernate.dialect org.hibernate.dialect.OracleDialect
hibernate.dialect  org.hibernate.dialect.Oracle10gDialect

hibernate的连接设置
hibernate.connection.driver_class oracle.jdbc.driver.OracleDriver
##  hibernate.connection.url jdbc\:oracle\:thin\:@10.176.33.24\:1521\:ora11gbk
hibernate.connection.url jdbc\:oracle\:thin\:@127.0.0.1\:1521\:ORCL

数据库的用户名和密码
hibernate.connection.username FrameworkTest
hibernate.connection.password FrameworkTest

##  hibernate.connection.username musickr
##  hibernate.connection.password musickr

set the maximum depth of the outer join fetch tree
hibernate.format_sql false
hibernate连接池的个数
hibernate.connection.pool_size 1
hibernate.proxool.pool_alias pool1

hibernate.testsql=select count(*) from dual
hibernate.jdbc.use_streams_for_binary true

## add comments to the generated SQL
hibernate.use_sql_comments true

## set the maximum depth of the outer join fetch tree
hibernate.max_fetch_depth 1
hibernate.jdbc.batch_versioned_data true
hibernate.jdbc.batch_size 28
hibernate.active = 8
hibernate.minidle = 8
hibernate.maxidle = 8
hibernate.maxwait = -1
hibernate.checkAfterUsed=true

c3p0的设置。
c3p0.acquireIncrement=3
c3p0.idleConnectionTextPeriod=900
c3p0.minPoolSize=2
c3p0.maxPoolSize=50
c3p0.maxStatements=100
c3p0.numHelperThreads=10
c3p0.maxIdleTime=600
c3p0.initialPoolSize=0
hibernate.cache.use_query_cache=true
hibernate.cache.provider_class=org.hibernate.cache.EhCacheProvider
base.package = com.hacmp
hibernate映射包，用于spring扫描用。
hibernate.module.pkg=classpath\:com/model/**/*.hbm.xml
spring.security.mapping.directory=classpath\:com/model/**/*.hbm.xml