URL

Description

The location of the database to which you want to connect using the JDBC interface.

Applies to

• JDB JDBC

Syntax

URL='URL_address'

Default

None

Usage

The database URL is obtained from the database JDBC driver documentation. A list of registered Driver classes, with their URLs, is maintained by the driver’s JDBC DriverManager class. When a connection request is made, the DriverManager attempts to locate a suitable driver from those listed.

The URL uses this general format:

jdbc:vendor:driverprotocol:servername:port/database

The database URL can also include the user ID and password as follows:

jdbc:vendor:driverprotocol:userid/password@servername:port:database

Examples

To set the URL to a database accessed through jConnect:

To set the URL to a database accessed through the Oracle JDBC driver:

To set the URL, which includes the user ID and password, to a database accessed through the Oracle JDBC driver:

See also