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
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.