Database Connections


Execute Query allows for the existence of multiple database connections at any one time. Connection information may be retrieved via the database browser pane or through direct use of the Query Editor tool. Connection entry and configuration is described below.

Creating a New Connection

  1. Ensure the Connections tab is selected (if the tab is not visible select the View > Connections menu item).
  2. Select the New Connection button either from the Connections list display in the central pane or the New Connection button from the Connection tab's toolbar.
  3. Complete the relevant fields as shown below:

    Status This will indicate whether the selected connection has been established - Connected or Not Connected
    Connection Name The connection's name for identification
    User Name The user login name for this connection
    Password The user login password for this connection
    Store Password Indicate whether the password value is to be stored with the other connection information
    Encrypt Password Indicate whether the password when stored should be encrypted to avoid plain-text viewing of stored passwords
    Host Name Enter the database server's host name or IP address
    Port The database connection port number
    Data Source The data source name to connect to (the database instance name)
    JDBC URL The JDBC URL to use for this connection. This will override all non-authentication values entered above and will also override the URL value previously entered for the JDBC driver URL pattern. A complete URL with relevant values is required if this option is used
    JDBC Driver Select the JDBC driver to use for this connection (see Installing a New Driver)

  4. Select the Connect button for the application to attempt to establish a connection using the entered values

Advanced Connection Properties

Advanced connection properties may be entered by selecting the Advanced tab for the selected connection. Refer to the specific database and driver documentation to determine what (if any) additional database connection properties may be set.
Note: Refer to the specific database and driver documentation to determine what (if any) additional database connection properties may be set.
  • Enter key name/value pairs within the advanced JDBC properties table.
  • All entered properties will be applied to all generated connections for the current selection.

Transaction Isolation

Select the appropriate database transaction isolation level for your connection. Depending on what is being achieved, it is usually sufficient to leave this as the driver's own default transaction isolation level.

Closing a Connection

A connection may disconnected at any time by selecting the Disconnect button from the connection's entry form. Alternatively, a connection may also be closed using the popup menu item Disconnect Data Source <name> from within any of the connection's tree nodes in the Connection tree browser docked pane.