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)

HXTTText has problems with quote
khaldoun Ateyeh
2006-08-01 12:40:53.0

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


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.

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

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".

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


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