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. 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.
Default Value
(none)
Examples
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 |
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.
See: Using tnsnames.ora with Oracle database collections