config/Openbravo.properties.template
author Inigo Sanchez <inigo.sanchez@openbravo.com>
Wed, 29 Apr 2015 17:27:08 +0200
changeset 27212 50a6ae8fce11
parent 19952 0c44af13571d
child 27231 95dbfa7a5904
permissions -rw-r--r--
[pool] moved pool default settings to Openbravo.properties

Apache jdbc connection pool is now used by default
carlos@0
     1
# *************************************************************************
carlos@0
     2
# * The contents of this file are subject to the Openbravo  Public  License
priya@9072
     3
# * Version  1.1  (the  "License"),  being   the  Mozilla   Public  License
carlos@0
     4
# * Version 1.1  with a permitted attribution clause; you may not  use this
carlos@0
     5
# * file except in compliance with the License. You  may  obtain  a copy of
carlos@0
     6
# * the License at http://www.openbravo.com/legal/license.html 
carlos@0
     7
# * Software distributed under the License  is  distributed  on  an "AS IS"
carlos@0
     8
# * basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the
carlos@0
     9
# * License for the specific  language  governing  rights  and  limitations
carlos@0
    10
# * under the License. 
carlos@0
    11
# * The Original Code is Openbravo ERP. 
ggi@6701
    12
# * The Initial Developer of the Original Code is Openbravo SLU 
inigo@27212
    13
# * All portions are Copyright (C) 2007-2015 Openbravo SLU 
carlos@0
    14
# * All Rights Reserved. 
carlos@0
    15
# * Contributor(s):  ______________________________________.
carlos@0
    16
# ************************************************************************
harpreet@5488
    17
#
juanpablo@2744
    18
# Documentation at http://wiki.openbravo.com/wiki/Openbravo.properties
juanpablo@2744
    19
juanpablo@1890
    20
####################
juanpablo@1890
    21
# Date/time format #
juanpablo@1890
    22
####################
juanpablo@1890
    23
juanpablo@481
    24
dateFormat.js=%d-%m-%Y
juanpablo@481
    25
dateFormat.sql=DD-MM-YYYY
juanpablo@481
    26
dateFormat.java=dd-MM-yyyy
juanpablo@481
    27
dateTimeFormat.java=dd-MM-yyyy HH:mm:ss
asier@5235
    28
dateTimeFormat.sql=DD-MM-YYYY HH24:MI:SS
asier@41
    29
juanpablo@1890
    30
###########
juanpablo@1890
    31
# General #
juanpablo@1890
    32
###########
juanpablo@1890
    33
juanpablo@1890
    34
# Static content URL. Use the default value to make it dynamic.
juanpablo@1890
    35
# Don't change this unless you know what you are doing
juanpablo@1890
    36
web.url=@actual_url_context@/web
juanpablo@1890
    37
asier@13271
    38
# Full URL of the context, *only* used by the Web Services installation 
asier@13271
    39
# and diagnostic task
juanpablo@1890
    40
context.url=http://localhost:8080/openbravo
juanpablo@1890
    41
juanpablo@1890
    42
# Absolute path to the attachments directory
juanpablo@1890
    43
attach.path=/opt/openbravo/attachments
juanpablo@1890
    44
juanpablo@1890
    45
# Context name, used in the final war file
juanpablo@1890
    46
context.name=openbravo
juanpablo@1890
    47
juanpablo@1891
    48
# Root sources directory, used by modularity
juanpablo@1891
    49
source.path=/opt/openbravo
juanpablo@1891
    50
ivan@4912
    51
#Deploy mode: valid values [class, war, none]
asier@1977
    52
deploy.mode=class
asier@1977
    53
juanpablo@1890
    54
############
juanpablo@1890
    55
# Database #
juanpablo@1890
    56
############
juanpablo@1890
    57
juanpablo@2208
    58
# Oracle example:
juanpablo@1890
    59
#
juanpablo@2744
    60
# bbdd.rdbms=ORACLE
juanpablo@2744
    61
# bbdd.driver=oracle.jdbc.driver.OracleDriver
juanpablo@2744
    62
# bbdd.url=jdbc:oracle:thin:@localhost:1521:xe
juanpablo@2208
    63
# bbdd.sid=xe
juanpablo@2208
    64
# bbdd.systemUser=SYSTEM
juanpablo@2208
    65
# bbdd.systemPassword=SYSTEM
juanpablo@2208
    66
# bbdd.user=TAD
juanpablo@2208
    67
