UCAExc:::4.0.4.1 string data, right truncation;

A pure Java JDBC driver for Microsoft Access database files

Brought to you by: jamadei

UCAExc:::4.0.4.1 string data, right truncation;

Forum: General Discussion

Creator: Pramodh

Created: 2019-04-03

Updated: 2019-04-05

Pramodh - 2019-04-03

I am loading data from MDB to process records. As UCANACCESS load those records into hsqldb before loading records into resultset, i'm getting "UCAExc:::4.0.4.1 data exception: string data, right truncation" error.

My column type is text and length is fixed to 4. Also, my column values didn't cross the limit as it will not allow more than that and values are exact 4 characters. But, i am unable to understand, why i m getting data truncation error.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Pramodh - 2019-04-03

Most of the columns in the table have same limit and all the columns have same issue. I cannot increase limit as it throwing error of database size issue.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Gord Thompson - 2019-04-04

Might this be an Access_97-format .mdb file by chance?

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Pramodh - 2019-04-05

Yeah.. It is 97 format mdb.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Gord Thompson - 2019-04-05

You've encountered this Jackcess bug. Try using Jackcess 2.2.3.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Log in to post a comment.