# PostgreSQL connection example
jdbc.driverClassName=org.postgresql.Driver
jdbc.url=jdbc:postgresql://localhost:5432/c_application_rweb?binaryTransferDisable=TIMESTAMP
jdbc.username=c_application_rweb
jdbc.password=c_application_rweb

# Hibernate additional properties
# Whether to auto-detect Hibernate dialect for PostgreSQL
#com.cb4.common.hibernate.auto.detect.dialect=true
hibernate.dialect=org.hibernate.dialect.PostgreSQL95Dialect
hibernate.cache.region.factory_class=org.hibernate.cache.ehcache.SingletonEhCacheRegionFactory

# Minimum number of JDBC connections in the pool. Hibernate default: 1
hibernate.c3p0.min_size=10
# Maximum number of JDBC connections in the pool. Hibernate default: 100
hibernate.c3p0.max_size=20
# Determines how many Connections a c3p0 pool will attempt to acquire when the pool has run out of Connections
hibernate.c3p0.acquire_increment=2
# Number of prepared statements will be cached. Increase performance. Hibernate default: 0 , caching is disable.
hibernate.c3p0.max_statements=50
# Idle time in seconds before a connection is automatically validated. Hibernate default: 0
hibernate.c3p0.idle_test_period=30
# Seconds a Connection can remain pooled but unused before being discarded. Zero means idle connections never expire. Default: 0
hibernate.c3p0.maxIdleTime=300
# If true, an operation will be performed at every connection checkout to verify that the connection is valid. Default: true
hibernate.c3p0.testConnectionOnCheckout=false
# If true, an operation will be performed asynchronously at every connection checkin to verify that the connection is valid. Default false
hibernate.c3p0.testConnectionOnCheckin=true
# defines the query that will be executed for all connection tests. Default: null
hibernate.c3p0.preferredTestQuery=select 1

hibernate.id.new_generator_mappings=true
hibernate.jdbc.batch_size=1000
hibernate.order_updates=true
hibernate.order_inserts=true
hibernate.use_sql_comments=false
hibernate.connection.release_mode=on_close
hibernate.transaction.auto_close_session=false
hibernate.bytecode.use_reflection_optimizer=false
hibernate.temp.use_jdbc_metadata_defaults=false
# See https://stackoverflow.com/questions/32437202/improvednamingstrategy-no-longer-working-in-hibernate-5
hibernate.physical_naming_strategy=com.cb4.common.jpa.hibernate.ImprovedPhysicalNamingStrategyImpl

hibernate.cache.use_second_level_cache=true
hibernate.cache.infinispan.use_synchronization=false
hibernate.cache.use_query_cache=true
hibernate.show_sql=false