# bbdd.password=TAD
juanpablo@2208
    68
# bbdd.sessionConfig=ALTER SESSION SET NLS_DATE_FORMAT='DD-MM-YYYY' NLS_NUMERIC_CHARACTERS='.,'
juanpablo@1890
    69
antonio@7580
    70
# Oracle instances in linux, can delay on getting DB connection (issue #12683). 
antonio@7580
    71
# In these cases this property can be set to solve the problem
antonio@7580
    72
# java.security.egd=file:///dev/urandom
antonio@7580
    73
juanpablo@2744
    74
bbdd.rdbms=POSTGRE
juanpablo@2744
    75
bbdd.driver=org.postgresql.Driver
juanpablo@2744
    76
bbdd.url=jdbc:postgresql://localhost:5432
juanpablo@2208
    77
bbdd.sid=openbravo
juanpablo@2209
    78
bbdd.systemUser=postgres
juanpablo@2208
    79
bbdd.systemPassword=syspass
juanpablo@2208
    80
bbdd.user=tad
juanpablo@2208
    81
bbdd.password=tad
juanpablo@2208
    82
bbdd.sessionConfig=select update_dateFormat('DD-MM-YYYY')
asier@41
    83
inigo@27212
    84
######################
inigo@27212
    85
# DB connection pool #
inigo@27212
    86
######################
inigo@27212
    87
inigo@27212
    88
externalPoolClassName=org.openbravo.apachejdbcconnectionpool.JdbcExternalConnectionPool
inigo@27212
    89
inigo@27212
    90
# Documentation at http://www.tomcatexpert.com/blog/2010/04/01/configuring-jdbc-pool-high-concurrency
inigo@27212
    91
initialSize=5
inigo@27212
    92
maxActive=30
inigo@27212
    93
maxIdle=30
inigo@27212
    94
minIdle=5
inigo@27212
    95
maxWait=50
inigo@27212
    96
timeBetweenEvictionRunsMillis=30000
inigo@27212
    97
minEvictableIdleTimeMillis=30000
inigo@27212
    98
removeAbandoned=true
inigo@27212
    99
removeAbandonedTimeout=60
inigo@27212
   100
logAbandoned=false
inigo@27212
   101
jmxEnabled=true
inigo@27212
   102
testWhileIdle=false
inigo@27212
   103
testOnBorrow=true
inigo@27212
   104
validationQuery=SELECT 1 FROM DUAL
inigo@27212
   105
validationInterval=30000
inigo@27212
   106
testOnReturn=false
inigo@27212
   107
juanpablo@2744
   108
##################
juanpablo@2744
   109
# Tomcat manager #
juanpablo@2744
   110
##################
asier@13271
   111
asier@13271
   112
# From Tomcat 7 manager url is host/manager/text. In previous versions it is
asier@13271
   113
# host/manager
juanpablo@2744
   114
tomcat.manager.url=http://localhost:8080/manager
asier@13271
   115
asier@13271
   116
# From Tomcat 7 this user must have manager-script role access. In previous
asier@13271
   117
# versions. In previous versions it must have manager role access.
juanpablo@2744
   118
tomcat.manager.username=admin
juanpablo@2744
   119
tomcat.manager.password=admin
juanpablo@2744
   120
juanpablo@1890
   121
##########################
juanpablo@1890
   122
# Development parameters #
juanpablo@1890
   123
##########################
juanpablo@481
   124
juanpablo@578
   125
bbdd.outputscript=databasescript.sql
juanpablo@481
   126
bbdd.verbosity=INFO
gorkaion@1048
   127
stefan@2143
   128
# use js/css minimization (in local-context and war-file)
stefan@2143
   129
minimizeJSandCSS=yes
stefan@2143
   130
stefan@5218
   131
# How sqlc should execute the queries embedded in xsql file at compilation time
stefan@5218
   132
# traditional: only uses the base query ignoring all optional parameters
stefan@5218
   133
# optimized: includes most optional parameter to achieve better performance
stefan@5218
   134
# If optimized fails for some xsql files, downgrade level to traditional
stefan@5218
   135
sqlc.queryExecutionStrategy=optimized
stefan@5218
   136
juanpablo@1890
   137
##################
juanpablo@1890
   138
# Authentication #
juanpablo@1890
   139
##################
juanpablo@1890
   140
stefan@8788
   141
# Leave this empty to use the default login handler.
stefan@11875
   142
