fmeDatabaseConfig.txt

##########################################
# FME Flow Database Config File Parameters
##########################################
#
# Changes to any parameter value in this file will take effect only upon
# subsequent restart of the FME Flow.
#
# 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={{if exists "/pgsqlconnectionstring"}}{{getv "/pgsqlconnectionstring"}}{{else}}jdbc:postgresql://{{getv "/pgsqlhostname" "localhost"}}:{{getv "/pgsqlport" "7082"}}/{{getv "/pgsqldatabasename" "fmeserver"}}{{end}}
{{getv "/pgsqlcomment" ""}}DB_USERNAME={{getv "/pgsqlusername" "fmeserver"}}
{{getv "/pgsqlcomment" ""}}DB_PASSWORD={{if exists "/pgsqlpasswordencrypted"}}{{getv "/pgsqlpasswordencrypted"}}{{else}}{{if exists "/pgsqlpasswordescaped"}}{{getv "/pgsqlpasswordescaped"}}{{else}}{{getv "/pgsqlpassword"}}{{end}}{{end}}
{{getv "/pgsqlcomment" ""}}DB_CONNECT_EXPIRY=60
{{getv "/pgsqlcomment" ""}}DB_SQLSTMTS_PATH={{getv "/installdir"}}/Server/database
 
{{getv "/sqlservercomment" "#"}}DB_TYPE=sqlserver
{{getv "/sqlservercomment" "#"}}DB_DRIVER=com.microsoft.sqlserver.jdbc.SQLServerDriver
{{getv "/sqlservercomment" "#"}}DB_JDBC_URL={{if exists "/sqlserverconnectionstring"}}{{getv "/sqlserverconnectionstring"}}{{else}}jdbc:sqlserver://{{getv "/sqlserverhostname" "localhost"}};port={{getv "/sqlserverport" "1433"}};databaseName={{getv "/sqlserverdatabasename" "fmeserver"}};encrypt=true;trustServerCertificate=true{{end}}
{{getv "/sqlservercomment" "#"}}DB_USERNAME={{getv "/sqlserverusername" "fmeserver"}}
{{getv "/sqlservercomment" "#"}}DB_PASSWORD={{if exists "/sqlserverpasswordencrypted"}}{{getv "/sqlserverpasswordencrypted"}}{{else}}{{getv "/sqlserverpasswordescaped" "$FME$1ser$ver"}}{{end}}
{{getv "/sqlservercomment" "#"}}DB_CONNECT_EXPIRY=60
{{getv "/sqlservercomment" "#"}}DB_SQLSTMTS_PATH={{getv "/installdir"}}/Server/database
 
{{getv "/oraclecomment" "#"}}DB_TYPE=oracle
{{getv "/oraclecomment" "#"}}DB_DRIVER=oracle.jdbc.driver.OracleDriver
{{getv "/oraclecomment" "#"}}DB_JDBC_URL={{if exists "/oracleconnectionstring"}}{{getv "/oracleconnectionstring"}}{{else}}jdbc:oracle:thin:@{{getv "/oraclehostname" "localhost"}}:{{getv "/oracleport" "1521"}}/{{getv "/oracleservicename" "oracle"}}{{end}}
{{getv "/oraclecomment" "#"}}DB_USERNAME="{{getv "/oracleusername" "fmeserver"}}"
{{getv "/oraclecomment" "#"}}DB_PASSWORD={{if exists "/oraclepasswordencrypted"}}{{getv "/oraclepasswordencrypted"}}{{else}}{{getv "/oraclepasswordescaped" "fmeserver"}}{{end}}
{{getv "/oraclecomment" "#"}}DB_CONNECT_EXPIRY=60
{{getv "/oraclecomment" "#"}}DB_SQLSTMTS_PATH={{getv "/installdir"}}/Server/database
 
# ************** FME SERVER SETTINGS END **************