Administration Guide › Accessing Collected Events with ODBC and JDBC › How Queries are Processed

How Queries are Processed

CA User Activity Reporting Module processes an ODBC or JDBC client-initiated query in the following way:

1. A client application sends a SELECT statement through an ODBC connection to the CA User Activity Reporting Module server.
2. The CA User Activity Reporting Module server validates the SELECT statement. If the validation is successful, the CA User Activity Reporting Module server creates a data structure representing the query.

   Any errors encountered are returned directly to the client driver.

3. The CA User Activity Reporting Module server converts the SQL elements into a query that it can use. If the conversion is successful, the CA User Activity Reporting Module server runs the query.

   Any errors encountered are returned to the client driver.

4. The CA User Activity Reporting Module server manages state information, including an expiration timer, for each query so that it can be canceled in the event the session is closed or the query expires.
5. The CA User Activity Reporting Module server translates the query results and sends them back to the ODBC client driver, and the client application then receives the data.