Skip to content

Connection types

Connection types control how Team Edition behaves when working with a database. They help define environment-specific behavior, such as:

  • transaction commit mode
  • SQL execution confirmation
  • automatic cleanup of idle transactions and connections
  • background color for easy environment recognition

You can assign a connection type when creating or editing a connection. You can also define your own types with custom settings and colors. Connection type colors appear in the Database Navigator, all related editors and tabs:

Manage connection types

New connections use the Development type by default. You can switch to another default type, or create your own with custom settings.

Info

Learn more about default connection types.

Change connection type

  1. In the Database Navigator or Projects view, select a connection
  2. Open the connection properties by pressing F4 or by right-clicking the connection and selecting Edit connection from the context menu
  3. In the left pane, choose General

  4. You'll find the Connection type field among the settings:

  5. To confirm the change, click OK.

Create connection type

  1. Navigate to Window -> Preferences -> Connections -> Connections types

  2. Click the New button () to add a connection type

  3. Configure the settings for the new type:

    Setting Description
    Identifier Unique ID for the type (used internally)
    Name Display name shown in the UI
    Description Short explanation of what this connection type is for
    Color Visual indicator used to highlight connections of this type
    Confirm SQL execution Show a confirmation dialog before running INSERT, UPDATE, or DELETE queries
    Confirm data changes Ask for confirmation before saving changes to the database
    Auto-commit by default Enable autocommit mode as the default behavior. Learn more
    Smart commit mode Start transactions automatically for data-changing statements. Learn more
    Return to auto-commit Re-enable autocommit after commit or rollback (only with smart commit)
    End idle transactions (sec) Roll back and close transactions after being idle for the specified time
    Close idle connection (sec) Disconnect after inactivity. Set to 0 to disable automatic disconnection

    Tip

    For embedded databases, Close idle connection is always ignored - they stay connected indefinitely.

  4. Click Apply to save your changes, or Apply and Close to save and exit. Use Restore Defaults to undo all edits.

Edit connection type

  1. Open the connection properties (F4 or right-click the connection and select Edit connection)
  2. On the General page, click Edit next to the Connection type field
  3. Select a connection type and update its settings as described in Create connection type
  4. Click Apply or Apply and Close to save changes. Use Restore Defaults to reset the type.

Note

The default connection types can't be edited.

Delete connection type

  1. Open the connection properties (F4 or right-click the connection and select Edit connection)
  2. On the General page, click Edit next to the Connection type field
  3. Select the connection type you want to remove, then click the Delete button ()
  4. In the confirmation dialog, click Yes to delete or No to cancel
  5. Click Apply or Apply and Close to save your changes.

Default connection types

Team Edition includes three built-in connection types:

  • Development – for local use
  • Test – for staging environments
  • Production – for live databases

You can change the type assigned to a connection or create new types, and edit or delete existing ones.

Tip

Use connection types to clearly separate environments and avoid mistakes in production.

Comparison of default types
Setting Development Test Production
Autocommit On On Off
Confirm SQL execution Off Off On
Confirm data change Off On On
Smart commit mode Off Off Off
Return to auto-commit On On Off
Auto-close transactions On On On
Idle transaction timeout 1800 seconds (30 minutes) 900 seconds (15 minutes) 600 seconds (10 minutes)
Auto-close connections On On On
Idle connection timeout 14400 seconds (4 hours) 7200 seconds (2 hours) 3600 seconds (1 hour)
Background color White Olive green Brick red

Info

If Confirm SQL execution is enabled for a connection type, Team Edition will ask for confirmation before running transactional queries like INSERT, UPDATE, or DELETE.