5.6

URLs for FSDB JDBC Driver Connections
Whether it uses RMI or HTTP, the FSDB JDBC driver needs to know the location of the
vCenter Operations Manager DBMS. The URL that is used during driver instantiation must include this
connection information.
To connect with either RMI or HTTP, you must also provide a vCenter Operations Manager administrator user
name and password to the FSDB JDBC driver.
Table 12-1. URLs for RMI and HTTP Connections
Connection Type URL
RMI The URL should include the RMI port for the analytics process. The default port is 1199. For
example:
rmi://localhost:1199/DBMS
HTTP The URL should include the Tomcat host and port that the vCenter Operations Manager Web
application uses. For example:
http://localhost:80/FsdbJdbcOverHttpServlet
FSDB Database Scheme
To use the FSDB JDBC driver, you need to know the layout that the vCenter Operations Manager FSDB uses.
The FSDB model has one catalog, named FSDB_CAT, and one scheme, named FSDB_SCHEME. The
FSDB_CAT catalog contains the FSDB table.
All of the fields of type String are represented as floating point numbers.
Table 12-2. FSDB Table Columns
Column Type Description
resource_ID Integer ID of the resource.
attrkey_ID Integer ID of the attribute key.
timestamp String Time when vCenter Operations Manager received the value.
value String Metric value that vCenter Operations Manager received.
min_threshold String Minimum value for the dynamic threshold.
max_threshold String Maximum value for the dynamic threshold.
historical_min_threshold String Historical minimum value for the dynamic threshold.
historical_max_threshold String Historical maximum value for the dynamic threshold.
FSDB JDBC Driver SQL Formal Description
To use the FSDB JDBC driver, you need to know its SQL formal description.
The FSDB JDBC driver uses the following SQL formal description in Backus-Naur format.
SELECT "*" | <variables_list> FROM [FSDB_CAT.]?FSDB [WHERE <logical_expression>]?
variables_list ::= [FSDB.]?<field_name>[, [FSDB.]?<field_name>]*
field_name ::= column names from the FSDB table
logical_expression ::= [(]* [ [FSDB.]?<field_name> | <constant> ] [">"] | ["<"] | [">="]
| ["<="] | ["="] | ["!="] [ [FSDB.]?<field_name> | <constant> ] [<logical_operation>
[(]* [ [FSDB.]?<field_name> | <constant> ] [">"] | ["<"] | [">="] | ["<="] | ["="] |
["!="] [ [FSDB.]?<field_name> | <constant> ]]*
constant ::= [0-9]*[.[0-9]4]?
logical_operation ::= and | or.
VMware vCenter Operations Manager Administration Guide
154 VMware, Inc.