Skip to end of metadata
Go to start of metadata

The information about the database server that needs to be entered depends on the which JDBC driver you use. For most drivers, you need to specify:

FieldDescription
Database ServerThe IP address or DNS name for the server where the database runs.
Database PortThe TCP/IP port used by the database.

Database Userid

The database user account name. Enter (null) to not send an account name.
Database PasswordThe database user account password. Enter (null) to not send a password.

For some database such as Oracle, you may use a TNS name instead of specifying the server and port. Other drivers may add more fields that are driver specific.

You may also optionally specify SSH tunneling information and Options, such as:

OptionDescription
Auto CommitCheck if you want to enable auto commit in the SQL Commander by default for the connection.
Save Database PasswordCheck if you want the password to be saved (encrypted) during the session, between sessions, or cleared when you disconnect.
Permission ModeOne of Development, Test or or Production to select which set of Permissions to use.

See the Configuring Connection Properties page for related topics.

  • No labels