JDBC DriverPropertyInfo objects are analogous to the connection attributes used by the ODBC SQLDriverConnect and SQLBrowseConnect functions. For the JDBC driver, they are used to specify user ID, password, and optional accounting information. They can also be used to specify physical connection information, allowing an application to connect to a CA IDMS database without requiring the definition of an ODBC style data source. CA IDMS Server supports the following driver properties:
Specifies accounting information. An optional feature that may be used by the CA IDMS system. A user exit must be installed on the DC system to process the information. See the chapter "Passing Accounting Information to CA IDMS" for more information.
Specifies the DNS name or IP address of the CAICCI host server, for use by the native SQL client interface. Ignored unless node is specified. Typically, the default is used.
Overrides the default IP port of the CAICCI host server. Ignored unless ccihost is specified. Typically, the default is used.
Specifies that when set to true, the JDBC driver suspends the SQL session and pseudo converse immediately after connecting to the database. The default for a non-pooled connection is false.
Specifies the name of the default SQL Schema. This is an optional 1-to-18 character field. When specified, this field is used as the schema qualifier for all SQL table references that do not contain an explicit schema qualifier. The default is blank (unspecified).
Sets the external wait interval for the task. This property effectively becomes the socket timeout and overrides the value specified for the task definition. It is used only by the Type 4 JDBC driver.
Specifies the DC NODE name, which identifies the CV containing the database. Using this property allows a connection to be established without defining an ODBC style data source. Use of this property implies that the subname contains a DICTNAME, and the driver does not search the registry or configuration file.
Specifies the password associated with the user ID. Required to connect to a secured CV.
Sets the program name for stand-alone applications when used with the DriverManager.getConnection(String url, Properties info).
Sets the resource interval for the task. This property overrides the value specified for the task definition. It is used only by the Type 4 JDBC driver.
Sets the default data buffer size for IDMSJSRV. This property overrides the value specified in the listener PTERM PARM string. It is used only by the Type 4 JDBC driver.
When set to true, specifies that the JDBC driver obtains a secure socket for all communication to an IDMS CV or a JDBC proxy server.
Sets the IDMSJSRV trace flags as defined in CSACFLG1 and CSACFLG2 as directed by CA IDMS Technical Support.
Overrides the default DC TASK code that invokes the internal CA IDMS Server interfaces.
Specifies that a user ID is required to sign onto CA IDMS.
Specifies the NODE name of an intermediate CV that is used to route requests to the target system. Used when a physical connection cannot be established directly to the CV containing the SQL database. Ignored unless node is specified.
|
Copyright © 2009 CA.
All rights reserved.
|
|