## Connection Pool Configuration file ##

# Time in days between connection resets. (Reset does a basic cleanup)
 maxConnTime=0.5

 # Append to logfile
 logAppend=true

 # Max time a connection can be checked out before being recycled. Zero value turns option off, default is 60 seconds
 maxCheckoutSeconds=180

 # Level of debug messages output to the log file.  0 -> no messages, 1 -> Errors, 2 -> Warnings, 3 -> Information
 debugLevel= 0

 # (Optional) If all connections are in use the Broker waits for 2 seconds and tries again, up to this value number of times.
 # After that it returns null. Default value is 10
 retryCount=20

 minConns=20
 maxConns=30
##########################    ORACLE   #################################################

 #destroyLogFile=bmp_ora_db_pool_stats.log.xml
 #dbDriver=oracle.jdbc.driver.OracleDriver
 #dbServer=jdbc:oracle:thin:@10.40.48.60:1521:BPMTPD
 #dbLogin= BPM_TEST
 #dbPassword=BPM_TEST
 #dbSchema = BPM_TEST
 ##useSchemaPrefix = true
 #logFileString=bpm_ora_db_pool.log



########################  MS SQL SERVER #################################################
 #destroyLogFile=bmp_mssql_db_pool_stats.log.xml
 #dbDriver=com.microsoft.sqlserver.jdbc.SQLServerDriver
 #dbServer=jdbc:sqlserver://nikitas:1433;SelectMethod=direct;ProgramName=VELTI_BPM_DIRECT;DatabaseName=PIRAEUS_BPM
 #dbLogin=workflow
 #dbPassword=workflow_xyz
 #logFileString=bpm_mssql_db_pool.log


 ########################  MS SQL SERVER 2005 #################################################
 destroyLogFile=bmp_mssql_db_pool_stats.log.xml
 dbDriver=com.microsoft.sqlserver.jdbc.SQLServerDriver
 #dbServer=jdbc:sqlserver://localhost:1433;SelectMethod=cursor;applicationName=VELTINET_BPM;DatabaseName=DE_CAMPAIGNS
 dbServer=jdbc:sqlserver://localhost;instanceName=SQLEXPRESS;SelectMethod=cursor;applicationName=KARELIA_BPM;DatabaseName=bpm_product
 #dbServer=jdbc:sqlserver://10.40.48.61:1432;SelectMethod=cursor;applicationName=VELTINET_BPM;DatabaseName=VELTI_DE_DEV
 dbLogin=workflow
 dbPassword=workflow_xyz
 dbSchema=
 logFileString=bpm_mssql_db_pool.log

  ########################  MY SQL SERVER #################################################

 #destroyLogFile=bmp_mssql_db_pool_stats.log.xml
 #dbDriver=com.mysql.jdbc.Driver
 #dbServer=jdbc:mysql://LOCALHOST:3306/PIRAEUS_BPM
 #dbLogin=workflow
 #dbPassword=workflow_xyz
 #logFileString=bpm_mssql_db_pool.log



## Connection Pool Configuration file ##
#  !!!! sendStringParametersAsUnicode=false  !!!!