Page History
...
(DESCRIPTION=(FAILOVER=ON)(ADDRESS_LIST=(LOAD_BALANCE=ON)(ADDRESS=(PROTOCOL=TCP)(HOST=xxxxx) (PORT=1526))(ADDRESS=(PROTOCOL=TCP)(HOST=xxxx)(PORT=1526))) (CONNECT_DATA=(SERVICE_NAME=somesid)))
Connection Type - LDAP
Anchor | ||||
---|---|---|---|---|
|
Edit the Server Properties, to use FILTER options for a Server in Aqua Data Studio:
...
Info |
---|
Enabling both options significantly improves the Schema Tree and Query Analyzer connection performance. |
Anchor | ||||
---|---|---|---|---|
|
Edit the Server Properties to use Advanced Properties in Aqua Data Studio:
...
Using the drop-down at the bottom of the Advanced Tab, quickly change your Object Display in the Server Browser.
Anchor | ||||
---|---|---|---|---|
|
Edit the Drivers Properties to use Driver Parameters in Aqua Data Studio:
...
- Driver: This displays the JDBC driver used for this connection.
- Driver Parameters: This option is to allow a user to specify extra JDBC parameters that a user might want use in establishing a connection.
- Connection URL: This displays the connection URL for this server connection.
- Driver Parameters Quickfilter: This option is to allow a user to search JDBC parameters that a user might want to use in establishing a connection.
Anchor | ||||
---|---|---|---|---|
|
Edit the Permissions in Server Properties in Aqua Data Studio:
...
- Control Statement execution and Properties of the Query Analyzer, Table Data Editor, and Visual Editing.
- Grant / Revoke Permissions easily for executing DDL and DML Statements in the Query Analyzer.
- Change the behavior of the Table Data Editor for manipulating rows in Tables.
- Grant / Revoke Alters, Creates, Drops and View Properties of Visual Editing Tools.
- Allow SQL debugging for this server connection.
Anchor | ||||
---|---|---|---|---|
|
Edit Scripts in Server Properties in Aqua Data Studio:
...
- Enter an SQL Script that is executed each time a new connection is established.
- This allows the user to SET connection settings for a server connection. (eg: SET ROLE, ALTER SESSION SET XXX)
Anchor | ||||
---|---|---|---|---|
|
Edit Shell Scripts in Server Properties in Aqua Data Studio:
...
- Enter a FluidShell Script that is executed each time a new FluidShell connection is established.
- This allows the user to cd (change directory) for a server connection. (eg: cd /scripts)
Anchor | ||||
---|---|---|---|---|
|
Enable the connection monitor to start an application thread that monitors the status of the connection associated with the Query Window.
With the connection monitor, you can:
...
For more information, see Connection Monitor.