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)

Difference in driver behavior with quotes in column headers
Jim Ducharme
2010-10-28 09:01:35.0
Our product has been using a pretty old version of the HXTT text(CSV) driver for JDBC 3.0.

Our automaton tests that test our product include a number of tests that load data using this text driver. Since upgrading to a recent version of the driver (4.2.172 released on 9/9/10) our automation tests are now failing because of a driver issue caused by our CSV files having quotes in the header names.

With the old version of the driver, it would properly strip the quotes out of the column name. Now it appears that the quote is being preserved as part of the column name. Documentation states that we need to add a property "_CSV_Quoter" to our JDBC URL. When we do that, the data, and our automation tests, work properly.

Having said that, we are concerened because of the change in behavior. Now we have to go adjust all of our automation with this new paramenter when we see this as a change in behavior of the driver. I can understand adding new behaviors with new parameters but did we do something wrong here such that the driver is behaving differently?

Was this change in behavior intended in the driver? If not, can we please get a new version of the driver where this original behavior doesn't change?

Overall, it seems strange that the column name would be returned with quotes in it as that really doesn't seem very valid.
Re:Difference in driver behavior with quotes in column headers
HXTT Support
2010-10-28 20:36:16.0
>Overall, it seems strange that the column name would be returned with quotes
That's resulted by changed the default value for _CSV_Quoter connection property. Please download the latest package which will detected it even if _CSV_Quoter haven't been set. Thanks for your response:)
Re:Re:Difference in driver behavior with quotes in column headers
Jim Ducharme
2010-11-17 07:18:05.0
We downloaded the latest version of the driver and here are the issues we are still seeing and it's not limited to the headers as my subject suggests. We have tested this using the build in test tool in the jar. We are using version 4.2.185 on October 29, 2010.

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 * 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:

This doesn't seem to help in your test tool anyway.

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:Re:Re:Difference in driver behavior with quotes in column headers
HXTT Support
2010-12-01 17:55:04.0
Sorry for missed that thread. Supported now. Please download the latest package.

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