hibernate.properties

hibernate.connection.driver_class=org.postgresql.Driver
hibernate.connection.url=jdbc:postgresql://localhost/hib
hibernate.connection.username=aps
hibernate.connection.password=
hibernate.dialect=net.sf.hibernate.dialect.PostgreSQLDialect

# Set the following to true if you want to see the SQL generated by hibernate
# output to standard out
hibernate.show_sql=false

#The c3p0 connection pooling parameters
#hibernate.c3p0.min_size=2
#hibernate.c3p0.max_size=4
#hibernate.c3p0.timeout=300
#hibernate.c3p0.max_statements=8
#hibernate.c3p0.idle_test_period=3000


# The DBCP Connection Pooling parameters
#Maximum number of checked-out database connections
hibernate.dbcp.maxActive=4

#Maximum number of idle database connections for connection pool
hibernate.dbcp.maxIdle=4

#Maximum idle time for connections in connection pool (expressed in ms).
#Set to -1 to turn off
hibernate.dbcp.maxWait=-1

#Action to take in case of an exhausted DBCP connection pool. Set to 0
#to fail, 1 to block until a connection is made available, or 2 to grow)
hibernate.dbcp.whenExhaustedAction=1

#Validate connection when borrowing connection from pool (defaults to true)
hibernate.dbcp.testOnBorrow=true

#Validate connection when returning connection to pool (optional, true,
# or false)
hibernate.dbcp.testOnReturn=false

#Query to execute for connection validation (optional, requires either
#hibernate.dbcp.testOn Borrow or hibernate.dbcp.testOnReturn)
hibernate.dbcp.validationQuery=SELECT 1+1

#Maximum number of checked-out statements
hibernate.dbcp.ps.maxActive=4

#Maximum number of idle statements
hibernate.dbcp.ps.maxIdle=4

#Maximum idle time for statements (in ms)
hibernate.dbcp.ps.maxWait=60000

#Action to take in case of an exhausted statement pool. Set to 0 to fail,
# 1 to block until a statement is made available, or 2 to grow)
hibernate.dbcp.ps.whenExhaustedAction=1