Kbase P30900: Java Exceptions when Executing a Query using JDBC connection.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.x
SYMPTOM(s):
Java Exceptions when Executing a Query using JDBC connection.
When executing a query the following error appear:
ERROR - Generating SQLException...
SQLException: SQLState(42S02) vendor code(-20005)
*PreparedStatement.close
Free statement (SQLFreeStmt), hStmt=665192, fOption=1
[JDBC Progress Driver]:Table/View/Synonym not found (7519)
CAUSE:
Tables created by 4GL are owned by the pub user account.
In that case the user account trying to access that tables was different
so using a different schema than pub.
FIX:
Use the prefix "pub." for accessing tables created by 4GL or set the schema to pub.
Example syntax : select name from pub.customer