When using the JDBC client to access event data stored in CA User Activity Reporting Module, you need both the JDBC Classpath and a JDBC URL. The JDBC Classpath names the driver JAR file locations. The JDBC URL defines the parameters the classes in the JARs use when they load.
The following is a complete, sample JDBC URL:
jdbc:ca-elm://127.0.0.1:17002;encrypted=1;ServerDataSource=Default;CustomProperties=(querytimeout=600;queryfederated=true;queryfetchrows=1000;offsetmins=0;suppressNoncriticalErrors=false)
The following descriptions explain the URL components:
Defines the protocol:subprotocol string that designates the JDBC driver provided with CA User Activity Reporting Module.
Names the IP address that represents the CA User Activity Reporting Module server whose data you want to access. The port number is the port to use for the communications, and must match the setting in the CA User Activity Reporting Module ODBC Service configuration panel. If the ports do not match, the connection attempt fails.
Determines whether SSL encryption is used for the communications between the JDBC client and the CA User Activity Reporting Module server. The default value is 0, not encrypted, and does not require specification in the URL. Setting encrypted=1 turns encryption on. Set the connection to encryption explicitly. In addition, this setting must match what you configure in the CA User Activity Reporting Module ODBC Service dialog or the connection attempt fails.
Specifies the name of the data source. Set this value to Default for access to the CA User Activity Reporting Module event log store.
These properties are the same as the ODBC custom properties. If you do not specify them explicitly, the default values shown in the example URL apply.
Copyright © 2013 CA.
All rights reserved.
|
|