KBoersch opened a new issue, #2867: URL: https://github.com/apache/hop/issues/2867
### Apache Hop version? 2.4.0 ### Java version? OpenJDK 11.0.16.1 ### Operating system Windows ### What happened? When I try to load some data in a access-db via ms access output transform, the transform will set the field length for text fields to 1, no matter what length is set in the row-meta-data before. That causes the following error: > 2023/04/26 11:13:45 - Microsoft Access output.0 - ERROR: Error closing the database: com.healthmarketscience.jackcess.BatchUpdateException: Failed adding rows (Db=test.accdb;Table=test): com.healthmarketscience.jackcess.InvalidValueException: Text is wrong length for TEXT column, max 1, min 0, got 15 (Db=test.accdb;Table=test;Column=test1) To give you a simple example, I just generated some rows and tried to put them into a accdb-file. Pipeline and generated db are attached. Also after the first creation of the db, hop throws the following error, when I try to run the pipeline again, immediately after deleting the db. I've to wait some time, until it works again. Seems to me, that hop doesn't close the connection after executing the pipeline. > 2023/04/26 11:11:37 - Microsoft Access output.0 - Writing access database to file 'P:/Entwicklung/projects/HOP-AT\test.accdb'. > 2023/04/26 11:11:37 - Microsoft Access output.0 - ERROR: An error occurred intialising this transformation: P:\Entwicklung\projects\HOP-AT\test.accdb > 2023/04/26 11:11:37 - Microsoft Access output.0 - ERROR: There was an unexpected error while creating a table: java.lang.NullPointerException: Cannot invoke "com.healthmarketscience.jackcess.Database.getTable(String)" because "this.data.db" is null. > 2023/04/26 11:11:37 - Microsoft Access output.0 - ERROR: java.lang.NullPointerException: Cannot invoke "com.healthmarketscience.jackcess.Database.getTable(String)" because "this.data.db" is null > 2023/04/26 11:11:37 - Microsoft Access output.0 - at org.apache.hop.pipeline.transforms.accessoutput.AccessOutput.writeToTable(AccessOutput.java:117) > 2023/04/26 11:11:37 - Microsoft Access output.0 - at org.apache.hop.pipeline.transforms.accessoutput.AccessOutput.processRow(AccessOutput.java:83) > 2023/04/26 11:11:37 - Microsoft Access output.0 - at org.apache.hop.pipeline.transform.RunThread.run(RunThread.java:55) > 2023/04/26 11:11:37 - Microsoft Access output.0 - at java.base/java.lang.Thread.run(Thread.java:833) > 2023/04/26 11:11:37 - Microsoft Access output.0 - Finished processing (I=0, O=0, R=1, W=0, U=0, E=1) [accessExamples.zip](https://github.com/apache/hop/files/11331162/accessExamples.zip) ### Issue Priority Priority: 2 ### Issue Component Component: Transforms -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
