Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access 7.0.011
  HXTT Cobol 4.0.011
  HXTT DBF 7.0.011
  HXTT Excel 6.0.012
  HXTT Paradox 7.0.011
  HXTT PDF 1.1.011
  HXTT Text(CSV) 7.0.011
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Word 1.0.009
  HXTT XML 3.0.011
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)

HXTT Text(CSV)
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?

Thanks
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".
Or
"pack table yourTable".

Search Key   Search by Last 50 Questions




Google
 

Email: webmaster@hxtt.com
Copyright © 2003-2019 Heng Xing Tian Tai Lab of Xi'an City. | All Rights Reserved. | Privacy | Legal | Sitemap