JDBC URL examples

To create a new data source, the user are to enter the JDBC URL parameter. This page provides standard JDBC URL formats and connection examples for supported database systems.

PostgreSQL

For a PostgreSQL, the basic format of the connect string is:

jdbc:postgresql://<host>:<port>/<database>

Example of JDBC URL:

jdbc:postgresql://localhost:5432/postgres

More information about connecting to the PostgreSQL database can be found in the documentation.

SQL Server

The general form of the connection URL for SQL Server is:

jdbc:sqlserver://<host>:<port>[;<property>=<value>]

Example of JDBC URL which is used to connect to master database without encryption:

jdbc:sqlserver://localhost:1433;encrypt=false;databaseName=master

More information about connecting to the SQL Server database can be found in the documentation.

MySQL

The general form of the connection URL is:

jdbc:mysql://<host>:<port>[/<database>][?properties]

Example:

jdbc:mysql://localhost:3306/sakila

More information about connecting to the MySQL database can be found in the documentation.

Oracle

When connecting to an Oracle database using JDBC, the URL format depends on the type of connection method. Some of the connection methods are described below.

Service Name Connection

The format of the JDBC URL to connect Oracle databases via service name:

jdbc:oracle:thin:@//<host>:<port>/<serviceName>

Example:

jdbc:oracle:thin:@//localhost:1521/DB

TNS URL Format

tnsnames.ora entries can be included in the JDBC URL to connect to Oracle databases:

jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<host>)(PORT=<port>))(CONNECT_DATA=(SERVICE_NAME=<service>)))

Example:

jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=DB)))

More information about connecting to the Oracle database can be found in the documentation.

Db2

Basic URL template for Db2 (type 4 connectivity) is:

jdbc:db2://<host>:<port>/<database>

Example:

jdbc:db2://localhost:50000/testdb

More information about connecting to the Db2 database can be found in the documentation.

MariaDB

Basic URL template for MariaDB is:

jdbc:mariadb://<host>:<port>/<database>[?key1=value1&key2=value2...]

Example:

jdbc:mariadb://localhost:3306/mydatabase

More information about connecting to the MariaDB database can be found in the documentation.

SQLite

The general form of the connection URL for SQLite is:

jdbc:sqlite:<path_to_sqlite_file>

Example of JDBC URL with the absolute path to the SQLite database file (test.db):

jdbc:sqlite:/var/data/test.db

More information about connecting to the SQLite database can be found in the documentation.