I have a problem when updating CSV files. I use the last version of HXTT CSV and integrate it with Hibernate
The situation is:
- I have a table with 24 rows
- I run a process that retrieves some of these rows and updates them
- When the process finishes, I see that before each row that has not been updated, around 300 blank lines have been inserted.
I need to solve this issue because I use these CSV files to load them into an Oracle DB using SQL Loader and these blank lines are provoking errors.
Is there any way of avoiding these blank lines to be generated or to delete them at the end of the process?
Update/delete operation will result blank line in CSV file. Those blank line can't be seen through HXTT CSV.
HXTT Text (CSV) is a pure Java drive, which can run in your Oracle DB VM.
If you wish to use other tool, you can use "create table anewfiile select * from oldfile".
"pack table yourTable".