We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.

License File Locations in Data360 Analyze
Data360 Analyze: How to restore from a backup on Windows
Adding custom data types for detection within Data Profiler node
How to create large volumes of sample data
Data360 Analyze: How to bypass a node with zero records
How to add MMDD to a file in Data360 Analyze
How to change the webapp port in Data360 Analyze
D360 Analyze: How to remove /delete a column or row if all values are null
How to Change the Http port without re-installating the Data3Sixty Analyze (Linux)
Data360 Analyze: How to get a jstack in Windows and Linux - Server Installations

Error Connecting to MS Access via JDBC to Unicode Data

Adrian Williams

October 03, 2019 18:10
Updated

Symptom:

When using the JDBC Node to connect to MS Access to access unicode data, this error can occur:

ERROR: Input length = 1
ERROR: error on row 0, com.lavastorm.io.data.FieldWritingException:Error occurred writing the field (text), type (class java.lang.String) on record (<nnnn>). Field had the value (<field_value>)

Solution:

Set the Optional->DefaultToUnicode parameter to 'true' on the JDBC Query node.

Comments

0 comments

Please sign in to leave a comment.

Articles in this section

Related articles