Kbase 19879: How to solvs Apptivity Cursor Limit Access to Progress SQL-92
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
GOAL:
How to resolve the 50 open cursor limit when accessing the Progress SQL-92 engine from Progress Apptivity HTML projects using iPack.
CAUSE:
The SQL-92 engine in Progress Version 9.x limits the number of open cursors to 50 in given connection (refer to Progress Technical Support Solution 19878).
When accessing the SQL-92 engine from the Apptivity application either using the ODBC-JDBC bridge or the native JDBC, you might receive the error message:
error 20217.
Connection Exception. Network error on server.
This is caused because the application is dynamically opening more than 50 cursors at the same time.
FIX:
This solution explains how to resolve the 50 open cursor limit when accessing the Progress SQL-92 engine from Progress Apptivity HTML projects where the iPack tool has been used.
One solution to this problem is to limit the number of application-opened cursors to less than 50. To accomplish this, you must edit the projects properties file as follows:
ipack.statements.max=45
ipack.statements.blocksize=5
These new settings will limit the number of open cursors to 45 and, at the moment the limit is reached, 5 open cursors will be closed and reused for new connections.
NOTE: Progress Software does not support iPack.
The Progress SQL-92 Guide and Reference manual will provide you with a description of what a cursor is and how to open and close them.
Reference to Written Documentation:
Progress Technical Support Solution 19878.
Release note RN# 091B-XXXXX.
iPack documentation at: http://www.javaklaas.com/ipack
Progress Embedded SQL-92 Guide and Reference manual.