tweakstreet-logo
  • Enter search terms

Generic

Generic JDBC 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
Driver Class
 string

Jdbc driver class to use. Some class names for popular databases are:

Database Driver Class
MySql 5.x com.mysql.jdbc.Driver
MySql 8.x com.mysql.cj.jdbc.Driver
Postgres org.postgresql.Driver
Snowflake net.snowflake.client.jdbc.SnowflakeDriver
SqlServer com.microsoft.sqlserver.jdbc.SQLServerDriver
Oracle oracle.jdbc.driver.OracleDriver
DB2 com.ibm.db2.jcc.DB2Driver
Jdbc Url
 string

Jdbc url to use. Some url formats for popular databases are:

Database Jdbc Url
MySql jdbc:mysql://hostname:port/databaseName
Postgres jdbc:postgresql://hostname:port/databaseName
Snowflake jdbc:snowflake://[account_identifier].snowflakecomputing.com
SqlServer jdbc:sqlserver://serverName[\instanceName]:port
Oracle jdbc:oracle:thin:@hostname:port:databaseName
DB2 jdbc:db2://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.
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