tweakstreet-logo
  • Enter search terms

Oracle

Oracle database connection

Jdbc Drivers

Make sure tweakstreet can find your jdbc driver by placing the jar files in the appropriate driver location.

Settings

Name Type Description
Jdbc Url
 string

The oracle jdbc url has the following format:

jdbc:oracle:thin:@hostname:port:databaseName
Properties
 dict

Properties passed to the driver when creating a connection.

Supported properties are driver-specific, but usually user and password should be passed for authentication.

Property values can be optionally encrypted using the password widget.

See: https://docs.oracle.com/en/database/oracle/oracle-database/18/jajdb/oracle/jdbc/OracleDriver.html
Default Timezone
 string

JDBC default timezone for the connection.

When nil, the local time zone of the JVM is used.
Run SQL after connect
 string

SQL to execute immediately after connecting.

Multiple statements must be separated by blank lines.

Test Connection

You can test the connection from the context menu.

On this page