Reviewing the status of your endpoints
- Last Updated: February 7, 2024
- 1 minute read
- DataDirect Connectors
- JDBC
- Autonomous REST Connector 6.0
- Documentation
After testing your connection, you can review the status of your specified endpoints to verify
that they have been successfully sampled by the driver. Reviewing the status of your
endpoints allows you to immediately identify any data omitted from the model and the
potential causes. To review your endpoint status, query the
INFORMATION_SCHEMA.SYSTEM_SAMPLING_STATUS system table. For
example:
SELECT * FROM INFORMATION_SCHEMA.SYSTEM_SAMPLING_STATUSThe driver generates the
INFORMATION_SCHEMA.SYSTEM_SAMPLING_STATUS table
after connecting to and sampling the endpoints specified in your Model. The table
contains the following information: ENDPOINT_NAME: The name of the endpoint as defined in the Model file.MESSAGE: The HTTP response message.SAMPLE_URI: The endpoint that was used for the connection.SUCCESS: Indicates whether the endpoint was successfully sampled.HTTP_STATUS: The HTTP response status code.
SamplingFailureTolerance=-1 to receive the status for all your
endpoints. For example, if the number of endpoints in your model that are
unreachable exceeds the sampling failure tolerance set by SamplingFailureTolerance,
the driver will fail the connection and stop attempting to sample the remaining
endpoints specified in your Model file. In that scenario, you will need to
reconfigure SamplingFailureTolerance to audit your complete set of endpoints.