db.jdbc_url

Background

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

MySQL

  • Driver: com.mysql.jdbc.Driver

  • Template url: jdbc:mysql://:/

  • Standard port: `3306

Oracle

  • Driver: oracle.jdbc.OracleDriver

  • Template url: jdbc:oracle:thin:@::

  • Standard port: 1521

PostgreSQL

  • Driver: org.postgresql.Driver

  • Template url: jdbc:postgresql://:/

  • Standard port: 5432

SQL Server

  • Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver

  • Template url: jdbc:sqlserver://:;DatabaseName=

  • Standard port: 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.

Setting the key

Set this configuration key in the search package or data source configuration.

Use the configuration key editor to add or edit the db.jdbc_url key, and set the value. This can be set to any valid String value.

Default value

(none)

Examples

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