hibernate中配置oracle数据库,【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