fmeDatabaseConfig.txt

##########################################
# FME Server Database Config File Parameters
##########################################
#
# Changes to any parameter value in this file will take effect only upon
# subsequent restart of the FME Server.
#
# The following parameters must be present in the config file and named exactly
# as shown:
#
#--------------------------------------------------------------------------
# Database Connection
#--------------------------------------------------------------------------
# DB_TYPE - Identifies specific database in use: postgresql, sqlserver, oracle.
#
# DB_DRIVER - JDBC driver name used for connecting to the Repository database.
#
# DB_JDBC_URL - JDBC url used for connecting to the Repository database.
#
# DB_USERNAME - Repository database user name
#
# DB_PASSWORD - Repository database user password
#
# DB_CONNECT_EXPIRY - Database connection expiry in seconds
#
# DB_NUM_STMT_LIMIT - (Optional) The limit on JDBC statements per JDBC connection. Upon commiting a JDBC transaction,
# if the number of JDBC statements for the JDBC connection exceed this limit, all JDBC
# statements will be closed. If not specified, no limit is set on JDBC statements per JDBC connection.
#
# DB_SQLSTMTS_PATH - The path to the SQL statement resource bundle
#
# Examples:
#
# DB_TYPE=postgresql
# DB_DRIVER=org.postgresql.Driver
# DB_JDBC_URL=jdbc:postgresql://localhost:5432/fmeserver
# DB_USERNAME=fmeserver
# DB_PASSWORD=fmeserver
# DB_CONNECT_EXPIRY=60
# DB_SQLSTMTS_PATH=C:/Apps/FMEServer/Server/database
#
# DB_TYPE=sqlserver
# DB_DRIVER=com.microsoft.sqlserver.jdbc.SQLServerDriver
# DB_JDBC_URL=jdbc:sqlserver://localhost/SQLEXPRESS
# DB_USERNAME=fmeserver
# DB_PASSWORD=$FMEserver
# DB_CONNECT_EXPIRY=60
# DB_SQLSTMTS_PATH=C:/Apps/FMEServer/Server/database
#
# DB_TYPE=oracle
# DB_DRIVER=oracle.jdbc.driver.OracleDriver
# DB_JDBC_URL=jdbc:oracle:thin:@localhost:1521:orcl
# DB_USERNAME=fmeserver
# DB_PASSWORD=fmeserver
# DB_CONNECT_EXPIRY=60
# DB_SQLSTMTS_PATH=C:/Apps/FMEServer/Server/database
#
#--------------------------------------------------------------------------
 
# ************** FME SERVER SETTINGS START **************
 
#-------------------------------------------------------------------------------
# Database Connection
#-------------------------------------------------------------------------------
{{getv "/pgsqlcomment"}}DB_TYPE=postgresql
{{getv "/pgsqlcomment"}}DB_DRIVER=org.postgresql.Driver
{{getv "/pgsqlcomment"}}DB_JDBC_URL={{getv "/pgsqlconnectionstring"}}
{{getv "/pgsqlcomment"}}DB_USERNAME={{getv "/pgsqlusername"}}
{{getv "/pgsqlcomment"}}DB_PASSWORD={{if exists "/pgsqlpasswordencrypted"}}{{getv "/pgsqlpasswordencrypted"}}{{else}}{{getv "/pgsqlpassword"}}{{end}}
{{getv "/pgsqlcomment"}}DB_CONNECT_EXPIRY=60
{{getv "/pgsqlcomment"}}DB_SQLSTMTS_PATH={{getv "/serverdir"}}/database
 
{{getv "/sqlservercomment"}}DB_TYPE=sqlserver
{{getv "/sqlservercomment"}}DB_DRIVER=com.microsoft.sqlserver.jdbc.SQLServerDriver
{{getv "/sqlservercomment"}}DB_JDBC_URL={{getv "/sqlserverconnectionstring"}}
{{getv "/sqlservercomment"}}DB_USERNAME={{getv "/sqlserverusername"}}
{{getv "/sqlservercomment"}}DB_PASSWORD={{if exists "/sqlserverpasswordencrypted"}}{{getv "/sqlserverpasswordencrypted"}}{{else}}{{getv "/sqlserverpassword"}}{{end}}
{{getv "/sqlservercomment"}}DB_CONNECT_EXPIRY=60
{{getv "/sqlservercomment"}}DB_SQLSTMTS_PATH={{getv "/serverdir"}}/database
 
{{getv "/oraclecomment"}}DB_TYPE=oracle
{{getv "/oraclecomment"}}DB_DRIVER=oracle.jdbc.driver.OracleDriver
{{getv "/oraclecomment"}}DB_JDBC_URL={{getv "/oracleconnectionstring"}}
{{getv "/oraclecomment"}}DB_USERNAME="{{getv "/oracleusername"}}"
{{getv "/oraclecomment"}}DB_PASSWORD={{if exists "/oraclepasswordencrypted"}}{{getv "/oraclepasswordencrypted"}}{{else}}{{getv "/oraclepassword"}}{{end}}
{{getv "/oraclecomment"}}DB_CONNECT_EXPIRY=60
{{getv "/oraclecomment"}}DB_SQLSTMTS_PATH={{getv "/serverdir"}}/database
 
# ************** FME SERVER SETTINGS END **************