Generating a List of Statements in the Statement Pool
The following code shows how to return an ExtStatementPoolMonitor object using a connection and generate a list of statements in the statement pool associated with the connection.
Note: The following example is drawn from a Microsoft SQL Server use case but applies to most Progress DataDirect drivers.
In the previous code example, the PoolEntries() method returns all statements in the statement pool regardless of statement type, result set cursor type, and concurrency type by specifying the value -1 for each parameter as shown in the following code:
We could have easily filtered the list of statements to return only prepared statements that have a forward-only result set with a concurrency type of updateable using the following code: