Database Connection
Connections store authentication information. For general information about sharing database connections, please see Using Database Connections.
Note that different subsets of the Database Connection parameters below are made available in different contexts.
Connection
This parameter specifies a database connection for the reader through a drop-down menu. The Add Database Connection option in the menu allows you to create a new connection. The connection requires a name that describes the connection.
Note: The following characters are not allowed in connection names: ^ \ / : * ? " < > | & = ' + % #
The new connection can be made visible only to the current user, or can be shared among multiple users.
Connection Parameters
JDBC Connection String
The connection string for the database to which you are connecting. The precise format depends on the JDBC driver being used, but a connection string will always start with:
jdbc:<subprotocol>:
See the FME Knowledge Center for information about the compatibility of various JDBC drivers with FME, and to view Workbench examples.
Username and Password
If not specified in the JDBC Connection String, enter the username and password to access the database.
Java Driver Class
This parameter is not required for well-behaved JDBC 4.0+ drivers.
For drivers that do not self-register, enter the name of the Java class for the driver desired.
Note: When errors are being returned by the wrong JDBC driver, specifying the Driver Class can force the connection string to be processed by only the desired driver.
Advanced Settings
Features Per Transaction
This parameter determines the number of features that FME will place in each transaction before a transaction is committed to the database.
The default value is 1000.
Query Timeout (Seconds)
This parameter defines the time, in seconds, after which a query will be terminated if it has not yet returned a result.
If set to zero, there is no timeout.