Connections View
Existing Database Connections
Connections View
- displays all defined connections.
- allows you to establish your connection to the database.
- shows all tabs (representing objects or editors) associated with the connection.
Default display of existing database connections:
Option Group Connections by Database enabled:
New Database Connection
In the New Connection dialog you can comfortably make connections to Oracle 9 and higher versions of Oracle.
Direct TCP/IP Connection
You can preload identification from available local net service names or specify connection settings manually.
Oracle Client connection
In case you have an Oracle Client on your machine installed you can connect to your database also via OCI.
Toad Extension for Eclipse automatically loads existing tnsnames.ora file. If the file is not successfully located by Toad Extension for Eclipse, specify path to the file in field TNS File.
Note: tnsnames.ora file can be used only with Oracle 10 or Oracle 11 Client. Oracle 9 Client is not supported.
Custom Connection String
You can also make use of Custom Connection String as URL in JDBC syntax is supported.
Other information
- Proxy users are supported as well. The user name must fit in the form "proxy_user [proxied_user]" as stated in SQL-Plus.
- Passwords can be stored encrypted for any connection. Select the Connect on startup checkbox to establish the connection immediately at the start of Eclipse.
- In order to simplify tasks required for establishing a connection to your Oracle database Toad Extension for Eclipse searches for installed Oracle Clients and tries to locate the most appropriate ojdbc driver on your machine. Information and settings are loaded from registry and also from ORACLE_HOME and Path Environment Variables.
- Drivers ojdbc14.jar, ojdbc5.jar and ojdbc6.jar can be used. Default driver can be defined or changed in Preferences.
- Connection via OCI was tested on Windows and Linux OS. In Linux, environment variables ORACLE_HOME and LD_LIBRARY_PATH have to be set.
Schema Filter
In the context menu of the connection, you can define a filter for the displayed schemas. The settings are stored and later can be reused.