Consultor Eletrônico



Kbase P12682: Loading a file > 2MB[JDBC Progress Driver]:String data, right truncated
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   11/3/2008
Status: Verified

SYMPTOM(s):

Writing to a LVARBINARY field.

Using jdbc call setBinaryStream(fileinputstream)

[JDBC Progress Driver]: String data, right truncated

FACT(s) (Environment):

Progress 9.1D
All Supported Operating Systems
OpenEdge SQL Category: JDBC Drivers

CAUSE:

LVARBINARY limit is 2MB. The Progress 9.1D SQL92 Guide and Reference states that the LVARBINARY limit is 2,000,000,000. LVARBINARY ( length ). The limit is actually 2,000,000.

CAUSE:

Bug #OE00083938

FIX:

Limit file size to < 2MB

The documentation has been corrected in OpenEdge 10.0B.