Kbase P102933: JDBC request errors out with "invalid character value"
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
06/04/2005 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1B
SYMPTOM(s):
JDBC request errors out with "invalid character value"
SQLSTATE=22018
JDBC and ODBC configuration
Client uses the JDBC driver to query the Progress database
Client uses the ODBC driver to create the EDI (Electronic Data Interchange) Mapping between the client and the JDBC Driver
CAUSE:
The EDI Mapping was incorrect. There was a Progress Character field mapped to JDBC integer datatype.
FIX:
Create the correct EDI Mapping. The data types between the Progress Database and the EDI Mapping should match.