Kbase P66420: Incorrect SqlState (53) associated with any error message on Unix
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
FACT(s) (Environment):
UNIX
SYMPTOM(s):
Incorrect SqlState (53) associated with any error message on Unix
For example, on error 7519, an incorrect SQLState is returned as follows:
=== SQL Exception 1 ===
SQLState=53
ErrorCode=-20005
[JDBC Progress Driver]:Table/View/Synonym not found (7519)
The correct SqlState associated to the error 7519 is 42S02 (and not 53).
CAUSE:
SqlState mismatched due to the failure of locating the message file (e.g JdbcProgress.po) by the Data Direct driver.
This could be caused by the wrong locale setting of the machine or the
incorrect OS configuration (because the Data Direct driver follows the POSIX
locale rule to locate the message files).
FIX:
Configure the driver to always have a default location for
message files (e.g $DLC/lib/locale/en_US/LC_MESSAGES/) when it fails based
on the current locale setting.
(Alternatively, try to create a symbolic link "C" under $DLC/lib/locale to point to $DLC/lib/locale/en_US and see if it fixes the issue.)