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)
Strange error message
Remco Schoen
2009-10-28 05:15:37.0
I'm running a test to see how the driver handles wrong values in a column, for instance a string in a column with doubles.

I get this error:
Failed to go Record 40 of table number_not! For more information, please use SQLException.getNextException().
Failed to get an int value from [B: A

A is the string value, but what does "[B" mean? Should it be the column name or number?

Kind regards,

Remco Schoen
Re:Strange error message
HXTT Support
2009-10-29 04:39:18.0
>A is the string value, but what does "[B" mean? Should it be the column name
>or number?
It's a byte[] object. You can use ignoreDirtyData=true connection property to skip your wrong values.
Re:Re:Strange error message
Remco Schoen
2009-10-30 03:49:43.0
Okay, so the string "[B" stands for a byte[] object and not for a column indication. Is it possible to give information about the column at this stage?

We are testing to see what the driver does with wrong values. The ODBC driver from Microsoft just ignores these values, but we like to see them, so we can say to our customer that they have wrong values in their text-files.
Re:Re:Re:Strange error message
HXTT Support
2009-10-31 06:58:52.0
>>[B: A
>Is it possible to give information about the column at this stage?
[B means a byte[] object, A is the friendly string value. It wish an int value, but found a 'A' wrong value.
Re:Re:Re:Strange error message
HXTT Support
2009-10-31 07:06:15.0
>Is it possible to give information about the column at this stage?
Yeah. The latest package will prompt column, row, value inforamtion for wrong value.
Re:Re:Re:Re:Re:Strange error message
HXTT Support
2009-11-01 04:03:03.0
You can download the latest package now.
Re:Re:Re:Re:Re:Re:Strange error message
Remco Schoen
2009-11-02 01:58:10.0
Cool, it works, we get a user friendly message now.

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