Kbase P109462: SQL-92 server crashes when deleting more than 50 records from a TYPE_FORWARD_ONLY result set (2)
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/30/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 contains a WHERE clause
CAUSE:
This is a known issue being investigated by Development
FIX:
Set the result set type to TYPE_SCROLL_INSENSITIVE, e.g.:
//---
PreparedStatement pstmt1 = connection.prepareStatement( "SELECT * FROM pub.customer WHERE CustNum >= ?",
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
//---