config/Openbravo.properties.template
author Stefan Hühner <stefan.huehner@openbravo.com>
Tue, 13 Oct 2009 10:18:40 +0200
changeset 5218 98441eb82542
parent 4912 ef4ffe20b420
child 5235 fd2af2f70372
permissions -rw-r--r--
Fixed 4038: Improve SqlC performance at compile time
- Include optional parameters in SqlC query execution at compile time as this
leads to better performance in many cases
- This requires the optional parameters to be valid parts of an SQL statement
- New behavior can be configured via new Openbravo.properties setting:
sqlc.queryExecutionStrategy=traditional,optimized
- Enable optimizedby default (in template and when new setting is missing)
- Enable for processing src/ folder. Disable by default for srcAD/ and modules/
to not impose stricter requirements on modules.
carlos@0
     1
# *************************************************************************
carlos@0
     2
# * The contents of this file are subject to the Openbravo  Public  License
carlos@0
     3
# * Version  1.0  (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. 
carlos@0
    12
# * The Initial Developer of the Original Code is Openbravo SL 
juanpablo@579
    13
# * All portions are Copyright (C) 2007-2008 Openbravo SL 
carlos@0
    14
# * All Rights Reserved. 
carlos@0
    15
# * Contributor(s):  ______________________________________.
carlos@0
    16
# ************************************************************************
carlos@0
    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@41
    28
juanpablo@1890
    29
###########
juanpablo@1890
    30
# General #
juanpablo@1890
    31
###########
juanpablo@1890
    32
juanpablo@1890
    33
# Static content URL. Use the default value to make it dynamic.
juanpablo@1890
    34
# Don't change this unless you know what you are doing
juanpablo@1890
    35
web.url=@actual_url_context@/web
juanpablo@1890
    36
juanpablo@1890
    37
# Full URL of the context, *only* used by the Web Services installation
juanpablo@1890
    38
context.url=http://localhost:8080/openbravo
juanpablo@1890
    39
juanpablo@1890
    40
# Absolute path to the attachments directory
juanpablo@1890
    41
attach.path=/opt/openbravo/attachments
juanpablo@1890
    42
juanpablo@1890
    43
# Context name, used in the final war file
juanpablo@1890
    44
context.name=openbravo
juanpablo@1890
    45
juanpablo@1891
    46
# Root sources directory, used by modularity
juanpablo@1891
    47
source.path=/opt/openbravo
juanpablo@1891
    48
ivan@4912
    49
#Deploy mode: valid values [class, war, none]
asier@1977
    50
deploy.mode=class
asier@1977
    51
juanpablo@1890
    52
############
juanpablo@1890
    53
# Database #
juanpablo@1890
    54
############
juanpablo@1890
    55
juanpablo@2208
    56
# Oracle example:
juanpablo@1890
    57
#
juanpablo@2744
    58
# bbdd.rdbms=ORACLE
juanpablo@2744
    59
# bbdd.driver=oracle.jdbc.driver.OracleDriver
juanpablo@2744
    60
# bbdd.url=jdbc:oracle:thin:@localhost:1521:xe
juanpablo@2208
    61
# bbdd.sid=xe
juanpablo@2208
    62
# bbdd.systemUser=SYSTEM
juanpablo@2208
    63
# bbdd.systemPassword=SYSTEM
juanpablo@2208
    64
# bbdd.user=TAD
juanpablo@2208
    65
# bbdd.password=TAD
juanpablo@2208
    66
# bbdd.sessionConfig=ALTER SESSION SET NLS_DATE_FORMAT='DD-MM-YYYY' NLS_NUMERIC_CHARACTERS='.,'
juanpablo@1890
    67
juanpablo@2744
    68
bbdd.rdbms=POSTGRE
juanpablo@2744
    69
bbdd.driver=org.postgresql.Driver
juanpablo@2744
    70
bbdd.url=jdbc:postgresql://localhost:5432
juanpablo@2208
    71
bbdd.sid=openbravo
juanpablo@2209
    72
bbdd.systemUser=postgres
juanpablo@2208
    73
bbdd.systemPassword=syspass
juanpablo@2208
    74
bbdd.user=tad
juanpablo@2208
    75
bbdd.password=tad
juanpablo@2208
    76
bbdd.sessionConfig=select update_dateFormat('DD-MM-YYYY')
asier@41
    77
juanpablo@2744
    78
##################
juanpablo@2744
    79
# Tomcat manager #
juanpablo@2744
    80
##################
juanpablo@2744
    81
#
juanpablo@2744
    82
tomcat.manager.url=http://localhost:8080/manager
juanpablo@2744
    83
tomcat.manager.username=admin
juanpablo@2744
    84
tomcat.manager.password=admin
juanpablo@2744
    85
juanpablo@1890
    86
##########################
juanpablo@1890
    87
# Development parameters #
juanpablo@1890
    88
##########################
juanpablo@481
    89
juanpablo@578
    90
bbdd.outputscript=databasescript.sql
juanpablo@481
    91
bbdd.verbosity=INFO
gorkaion@1048
    92
juanpablo@1890
    93
# CSS Sprites Generator
david@1883
    94
generateSprites=no
david@1883
    95
stefan@2143
    96
# use js/css minimization (in local-context and war-file)
stefan@2143
    97
minimizeJSandCSS=yes
stefan@2143
    98
stefan@5218
    99
# How sqlc should execute the queries embedded in xsql file at compilation time
stefan@5218
   100
# traditional: only uses the base query ignoring all optional parameters
stefan@5218
   101
# optimized: includes most optional parameter to achieve better performance
stefan@5218
   102
# If optimized fails for some xsql files, downgrade level to traditional
stefan@5218
   103
sqlc.queryExecutionStrategy=optimized
stefan@5218
   104
juanpablo@1890
   105
##################
juanpablo@1890
   106
# Authentication #
juanpablo@1890
   107
##################
juanpablo@1890
   108
juanpablo@1890
   109
# Leave this empty to use the default login hardler.
juanpablo@1890
   110
# LAM server example: org.openbravo.authentication.lam.LamAuthenticationManager
gorkaion@1048
   111
authentication.class=
juanpablo@1890
   112
juanpablo@1890
   113
###########
juanpablo@1890
   114
# Add-ons #
juanpablo@1890
   115
###########
juanpablo@1890
   116
juanpablo@1890
   117
# External Pentaho Services
juanpablo@1890
   118
pentahoServer=
antonio@3077
   119
antonio@3077
   120
##############
antonio@3077
   121
# Validation #
antonio@3077
   122
##############
antonio@3077
   123
asier@3741
   124
validate.model=true
asier@3741
   125
isMinorVersion=false