Consultor Eletrônico



Kbase P85957: SQLState error HYC00 with SQL-92 DatabaseMetaData.getTables() when using getTables()
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   16/10/2008
Status: Verified

FACT(s) (Environment):

OpenEdge 10.0A
OpenEdge 10.0B
All Supported Operating Systems

SYMPTOM(s):

SQL-92 getTables() fails with JDBC Progress Driver error

SQLState : HYC00
Message : [JDBC Progress Driver]:Optional feature not implemented.
Error code: 0

Problems with DatabaseMetaData.getTables() using getTables()

Same issue tested on the latest driver under OpenEdge 10.1A Program now fails with the exception:

SQLState : HY090
Message : [JDBC Progress Driver]: The qualifier "name" was larger than SQL_MAX_QUALIFIER_LEN from SQLGetInfo (0).
Error code: 0

CAUSE:

Bug# 20030415-010

FIX:

Upgrade to Progress 9.1E02 or later
OpenEdge 10.0B02 or later

Workaround: Pass a null value into the catalog parameter.