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)
HXTTText has problems with quote
khaldoun Ateyeh
2006-08-01 12:40:53.0
Hello,

The HXTTText driver throws java.sql.SQLException: Invalid column when a column has " as a quote in the column name.

Regards.

K. Ateyeh
Re:HXTTText has problems with quote
HXTT Support
2006-08-02 06:14:38.0
You can use the follows sql:

select name [aaa"] from table1
Re:Re:HXTTText has problems with quote
khaldoun Ateyeh
2006-08-02 07:24:14.0
The problem is that in case that i the column name are quoted like "name" the driver consider the column name as "name" and not name.

Regards.
K. Ateyeh
Re:Re:Re:HXTTText has problems with quote
HXTT Support
2006-08-02 07:56:36.0
Please download the latest HXTT Text JDBC Package and try again.
If this problem happened yet,can you tell us your sql?

When i execute the follows sql,
select Name "Name" from table1

The column name is name and not "name"
Re:Re:Re:Re:HXTTText has problems with quote
khaldoun Ateyeh
2006-08-02 08:55:52.0
Hi,

i think, finally, i found the bug.

The Hxtttext driver provide rong results in this case:
when having a csv file that has ";" separator and one or more column names are quoted with " like "name" then this sql:
ResultSet rs = stmt.executeQuery("SELECT * FROM table");
ResultSetMetaData rsm = rs.getMetaData();
the rsm would include this: ""name"" instad of "name".

Regards.
K. Ateyeh
Re:Re:Re:Re:Re:HXTTText has problems with quote
HXTT Support
2006-08-06 21:47:07.0
It's not a bug.
If you use
url="jdbc:text:////f:/textfiles?_CSV_Separator=\\x3b;_CSV_Header=true;csvfileExtension=CSV;_CSV_Quoter=\";"
you will find that your issue disappear.

Without _CSV_Quoter=" property, HXTT CSV will think that your csv file with ";" separator hasn't quoter token. For standard csv file, it will check " token always.




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