Kbase P81529: SQL-92 server crashes when deleting more than 50 records from a TYPE_FORWARD_ONLY result set (1)
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
30/09/2005 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1x
OpenEdge 10.0x
SYMPTOM(s):
SQL-92 server crashes when deleting more than 50 records from a TYPE_FORWARD_ONLY result set
[JDBC Progress Driver]:-20217
SYSTEM ERROR: lkrestore: invalid call (3735)
Using the default result set type which is TYPE_FORWARD_ONLY
Query for result set does not contain a WHERE clause
CAUSE:
Bug# 20040512-054
FIX:
Upgrade to 9.1E02 or later.
Upgrade to 10.0B02 or later.
- OR -
Set the result set type to TYPE_SCROLL_INSENSITIVE, e.g.:
//---
PreparedStatement pstmt1 = connection.prepareStatement( "SELECT * FROM pub.customer",
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
//---