db.jdbc_url

The URL specifying database connection parameters such as the server and database name.

Key: db.jdbc_url
Type: String
Can be set in: 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.

Common JDBC URLs

Database Type Driver Template URL Standard Port

MySQL

com.mysql.jdbc.Driver

jdbc:mysql://:/

3306

Oracle

oracle.jdbc.OracleDriver

jdbc:oracle:thin:@::

1521

PostgreSQL

org.postgresql.Driver

jdbc:postgresql://:/

5432

SQL Server

com.microsoft.sqlserver.jdbc.SQLServerDriver

jdbc:sqlserver://:;DatabaseName=

1433

The JDBC 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. The template URL column of the table above provides sample URLs for the most common database systems.

Default Value

(none)

Examples

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

TNS names support for Oracle database

Oracle databases have support for distributed databases via the use of a TNS names file. Funnelback can be configured to support this by setting a number of advanced options.

© 2015- Squiz Pty Ltd