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
#-------------------------------------------------------------------------------
{SAFE{pgsqlComment}}DB_TYPE=postgresql
{SAFE{pgsqlComment}}DB_DRIVER=org.postgresql.Driver
{SAFE{pgsqlComment}}DB_JDBC_URL={SAFE{pgsqlConnectionString}}
{SAFE{pgsqlComment}}DB_USERNAME={SAFE{pgsqlUsername}}
{SAFE{pgsqlComment}}DB_PASSWORD={SAFE{pgsqlPassword}}
{SAFE{pgsqlComment}}DB_CONNECT_EXPIRY=60
{SAFE{pgsqlComment}}DB_SQLSTMTS_PATH={SAFE{serverDir}}/database
 
{SAFE{sqlserverComment}}DB_TYPE=sqlserver
{SAFE{sqlserverComment}}DB_DRIVER=com.microsoft.sqlserver.jdbc.SQLServerDriver
{SAFE{sqlserverComment}}DB_JDBC_URL={SAFE{sqlserverConnectionString}}
{SAFE{sqlserverComment}}DB_USERNAME={SAFE{sqlserverUserName}}
{SAFE{sqlserverComment}}DB_PASSWORD={SAFE{sqlserverPassword}}
{SAFE{sqlserverComment}}DB_CONNECT_EXPIRY=60
{SAFE{sqlserverComment}}DB_SQLSTMTS_PATH={SAFE{serverDir}}/database
 
{SAFE{oracleComment}}DB_TYPE=oracle
{SAFE{oracleComment}}DB_DRIVER=oracle.jdbc.driver.OracleDriver
{SAFE{oracleComment}}DB_JDBC_URL={SAFE{oracleConnectionString}}
{SAFE{oracleComment}}DB_USERNAME="{SAFE{oracleUserName}}"
{SAFE{oracleComment}}DB_PASSWORD={SAFE{oraclePassword}}
{SAFE{oracleComment}}DB_CONNECT_EXPIRY=60
{SAFE{oracleComment}}DB_SQLSTMTS_PATH={SAFE{serverDir}}/database
 
# ************** FME SERVER SETTINGS END **************