Page History
...
- Transaction Isolation Level: Support for setting Transaction Isolation Level.
- TRANSACTION_NONE - A constant indicating that transactions are not supported.
- TRANSACTION_READ_COMMITTED - A constant indicating that dirty reads are prevented; non-repeatable reads and phantom reads can occur.
- TRANSACTION_READ_UNCOMMITTED - A constant indicating that dirty reads, non-repeatable reads, and phantom reads can occur.
- TRANSACTION_REPEATABLE_READ - A constant indicating that dirty reads and non-repeatable reads are prevented; phantom reads can occur.
- TRANSACTION_SERIALIZABLE - A constant indicating that dirty reads, non-repeatable reads, and phantom reads are prevented. - JDBC Escape Processing: Allows JDBC driver to perform escape sequence before sending the SQL code to the server.
- Always Display Column Name in Results: Enables/Disables displaying column names in results.
- Enable DB Filters for Query Window: Enables/Disables db filters for query windows using this connection.
- Only Display Databases that User has Access to: Displays only the databases the current user (from the Login Name on the General tab) has access to within the schema browser.
- Fetch Size: Determines the Fetch Size (number of rows physically retrieved from the database at one time by the JDBC driver).
- Connections Pooled: Enables connection pooling. Read more about connection pooling here.
- Force Auto-Commit: When this option is selected, it sets auto-commit to TRUE for any Query Window to this server and disables the icons on the toolbar, regardless of the option in File > Options > Query Analyzer > [DATABASE] > [Auto Commit].
- Data Warehouse Mode: Read Only or Read/Write.
- Object Folder Display: [Default], [Name], [Schema].[Name] or [Name]([Schema]) sets how the Schemas will be displayed.
- Object Folder Schema Folder Grouping: Default, Yes or No. Schema Folder Grouping makes finding tables much easier because it groups them instead of showing each object individually.
...
For more information, see Connection Monitor.