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
  Support
  Download
  Document
  FAQ
  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
   
   
   
Hongxin Technology & Trade Ltd. of Xiangtan City (abbr, HXTT)

HXTT Text(CSV)
HXTT Csv bug ?
Denny
2014-08-07 22:53:58.0
dear hxtt,

i think there is a bug in CSV driver regarding writing data inside ftp or smb
to reproduce the bug:

1. i have a csv file with three columns a,b,c
2. access this file with ftp or smb url
example:
jdbc:CSV:smb://user:user@localhost/c$/afolder?_CSV_Header=true;_CSV_Separator=\u002C;csvfileExtension=csv;_CSV_Quoter=\u0022;
or
jdbc:CSV:ftp://user:user@localhost?_CSV_Header=true;_CSV_Separator=\u007C;csvfileExtension=csv;_CSV_Quoter=\u0022;
3. execute: "insert into data1t values('1','2','3')"
4. the output row is only "2,3", missing out the first column and shifted all the data

this problem does not happen when i use local url example:
jdbc:CSV:////afolder?_CSV_Header=true;_CSV_Separator=\u002C;csvfileExtension=csv;_CSV_Quoter=\u0022
Re:HXTT Csv bug ?
HXTT Support
2014-08-08 22:48:46.0
That's resulted by SAMBA file can't get the correct file size in time.
2014-08-08 fixed an insert bug on SAMBA CSV file.
Re:Re:HXTT Csv bug ?
Denny
2014-08-09 05:24:39.0
Hello,

where can i download the fixed version ?

thank you
Re:Re:Re:HXTT Csv bug ?
HXTT Support
2014-08-09 05:36:26.0
Checked. Your version is too old, and you should click the Renew Support/Service link on your download page to get the latest version.
Re:Re:Re:Re:HXTT Csv bug ?
HXTT Support
2014-08-10 06:01:33.0
Now you can download the latest version.
Re:HXTT Csv bug ?
Denny
2014-08-10 09:40:53.0
Dear hxtt,

after repeating the test above using the new driver:
(http://www.hxtt.com/downloadagent.jsp?product=Text_JDBC40.jar)
Text JDBC 4.0 Package for JDK 1.6.X, JDK1.7.X, and JDK1.8.X 1,413Kb 2014-08-08 10:33

the result is not yet correct

1. i have a csv file with three columns a,b,c
2. access this file with ftp
jdbc:CSV:ftp://user:user@localhost?_CSV_Header=true;_CSV_Separator=\u007C;csvfileExtension=csv;_CSV_Quoter=\u0022;
3. execute: "insert into data1t values('1','2','3')"
4. the output file (data1t.csv) is not changed at all (viewed using notepad)
5. when query "select * from data1t" the result is:
column name: a,b,c1,2,3 --> data becomes new column
rows: 0 rows
6. repeating another insert command, the result stays like point 4 & 5
7. quit app
8. the file(data1t.csv) still not changed
9. has confirmed this is not permission problem, because i have tested to put a file using ftp client

can you give assistance ?

thank you

regards

Search Key   Search by Last 50 Questions




Google
 

Address: 9 Station Rd., Xiangtan City, Hunan Province, P.R. China
Postcode: 411100
Phone: (86)731-58225727
Fax: (86)731-58225727
Email: webmaster@hxtt.com
Copyright © 1999-2011 Hongxin Technology & Trade Ltd. | All Rights Reserved. | Privacy | Legal | Sitemap