# Examples:
stefan@11875
   143
# - org.openbravo.authentication.basic.AutologonAuthenticationManager (included)
stefan@11875
   144
# - org.openbravo.authentication.lam.LamAuthenticationManager (in external 'LAM Authentication Manager' module)
gorkaion@1048
   145
authentication.class=
juanpablo@1890
   146
juanpablo@1890
   147
###########
juanpablo@1890
   148
# Add-ons #
juanpablo@1890
   149
###########
juanpablo@1890
   150
juanpablo@1890
   151
# External Pentaho Services
juanpablo@1890
   152
pentahoServer=
antonio@3077
   153
antonio@3077
   154
##############
antonio@3077
   155
# Validation #
antonio@3077
   156
##############
antonio@3077
   157
asier@3741
   158
validate.model=true
asier@3741
   159
isMinorVersion=false
antonio@5601
   160
antonio@5601
   161
##############
antonio@5601
   162
# Safe mode  #
antonio@5601
   163
##############
antonio@5601
   164
antonio@5606
   165
# This property is used to activate/deactivate the safe mode of Openbravo ERP
antonio@5606
   166
# When this property is activated, if the last build wasn't succesful, or Tomcat
antonio@5606
   167
# wasn't restarted, users will only be able to login in the application 
antonio@5606
   168
# with role System Administrator
antonio@5606
   169
antonio@6463
   170
safe.mode=true
martin@5990
   171
antonio@7709
   172
################################
antonio@7709
   173
# Strict Template Application  #
antonio@7709
   174
################################
antonio@7709
   175
antonio@7709
   176
# This property is used to set the configuration script application mode.
antonio@7709
   177
# If the template application mode is strict, then inconsistencies in the template
antonio@7709
   178
# (such as the value to be changed being different from the value in a column
antonio@7709
   179
# data change of a configuration script) will make the process fail.
antonio@7709
   180
# If it's not strict the process will show a warning, but otherwise continue
antonio@7709
   181
antonio@7709
   182
# For production environments, this property should be false.
antonio@7709
   183
# For development environments, specially those working with
antonio@7709
   184
# Industry templates and configuration scripts, it is advisable to set this property to true
antonio@7709
   185
antonio@7709
   186
strict.template.application=false
antonio@7709
   187
martin@5990
   188
##############
martin@5990
   189
# Hibernate #
martin@5990
   190
##############
martin@5990
   191
martin@5990
   192
# if this property is set then the mapping will be written to the file
martin@5990
   193
# defined by this property, note the value should be the complete path 
martin@5990
   194
# including the file name and extension.
martin@5990
   195
# hibernate.hbm.file=/tmp/hibernate.hbm.xml
asier@6753
   196
asier@6753
   197
asier@6755
   198
###################
asier@6755
   199
# Log in security #
asier@6755
   200
###################
asier@6753
   201
stefan@8788
   202
# If these properties are set, after a failed login the response time 
stefan@8788
   203
# will be delayed, and the user account can be blocked.
asier@6769
   204
login.trial.delay.increment=0
asier@6769
   205
login.trial.delay.max=0
asier@6753
   206
login.trial.user.lock=0
juanpablo@7927
   207
asier@16644
   208
# Prevents concurrent sessions for same user.
asier@16644
   209
login.limit.user.session=false
asier@16644
   210
juanpablo@7927
   211
##########
juanpablo@7927
   212
# Others #
juanpablo@7927
   213
##########
juanpablo@7927
   214
juanpablo@7927
   215
# You are not allowed to run ant commands with the root user.
juanpablo@7927
   216
# Set allow.root to true to override this.
juanpablo@7927
   217
allow.root=false
martin@12257
   218
martin@12257
   219
# Specifies if the current instance is used for automated tests.
martin@12257
   220
# Setting this to true will enable extra (hidden) functionality used 
martin@12257
   221
# automated test scripts.
asier@16644
   222
test.environment=false
asier@18214
   223
asier@18214
   224
# allows to compile classic 2.50 windows for all available tab
asier@18214
   225
# By default those all not generated anymore for tabs for which they are not needed
asier@18214
   226
#wad.generateAllClassic250Windows=true
asier@18214
   227
asier@19230
   228
# background.policy property defines whether background processes should be
asier@19230
   229
# executed in this context or not. To prevent process execution this property must
asier@19230
   230
# be set to no-execute
asier@19230
   231
background.policy=default
asier@19230
   232
asier@19230
   233