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

How Queries are Processed

CA Enterprise Log Manager 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 Enterprise Log Manager server.
2. The CA Enterprise Log Manager server validates the SELECT statement. If the validation is successful, the CA Enterprise Log Manager server creates a data structure representing the query.

   Any errors encountered are returned directly to the client driver.

3. The CA Enterprise Log Manager server converts the SQL elements into a query that it can use. If the conversion is successful, the CA Enterprise Log Manager server runs the query.

   Any errors encountered are returned to the client driver.

4. The CA Enterprise Log Manager 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 Enterprise Log Manager server translates the query results and sends them back to the ODBC client driver, and the client application then receives the data.