Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v7.1
  HXTT Cobol v5.0
  HXTT DBF v7.1
  HXTT Excel v6.1
  HXTT Json v1.0
  HXTT Paradox v7.1
  HXTT PDF v2.0
  HXTT Text(CSV) v7.1
  Buy Now
  HXTT Word v1.1
  HXTT XML v4.0
Offshore Outsourcing
Free Resources
  Firewall Tunneling
  Search Indexing Robot
  Conditional Compilation
  Password Recovery for MS Access
  Password Recovery for Corel Paradox
  Checksum Tool for MD5
  Character Set Converter
  Pyramid - Poker of ZYH
Heng Xing Tian Tai Lab of Xi'an City (abbr, HXTT)

Insertion of blank lines on batch update
Carmen Rodriguez
2016-02-22 03:50:17
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?

Re:Insertion of blank lines on batch update
HXTT Support
2016-02-22 04:17:00
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".

Search Key   Search by Last 50 Questions


Copyright © 2003-2019 Heng Xing Tian Tai Lab of Xi'an City. | All Rights Reserved. | Privacy | Legal | Sitemap