Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access 7.1.137
  HXTT Cobol 5.0.137
  HXTT DBF 7.1.138
  HXTT Excel 6.1.141
  HXTT Json 1.0.109
  HXTT Paradox 7.1.137
  HXTT PDF 2.0.137
  HXTT Text(CSV) 7.1.137
  Buy Now
  HXTT Word 1.1.137
  HXTT XML 4.0.138
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)

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


Copyright © 2003-2019 Heng Xing Tian Tai Lab of Xi'an City. | All Rights Reserved. | Privacy | Legal | Sitemap