Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v6.0
  HXTT Cobol v3.0
  HXTT DBF v6.0
  HXTT Excel v5.0
  HXTT Paradox v6.0
  HXTT Text(CSV) v6.0
  Buy Now
  HXTT XML v2.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 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 Xing Tian Tai Lab of Beijing City. | All Rights Reserved. | Privacy | Legal | Sitemap