A URL is used to locate a resource on the Internet. A URL always begins with a protocol followed by a colon, such as http: or ftp:, and the rest of the string is defined by the protocol. In keeping with the Internet orientation of Java and JDBC, URLs are used to identify databases. The JDBC specification defines conventions for the format of JDBC URLs. Each JDBC driver defines the actual format of the URLs that it recognizes. The general format of a JDBC URL is:
protocol: subprotocol: subname
protocol is always jdbc. subprotocol and subname are defined by the JDBC driver.
The CA IDMS Server JDBC driver recognizes three URLs with subprotocol idms. The location of the native SQL client interface and the data source or dictionary name are specified by the subname.
Specifies the format used when the JDBC driver runs on the same machine as the native SQL client interface, that is, as a Type 2 driver. The JDBC driver calls the native interface directly.
Specifies the format used when the JDBC driver runs on a different machine than the native SQL client interface, that is, as a Type 3 or Type 4 driver. The Type 3 JDBC driver communicates with the JDBC server, which calls the native interface directly. hostname is the DNS name or IP address of the web server machine on which the JDBC server is running, and port is the IP port that was specified as the JDBC server listener. CA IDMS r16 SP2 or later supports direct connections from the Type 4 JDBC driver to the CV. hostname is the DNS name or IP address of the machine where the CV is running, and port is the IP port that was specified for the listener PTERM.
Specifies the format used when the JDBC driver runs on a different machine than the native SQL client. In this case, the Secure Sockets Layer protocol is used for all communications between the driver and the CV (the driver acting as type 4), or between the driver and a JDBC Server (the driver acting as a type 3).
Important! The database can be an ODBC data source name or the dictionary name of the catalog containing the table definitions. When database is an ODBC data source name, the actual dictionary and physical connection information are resolved by the native SQL client interface, and must be defined on the system where the native code runs. When database is a dictionary name, the physical connection information is specified by DriverPropertyInfo objects.
When using JDBC driver types 3 and 4 with an IPv6 destination, it is still possible to code the hostname parameter in the URL with either a DNS name or an IP address. The DNS name is specified in the same way as it would be for an IPv4 destination. The IP address for an IPv6 destination must be enclosed in square brackets as shown in the following example.
jdbc:idms://[fec0::a:9:67:115:66]:3730/appldict
|
Copyright © 2009 CA.
All rights reserved.
|
|