#-----------------------------------------------------------------------------------------------
# poolConfig.properties INFORMATION
# -----------------------------------------------------------------------------------------------
#
#########################################
#### Information on - Admin settings ####
#########################################
#
# adminUser : The user name for administering the pool via the web management interface
# adminPassword : The user name for administering the pool via the web management interface
# adminWebManagementPort : The port for which the web management too should run
# adminEmailAddresses : Email address for the admin users to be notified of pool events
# Multiple email addresses should be comma delimited - ie :
# adminEmailAddresses=joe@bloggs.com,foo@bar.com
# adminEmailNotifcations : Whether the pool should send emails for pool events (such as pools starting or stopping, and pool crisis information).
# Value should be true/false
# adminEmailSMTPServer : Your SMTP server if you want to recieve email notifications
# adminEmailCrisisAddress : Crisis email address which will be used to send warnings to after the adminEmailMaxWarningNumber property has been exceeded
# adminEmailNotificationPeriod : Time in milliseconds between warning emails
# adminEmailMaxWarningNumber : The maximum number of emails to send about a specific problem before the crisis address is used
# adminEmailNotifications : Boolean specifying whether the pool should send emails for pool events (such as pools starting or stopping, and pool crisis information)
# adminPoolControllerLogFile : The location of the PoolController log file (not pool instance logs, but general primrose logging)
#
# Note : If you enable email notifications, you must have activation.jar and mail.jar in common/lib or on the CLASSPATH. Both available from Sun
# via the JavaMail API home page on [URL unfurl="true"]http://www.java.sun.com,[/URL] or from [URL unfurl="true"]http://primrose.org.uk/download.jsp[/URL] (tomcat* support jar bundle)
#
# More info on these settings can be found at [URL unfurl="true"]http://www.primrose.org.uk/docs/mainPoolView.jsp[/URL]
#
##########################################
#### Information on - Pool Instances #####
##########################################
#
# poolName : The name to use when calling the pool
# base : The number of base connections to hold by default
# overflow : How many connections to hold in the overflow pool
# user : Username to connect to the database with
# password : Which password to use with the specified username
# log : Relative path to the log file (from the Tomcat bin directory)
# idleTime : Number of milliseconds to keep a connection before releasing it when idle
# messageLogging : Whether or not to log messages (such as SQL logging, connection gets() etc)
# sizeLogging : Whether or not to log pool size data
# driverClass : The class to load as the driver to the database
# driverURL : The URL that is used to connect to the database (including host, port and db name/SID
# cycleConnections : How many SQL transactions a connection should make before being refreshed, and creating a new one (-1 disables)
# killActiveConnectionsOverAge : Number of milliseconds over which connections will be killed if still active (-1 disables)
# queueConnectionRequests : Whether or not connection requests should be queued when load is heavy and no connections are available (true == queue, false == do not queue (SQLException will be thrown)
# runPooledMode : Whether the pool should return a pooled connection, or a the actual non-wrapped connection from the driver (true/false). If false, then it will effectively disable all pooling (ie close will actually close the physical connection, not return it to a pool).
# connectionAutoCommit : Whether when a connection is handed out, auto commit should be on or off. Default is 'true', options are 'true' or 'false'
# connectionTransactionIsolation : The transaction isolation level. See the website faq for more info. Default is to use the driver's default - omit the setting for this.
#
# More info on these settings can be found a [URL unfurl="true"]http://www.primrose.org.uk/docs/controllerView.jsp[/URL]
#
# -----------------------------------------------------------------------------------------------
#
# Example connection strings :
# -----------------------------------------------------------------------------------------------
# Oracle database connection details
#user=oracops
#password=dev
#driverClass=oracle.jdbc.driver.OracleDriver
#driverURL=jdbc:oracle:thin:@hostname:1521:SID
#
# MySQL database connection details
#driverClass=com.mysql.jdbc.Driver
#driverURL=jdbc:mysql://hostname:3306/db_name
#user=
#password=
# -----------------------------------------------------------------------------------------------
# -----------------------------------------------------------------------------------------------
#########################
#### Admin settings ####
#########################
adminUser=admin
adminPassword=password
adminWebManagementPort=8090
adminEmailAddresses=joe@bloggs.com,foo@bar.com
adminEmailNotifcations=true
adminEmailSMTPServer=my.smpt.server
adminEmailCrisisAddress=someone@important.com
adminEmailNotificationPeriod=10000
adminEmailMaxWarningNumber=10
adminPoolControllerLogFile=/var/log/PoolController.log
#################################
#### Example Pool Instances #####
#################################
##### webmap pool instance #####
poolName=webmap
base=5
overflow=1
log=/var/log/pools_${yyyy-MM-dd}.log
idleTime=120000
messageLogging=true
sizeLogging=true
driverClass=com.mysql.jdbc.Driver
driverURL=jdbc:mysql://localhost:3306/test
user=
password=
killActiveConnectionsOverAge=120000
cycleConnections=1000
queueConnectionRequests=true
runPooledMode=true
connectionAutoCommit=true
#connectionTransactionIsolation=TRANSACTION_READ_COMMITTED
##### LoginDB pool instance #####
poolName=LoginDB
base=5
overflow=1
log=/var/log/pools_${yyyy-MM-dd}.log
idleTime=120000
messageLogging=true
sizeLogging=true
driverClass=com.mysql.jdbc.Driver
driverURL=jdbc:mysql://localhost:3306/test
user=
password=
killActiveConnectionsOverAge=120000
cycleConnections=1000
queueConnectionRequests=true
runPooledMode=true
connectionAutoCommit=true
#connectionTransactionIsolation=TRANSACTION_READ_COMMITTED
poolName=OraConnect
base=5
overflow=1
log=/var/log/pools_${yyyy-MM-dd}.log
idleTime=120000
messageLogging=true
sizeLogging=true
driverClass=oracle.jdbc.driver.OracleDriver
driverURL=jdbc:oracle:thin:@192.168.0.1:1521:mysid
user=rsuser
password=passxyz
killActiveConnectionsOverAge=120000
cycleConnections=1000
queueConnectionRequests=true
runPooledMode=true
connectionAutoCommit=true
#connectionTransactionIsolation=TRANSACTION_READ_COMMITTED
