Page History
The following screen illustrates a typical Oracle JDBC connection:
REPLACE WITH THIS IMAGE: Images/connections/oracle_Jdbc_Connection1.png
Fields | Description | |||||
---|---|---|---|---|---|---|
Connection name | Enter a name for the connection. | |||||
Connection type | Select JDBC from the drop-down list. | |||||
Database type | Select ORACLE from the drop-down list. | |||||
Host | Enter the host name or IP address. | |||||
Port | The default Oracle port is 1521; however, this is unlikely to be the port number as it is routinely changed by Database Administrators. To determine the port, check the Oracle listener configuration.
|
...
Database | Type the Oracle database name. |
Connect using | Sets whether the value in the database represents an Oracle Instance name / SID or Service name / TNSNAME and is used for correctly formatting the connection URL. |
Max simultaneous | Set the maximum number of simultaneous connections 3D will open to the system. |
Manual tree expand | Select the checkbox to manually expand and load the database and host connections tree, instead of automatically drilling down the tree. |
JAR libraries | Select the Oracle jar file from the JDBC-DRIVERS directory. |
User | Enter the username for connecting to the specific database. |
Password | Enter the password for connecting to the specific database. |
Store password in | Select one of the following options if you choose to save or not to save your password:
|
Test connection | Click the button to ensure the entered parameters are correct. |