There are a number of connection properties that need to be specified when you access data using the JDBC Driver. When you access data using the UNICOM Intelligence products, this is generally invisible, because the products automatically set up all of the connection properties for you. However, when you use the JDBC Driver to access data, the connection properties need to be defined.

For more information about connection properties, see “Connection properties” and “Connecting to the UNICOM Intelligence Data Model”.

(Optional.) The length of time, in seconds, to wait for the initialization to complete.

Data type: A 32-bit, signed integer.

(Optional.) The CDSC name to be used with the connection. This is the component name of the CDSC ProgID (for example, mrRdbDsc). The JDBC driver can automatically selects the CDSC.

Data type: String

(Required.) The name or location of the metadata source. For file or directory-based data stores, this is the path to the file or directory. The provider will treat a relative path as being relative to the metadata file specified in the Initial Catalog property. If Initial Catalog is not set, the provider will treat a relative path as being relative to the current directory. The provider resolves a relative path to an absolute path before passing it to the CDSC. For OLE DB-based data stores, this is the OLE DB connection string. For more information, see “Connecting to a Relational MR Database” in the UNICOM Intelligence Developer Documentation Library.

Data type: String

(Optional.) The name or location of the data source. For file or directory-based data stores, this is the path to the file or directory.

Data type: String

(Optional.) This is used internally to filter the CDSCs in the Data Link Properties dialog box (for example, so that only read-enabled CDSCs are listed when the Mode setting is “read”). Other uses of this property are reserved for future use.

Data type: String

(Required.) The password to connect to the data source. This property should not be a blank string.

Data type: String

(Required.) The user ID to connect to the data source. The user ID should have the appropriate authority to logon to the workstation where the service driver is installed.

Data type: String

By default, custom connection properties that are prefixed by MR or MR Init are not supported in the connection string. If you want to specify these custom connection properties, you must declare them in the JDBC Service Driver’s configuration: