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:
FUID,EmployeeName,FirstName,LastName
FLAST,"Last, First",First,Last
JDUNN,"Dunn, John",John,Dunn
Now use the driver's test tool with the JDBC URL:
jdbc:csv:////temp?_CSV_Header=true;tmpdir=/temp
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:
jdbc:csv:////temp?_CSV_Header=true;_CSV_Quoter=";tmpdir=/temp
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.
thanks.
|
Don't worry. I misunderstand your requestion. The latest package will be available after about two hours.
|