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

Issue selecting from a csv file with quoted data
Jim Ducharme
2010-12-01 11:03:21.0
We downloaded the 12/1/10 version of the driver and we are still seeing and issue with selecting data from a csv file where the data in the file is quoted. We have tested this using the build in test tool in the jar.

To reproduce:
Assuming the csv called fullnames.csv file located in my /temp directory:

FLAST,"Last, First",First,Last
JDUNN,"Dunn, John",John,Dunn

Now use the driver's test tool with the JDBC URL:

Run the sql:
select * from fullnames

The result window you will see:

2 rows of data:
The 2 FUID values are correct
EmployeeName values will be "Last and "Dunn
FirstName values will be First" and John"
LastName values will be First and John

Obviously this is not correct. The original version of this driver we used did not work this way. It would properly handle the quoted values in the file.

If I change the JDBC URL to be:

then it works fine but this requires that all of our customers and application configurations need to change simply because we upgraded the driver. This doesn't seem like something we should have to set a parameter for to handle properly.

These changes in the driver are causing a lot of issues with our customers so if you could please investigate ASAP we would appreciate it. We really do not want to have to have to re-configure every database connection URL we have using this driver for something that seems like we shouldn't need a config property for.

Re:Issue selecting from a csv file with quoted data
HXTT Support
2010-12-01 16:16:36.0
Don't worry. I misunderstand your requestion. The latest package will be available after about two hours.

Search Key   Search by Last 50 Questions


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