Kbase P82963: Using prepared statements in Java and getting java.sql.SQLException: [JDBC Progress Driver]:1816044
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/3/2009 |
|
Status: Verified
SYMPTOM(s):
Using prepared statements in Java
When executing the prepared statement a Java exception is generated
java.sql.SQLException: [JDBC Progress Driver]:1816044
FACT(s) (Environment):
Progress 9.1D
CAUSE:
The error number is not being properly translated to an error description. The correct error description is that the string data was right truncated.
FIX:
Before setting the value of the parameters in the prepared statement ensure that when assigning a string value the length of the string value does not exceed the defined SQL WIDTH for the field in the database.