#--------------------------------------------------------------------------
# JCLIC REPORTS SERVER SETTINGS
#--------------------------------------------------------------------------

#--------------------------------------------------------------------------
# Name of the JDBC driver
#--------------------------------------------------------------------------
# Examples:  ODBC: sun.jdbc.odbc.JdbcOdbcDriver
#            MySQL: com.mysql.jdbc.Driver
#            PointBase: com.pointbase.jdbc.jdbcUniversalDriver
#            Oracle: oracle.jdbc.driver.OracleDriver
#--------------------------------------------------------------------------
# ---Lliurex 02.05.2013 ---
dbDriver=com.mysql.jdbc.Driver
# ---Lliurex 02.05.2013 ---
#dbDriver=sun.jdbc.odbc.JdbcOdbcDriver


#--------------------------------------------------------------------------
# URL of the the database
#--------------------------------------------------------------------------
# Examples:  ODBC: jdbc:odbc:JClic
#            MySQL: jdbc:mysql://localhost/JClicReports
#            PointBase: jdbc:pointbase:jclic
#            Oracle: jdbc:oracle:thin:@server.domain.com:1521:database
#--------------------------------------------------------------------------
# ---Lliurex 02.05.2013 ---
#dbServer=jdbc:odbc:JClic
# ---Lliurex 02.05.2013 ---
dbServer=jdbc:mysql://127.0.0.1/JClicReports?autoReconnect=true&relaxAutoCommit=true


#--------------------------------------------------------------------------
# DB system username and password (not mandatory in some DBMS)
#--------------------------------------------------------------------------
#dbLogin=clic_user
#dbPassword=clic_pwd
# ---Lliurex 02.05.2013 ---
dbLogin=jclic_user
dbPassword=jclic_pwd
# If password changed remember to update it in jclic.sgbd template
# ---Lliurex 02.05.2013 ---

#--------------------------------------------------------------------------
# If not exist, automatically create tables on first run
#--------------------------------------------------------------------------
createTables=true


#--------------------------------------------------------------------------
# String that will be used as prefix for table names
#--------------------------------------------------------------------------
tablePrefix=JCLIC_


#--------------------------------------------------------------------------
# Automatically start services
#--------------------------------------------------------------------------
autostart=true
http_autostart=true


#--------------------------------------------------------------------------
# Provide console/log info on each transaction
#--------------------------------------------------------------------------
verbose=true

#--------------------------------------------------------------------------
# Language to be used (ISO-639 two-letter language codes)
#--------------------------------------------------------------------------
#language=ca

#--------------------------------------------------------------------------
# If set, write logs to file
#--------------------------------------------------------------------------
http_logFile=

#--------------------------------------------------------------------------
# Maximum time to wait for idle connections (in milliseconds)
#--------------------------------------------------------------------------
http_timeout=1200
timeout=1200

#--------------------------------------------------------------------------
# Parameters related to the pool of database connections
#--------------------------------------------------------------------------

# Reuse preparedStatements
dbMapStatements=true

# Absolute path name for log file. e.g. 'c:/temp/mylog.log'.
# Default is 'jclicReportsDBConnection.log' in user's home dir.
dbLogFile=jclicReportsDBConnection.log

# Append to logfile. Default is true.
dbLogAppend=true

# Minimum number of connections to start with. default is 1
dbMinConns=1

# Maximum number of connections in dynamic pool. Default is 3
dbMaxConns=3

# Time in days between connection resets. (Reset does a basic cleanup). Default is 1.0
dbMaxConnDays=1.0

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

# Max time a connection can be checked out before being recycled.
# Zero value turns option off. Default is 60.
dbMaxCheckoutSeconds=60

#--------------------------------------------------------------------------
# Parameters related to the drawing of graphics
#--------------------------------------------------------------------------
graph_width=440
graph_dist_width=192
graph_height=155
graph_header_height=25
# ---Lliurex 02.05.2013 ---
browser=firefox
# ---Lliurex 02.05.2013 ---
graph_margin=8
graph_color_bg=F0F8FF
graph_color_text=000000
graph_color_border=FFFFFF
graph_color_v1=D00000
graph_color_v2=00D000
graph_color_dist=0000D0
graph_color_alert=FF0000
graph_stroke_width=3.0
graph_font_family=Dialog
graph_font_size=11
graph_margin_x=50
graph_margin_y=20
graph_div_y=4
graph_max_cols=10
graph_margin_dist_x=15
graph_margin_dist_y=20
graph_color_header_bg=ADD8E6
graph_color_header_text=000000