Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v7.1
  HXTT Cobol v5.0
  HXTT DBF v7.1
  HXTT Excel v6.1
  HXTT Json v1.0
  HXTT Paradox v7.1
  HXTT PDF v2.0
  HXTT Text(CSV) v7.1
  Buy Now
  HXTT Word v1.1
  HXTT XML v4.0
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