Db Jdbc Url (collection.cfg)

Description

This parameter specifies the JDBC URL to use when connecting to the underlying database. The format of the URL is generally defined by the chosen JDBC Driver class in use. The URL will frequently contain a hostname / IP address for the server, a TCP port and a database name. See your JDBC driver's documentation for full details, including information about configuring your database system to allow remote access if necessary.

Example JDBC URLs

Database TypeDriverTemplate URLStandard Port
MySQLcom.mysql.jdbc.Driverjdbc:mysql://:/3306
Oracleoracle.jdbc.OracleDriverjdbc:oracle:thin:@::1521
PostgreSQLorg.postgresql.Driverjdbc:postgresql://:/5432
SQL Servercom.microsoft.sqlserver.jdbc.SQLServerDriverjdbc:sqlserver://:;DatabaseName=1433

Default value

(none)

Example

db.jdbc_url=jdbc:sqlserver://192.168.146.132:1433;DatabaseName=AdventureWorks

top