URL
database parameter
Description
The location of the database to which you want to connect using
the JDBC interface.
When to specify URL
You must specify the URL parameter before connecting to the
database.
Applies to
JDB JDBC
Syntax
|
1 |
URL='URL_address' |
Default value
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:
|
1 |
jdbc:vendor:driverprotocol:servername:port/database |
|
Argument |
Description |
|---|---|
|
jdbc |
Driver |
|
vendor |
Database vendor (such as SAP or |
|
driverprotocol |
Database communications protocol |
|
servername |
DNS machine name or database host |
|
port |
TCP/IP port number configured for accessing the |
|
database |
(optional) Name of a specific |
The database URL can also include the user ID and password as
follows:
|
1 |
jdbc:vendor:driverprotocol:userid/password@servername:port:database |
Examples
Example 1
To set the URL to a database accessed through jConnect:
-
Database profile
Type the following in the URL box on the Connection page in
the Database Profile Setup dialog box:1jdbc:sybase:Tds:199.93.178.151:5007/tsdata -
Application
Type the following in code:
1SQLCA.DBParm="URL='jdbc:sybase:Tds:199.93.178.151:5007/tsdata'"
Example 2
To set the URL to a database accessed through the Oracle JDBC
driver:
-
Database profile
Type the following in the URL box on the Connection page in
the Database Profile Setup dialog box:1jdbc:oracle:thin:@ora80nt:1521:orcl -
Application
Type the following in code:
1SQLCA.DBParm="URL='jdbc:oracle:thin:@ora80nt:1521:orcl'"
Example 3
To set the URL, which includes the user ID and password, to a
database accessed through the Oracle JDBC driver:
-
Database profile
Type the following in the URL box on the Connection page in
the Database Profile Setup dialog box:1jdbc:oracle:thin:system/manager@ora80nt:1521:orcl -
Application
Type the following in code:
1SQLCA.DBParm="URL='jdbc:oracle:thin:system/manager@ora80nt:1521:orcl'"
See also