Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v5.2
  HXTT Cobol v2.1
  HXTT DBF v5.2
  HXTT Excel v4.2
  HXTT Paradox v5.2
  HXTT Text(CSV) v5.2
  Buy Now
  HXTT XML v1.2
Offshore Outsourcing
Oracle Data Import/Export
DB2 Data Import/Export
Sybase Data Import/Export
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 Xin Tian Tai Ltd. of Beijing City (abbr, HXTT)

Insertion of blank lines on batch update
Carmen Rodriguez
2016-02-22 03:50:17.0
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.0
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 © 1999-2017 Heng Xin Tian Tai Ltd. of Beijing City. | All Rights Reserved. | Privacy | Legal | Sitemap