data exception: string data, right truncation
A pure Java JDBC driver for Microsoft Access database files
Brought to you by:
jamadei
Menu
▾
▴
Hi,
I receive the following exception:
UCAExc:::5.0.0 data exception: string data, right truncation; table: T_IMAGE column: IMAGE
The column IMAGE in table T_IMAGE is defined as LONGBINARY(1073741823), the longest value has 26132044 bytes, so there is no reason for that.
Using the parameters "memory=false;lobScale=32" changes the exception to:
UCAExc:::5.0.0 Data cache size limit is reached: 10000
Version of the Access-DB is 3.5, it's about 500MB of size.
Greetings,
Stefan