Creating a JDBC Database Connection

To create a JDBC database connection (the tabs and fields are described below):

Navigate to Configure > Admin > Manage Connectors > Databases.
Click New.
Enter a Name.
Select an option from the Jdbc Driver Class Name dropdown list.
Select Jdbc Url > Advanced and enter jdbc:oracle:thin:@ora12.example.com:1521/orcl into the field.
Select a Credential from the Connection User dropdown list.
Click Save & Close.

About Connection Pool Settings

You can enable a connection pool to increase the performance of JDBC, OracleJob Jobs, and REL expressions that make calls to remote databases. If connection pooling is enabled and a JDBC or OracleJob Process starts running, instead of creating a connection to the remote database, the Job Server uses a connection from a connection pool. Once the Process has reached a final status, the connection is returned to the pool for another Process to use. Be careful about connection pooling, because you cannot make assertions about variables holding initial values, and you can't guarantee that Locks are automatically released when processing finishes.

Tabs and Fields

Tab	Field	Description
Database	Connection > Library	If you don't want to include the driver in the `CLASSPATH`, you can specify the library with the JDBC driver here.
Database	Connection > Jdbc Driver Class Name	The class name of the JDBC driver. See the documentation for your JDBC driver for more information.
Database	Connection > Jdbc Url	Two options are available to specify the JDBC connect string. Using host, port (optional) and database specifier. This method is supported only for specific databases. Using the JDBC URL.
Database	Connection > Auto Commit Style	The type of commit policy you require: Transaction Based (default): A commit is performed at the end of every Job run. This allows you to roll back all SQL queries on failure. Auto Commit On: A commit is performed after each query. Auto Commit Off: No commit is performed. You are expected to execute commits where you see fit.
Database	Connection User	The username associated with the JDBC Credential you want to use for the database connection.
Connection Pool Settings	Max Number Of Connections	The maximum number of physical connections the Job Server can establish to the remote database.
Connection Pool Settings	Pooling State	Controls the connection pool. The options are: Disabled. Enabled. DisabledForProcesses. With this setting, connection pooling is disabled for JDBC and OracleJob processes only, but enabled for REL expressions.
Connection Pool Settings	Driver Properties	The list of Java properties for the JDBC driver.
Connection Pool Settings	Max Connect Time (ms)	The maximum amount of time to keep a connection in the pool.
Connection Pool Settings	Max Idle Time (ms)	The maximum amount of time a connection may remain idle before it is closed.
Connection Pool Settings	Max Abandoned Time (ms)	The maximum amount of time the Job Server will wait before closing the connection.
Connection Pool Settings	Frequent Users	List of users requiring specific maximum connections and/or idle times.
Connection Pool Settings	Max Connections Per Frequent User	Maximum number of physical connections the Job Server can establish to the remote database for users on the Frequent Users list.
Connection Pool Settings	Min Idle Connections Per Frequent User	Minimum number of idle connections the Job Server should keep open for users on the Frequent Users list.
Connection Pool Settings	Max Connections Per Non-Frequent User	Maximum number of physical connections the Job Server can establish to the remote database per user (for users not on the Frequent Users list).
Connection Pool Settings	Initialization Query	A query that will be called each time a connection is opened.
Connection Pool Settings	Validation Query	A query that is performed after a successful login and after any severe SQL exception.
Connection Pool Settings	Severe SQL Exceptions	A comma-separated list of exceptions that the Job Server should consider fatal, causing the Job Server to issue the `ValidationQuery`.
Connection Pool Settings	Non Transient Connect SQL Exceptions	A comma-separated list of exceptions that should be considered non-transient (exceptions that should prevent the Job Server from retrying).
Connection Pool Settings	Invalid User Name Or Password SQL Exceptions	A comma-separated list of exceptions that should be mapped to "invalid username or password."