Consultor Eletrônico



Kbase P96860: Trying to get the next result fails with java.sql.SQLException: [JDBC ProgressDriver]:1
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   02/11/2004
Status: Unverified

FACT(s) (Environment):

Progress 9.1D

SYMPTOM(s):

Trying to get the next result fails


resultset.next() returns SQLException


java.sql.SQLException: [JDBC ProgressDriver]:1


at com.progress.sql.jdbc.JdbcProgress.SQLFetch(JdbcProgress.java:2882)

at com.progress.sql.jdbc.JdbcProgressResultSet.next(JdbcProgressResultSet.java:

1522)

CAUSE:


No error code exists for just "1" for the Progress SQL-92 engine. Error code of SQLException is incomplete because of the exception logging code used:
} catch (SQLException e) {
log_error("SQLException", e);
throw new ApplicationRuntimeException(ERROR_SQL_EXCEPTION, e);

FIX:


Use SQLException.getErrorCode() method to retrieve a more informative error code