Kbase P40632: Java SQL92 Cursor problem
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/25/2010 |
|
Status: Unverified
SYMPTOM(s):
Java SQL92 Cursor problem
[JDBC Progress Driver]:Cursor not opened (7511)
ConnectionReadOnly=false
getTransactionIsolation=2
getDatabaseProductName=PROGRESS
getDatabaseProductVersion=09.1D05
getDriverMajorVersion=1
getDriverMinorVersion=1000
getDriverName=JDBC-PROGRESS (JdbcProgress.dll)
getDriverVersion=1.1000 (03.60.0000)
query=SELECT xkonto.* FROM pub.xkontoz, pub.xkonto WHERE xkontoz.xfirmaref = 'xf
irma^1' and xkontoz.kontozstat < 91 and xkontoz.kontozvera = 'K' and xkonto.xkon
toref = xkontoz.xkontoref ORDER BY xkonto.xkontoref
xkonto #=50
java.sql.SQLException: [JDBC Progress Driver]:Cursor not opened (7511)
at com.progress.sql.jdbc.JdbcProgress.createSQLException(JdbcProgress.ja
va:6562)
at com.progress.sql.jdbc.JdbcProgress.standardError(JdbcProgress.java:67
36)
at com.progress.sql.jdbc.JdbcProgress.SQLFetch(JdbcProgress.java:2829)
at com.progress.sql.jdbc.JdbcProgressResultSet.next(JdbcProgressResultSe
t.java:1519)
at ProgressCursorBug.main(ProgressCursorbug.java:56)
CAUSE:
Bug# OE00094455
FIX:
Upgrade to Progress 9.1E or later
Upgrade to OpenEdge 10.0B or later
A possible workaround is to create an Index (ex: from DataDictionary) which contains the "fieldName" used in the ORDER BY. Since it is the generated Temp Table which has the bug when freed at an improper time and gives the error.