Connection pool statistics
- Last Updated: October 7, 2020
- 1 minute read
- DataDirect Connectors
- ODBC
- Aha! 8.0
- Amazon Redshift 8.0
- Apache Cassandra 8.0
- Apache Hive 8.0
- Apache Spark SQL 8.0
- Autonomous Rest Connector 8.0
- Cloudera Impala 7.1
- dBase 7.1
- + 24
Progress DataDirect has created a connection attribute to monitor the status of the DataDirect for ODBC connection pools. This attribute, which is described in the following table, allows your application to fetch statistics for the pool to which a connection belongs.
| Connection Attribute | Description |
|---|---|
| SQL_ATTR_POOL_INFO Value: SQL_GET_POOL_INFO | Calling SQLGetConnectAttr (SQL_ATTR_POOL_INF,
SQL_GET_POOL_INFO) returns a PoolInfoStruct that contains the statistics for the
connection pool to which this connection belongs. This PoolInfoStruct is defined in
qesqlext.h. For example:SQLGetConnectAttr(hdbc, SQL_ATTR_POOL_INFO, PoolInfoStruct *,
SQL_LEN_BINARY_ATTR(PoolInfoStruct), &len);This is a read-only
connection attribute. The driver returns an error if SQLSetConnectAttr
(SQL_ATTR_POOL_INFO) is called. |