Kbase 21878: SQL Engine Statement Mgr Statement Cache Overflowed. (9799)
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
08/03/2002 |
|
SUMMARY:
In situations where SQL-92 statements are dynamically prepared or large numbers of SQL Statements are generated by one connection session, it is possible to get the error:
[JDBC Progress Driver]:SQL engine Statement Mgr statement cache
overflowed. 100 statements currently in use (uid cache). (9799)
EXPLANATION:
Regardless of whether the statements are executed or not, just the SQL Prepare statement will reserve a slot within the SQL Engine.
When it exceeds the default of 100 it will generate the error.
SOLUTION:
The environment variable, CACHED_STATEMENTS, can be set on the machine running the SQL Server to increase the limit of prepared statements. For example:
CACHED_STATEMENTS=500
would allow up to 500 SQL Prepare statements during the session.