sufd.data-source-type=c3p0
#sufd.data-source-type=bone
#sufd.data-source-type=oucp
sufd.data-source.c3p0.class=com.mchange.v2.c3p0.ComboPooledDataSource
sufd.data-source.c3p0.connectionProperties = properties
sufd.data-source.bone.class=com.jolbox.bonecp.BoneCPDataSource
sufd.data-source.bone.connectionProperties = driverProperties
sufd.data-source.oucp.factory-class=oracle.ucp.jdbc.PoolDataSourceFactory
sufd.data-source.oucp.factory-method=getPoolDataSource
sufd.data-source.oucp.connectionProperties = connectionProperties

#Application database
sufd.data-source.common.driverClass=oracle.jdbc.driver.OracleDriver

sufd.data-source.c3p0.maxPoolSize=80
sufd.data-source.c3p0.minPoolSize=15
sufd.data-source.c3p0.acquireIncrement=5
sufd.data-source.c3p0.initialPoolSize=5
sufd.data-source.c3p0.maxIdleTime=3600

sufd.data-source.c3p0.numHelperThreads=5
sufd.data-source.c3p0.maxAdministrativeTaskTime=0

sufd.data-source.c3p0.maxConnectionAge = 0
sufd.data-source.c3p0.maxIdleTimeExcessConnections = 0
sufd.data-source.c3p0.checkoutTimeout = 0
sufd.data-source.c3p0.maxStatements = 30
sufd.data-source.c3p0.maxStatementsPerConnection = 0
sufd.data-source.c3p0.debugUnreturnedConnectionStackTraces = false
sufd.data-source.c3p0.unreturnedConnectionTimeout = 0
sufd.data-source.c3p0.forceIgnoreUnresolvedTransactions = true

sufd.data-source.bone.username=${sufd.data-source.common.user}

sufd.data-source.bone.partitionCount=2
sufd.data-source.bone.minConnectionsPerPartition=5
sufd.data-source.bone.maxConnectionsPerPartition=20
sufd.data-source.bone.maxConnectionAgeInSeconds=3600
sufd.data-source.bone.acquireIncrement=5
sufd.data-source.bone.releaseHelperThreads=1
sufd.data-source.bone.connectionTestStatement=SELECT SYSDATE FROM DUAL
sufd.data-source.bone.closeConnectionWatch=false
sufd.data-source.bone.statementsCacheSize=0
sufd.data-source.bone.statisticsEnabled=true

sufd.data-source.oucp.URL=${sufd.data-source.common.jdbcUrl}
sufd.data-source.oucp.connectionFactoryClassName=oracle.jdbc.pool.OracleDataSource
sufd.data-source.oucp.connectionPoolName=Main SUFD pool

sufd.data-source.oucp.maxPoolSize=80
sufd.data-source.oucp.minPoolSize=15
#sufd.data-source.oucp.acquireIncrement=5
sufd.data-source.oucp.initialPoolSize=5
sufd.data-source.oucp.maxIdleTime=3600
sufd.data-source.oucp.maxStatements = 30

sufd.data-source.debug-connections = false

sufd.hibernate.show_sql=false
sufd.hibernate.format_sql=false
#sufd.hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect
sufd.hibernate.dialect=org.hibernate.dialect.Oracle10gDialect
#sufd.hibernate.dialect=com.otr.util.hibernate.SufdOracleDialect

#\u0412\u043A\u043B/\u0432\u044B\u043A\u043B \u0438\u0441\u043F\u043E\u043B\u044C\u0437\u043E\u0432\u0430\u043D\u0438\u0435 \u043A\u0435\u0448\u0430 \u0432\u0442\u043E\u0440\u043E\u0433\u043E \u0443\u0440\u043E\u0432\u043D\u044F
sufd.hibernate.cache.use_second_level_cache = true
#\u0425\u0440\u0430\u043D\u0438\u0442\u044C \u0434\u0430\u043D\u043D\u044B\u0435 \u0432 \u043A\u0435\u0448\u0435 \u0432\u0442\u043E\u0440\u043E\u0433\u043E \u0443\u0440\u043E\u0432\u043D\u044F \u0432 \u043F\u043E\u043D\u044F\u0442\u043D\u043E\u043C \u0447\u0435\u043B\u043E\u0432\u0435\u043A\u0443 \u0444\u043E\u0440\u043C\u0430\u0442\u0435
sufd.hibernate.cache.use_structured_entries = false

#A non-zero value enables use of JDBC2 batch updates by Hibernate. e.g. recommended values between 5 and 30
sufd.hibernate.jdbc.batch_size = 30

sufd.ehcache.minCacheGroupSize=1024
sufd.ehcache.avgCacheGroupSize=4096
sufd.ehcache.maxCacheGroupSize=40960
sufd.ehcache.prefCacheGroupSize=102400

sufd.ehcache.config=/ehcache.xml
#sufd.ehcache.config=/ehcache-terracotta.xml

sufd.db.freeSpaceCheck.enabled = true
sufd.db.freeSpaceCheck.shutdownEnabled = true
sufd.db.freeSpaceCheck.period = 15
sufd.db.freeSpaceCheck.warningThreshold = 500
sufd.db.freeSpaceCheck.fatalThreshold = 200
sufd.db.freeSpaceCheck.oracle.tablespaces=SUFD_TS;SUFD_LOB_TS

sufd.db.markConnectionAction=false
sufd.blobs.blobBufferSize=1048576

sufd.scroller.sizeQueryTimeout = 5
sufd.scroller.sizeQueryTimeout.threadPoolSize = 200
version = 3