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
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Text(CSV) v5.2
  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 Paradox
Failed to get an int object from java.lang.String: 130-8560
Tarit
2015-12-10 22:02:13.0
Hi.. I am using trail version of HXTT using Excel_JDBC30.jar for my project. We are intended to buy the license also. But i am getting error while getting the value 130-8560 from a column POST_CODE (General data type) ,this column is mostly having numeric values but while getting value 130-8560 , system abends.
Below is the stack trace -
Caused by: java.sql.SQLException: Failed to get an int object from java.lang.String: 130-8560
at com.hxtt.global.SQLState.SQLException(Unknown Source)
at com.hxtt.global.SQLState.transferValueException(Unknown Source)
at com.hxtt.global.al.b(Unknown Source)
at com.hxtt.sql.common.e.getObject(Unknown Source)

Please help as soon as possible , because of this limitation we would not be able to go ahead with purchasing the license.
Failed to get an int object from java.lang.String: 130-8560
Tarit
2015-12-10 23:16:17.0
We are using the trail version of HXTT (Excel_JDBC30.jar) , though it is working fine with our earlier problem with reading turkish characters but when reading column value 130-8560 , it is throwing exception.

We have a column named POST_CODE(DATA TYPE - GENERAL) , having values like (34394,110-858) , for values having '-' , system is abending.
Below is exception--

Caused by: java.sql.SQLException: Failed to get an int object from java.lang.String: 130-8560
at com.hxtt.global.SQLState.SQLException(Unknown Source)
at com.hxtt.global.SQLState.transferValueException(Unknown Source)
at com.hxtt.global.al.b(Unknown Source)
at com.hxtt.sql.common.e.getObject(Unknown Source)
at com.csc.sics.mtk.etl.io.jdbc.JdbcTypesConverter.getObject(JdbcTypesConverter.java:40)
at com.csc.sics.mtk.etl.io.jdbc.ResultSetManager.getRow(ResultSetManager.java:135)
... 17 more

Please help us in this issue , because of this issue we have put an hold on buying the license version of HXTT.
Re:Re:Failed to get an int object from java.lang.String: 130-8560
HXTT Support
2015-12-11 05:29:08.0
maxScanRows Default value=10
You can use maxScanRows=0 or maxScanRows=-1 connection property.
Re:Re:Re:Failed to get an int object from java.lang.String: 130-8560
tarit gupta
2015-12-13 21:24:43.0
I have a property file , i load connect details from it , i have added new parameter maxScanRows to it , but still it is not working

jdbc.driver=com.hxtt.sql.excel.ExcelDriver
jdbc.url=jdbc:Excel:///C:/SICS_Update/Migration/Mapping_Data/BP/BUSINESS PARTNERS MASTER.xlsx
maxScanRows=0

but still i am getting above exception (in previous post).
Re:Re:Re:Re:Failed to get an int object from java.lang.String: 130-8560
HXTT Support
2015-12-14 21:13:26.0
BUSINESS PARTNERS MASTER.xlsx?maxScanRows=0
Re:Re:Re:Re:Re:Failed to get an int object from java.lang.String: 130-8560
Tarit
2015-12-14 23:19:25.0
Thanks , Above problem is resolved with maxScanRows but still I have 2 questions -
1) Does hxtt driver support reading data from .xlsb (Excel binary) file ?
2) What is use of maxScanRows and how does it solve the problem ?
Re:Re:Re:Re:Re:Re:Failed to get an int object from java.lang.String: 130-8560
HXTT Support
2015-12-17 04:43:57.0
>1) Does hxtt driver support reading data from .xlsb (Excel binary) file ?
Doesn't support.

>2) What is use of maxScanRows and how does it solve the problem ?
At http://www.hxtt.com/excel/installation.html#url ,
maxScanRows: Indicates how many rows should be scanned when determining the column types. If you set maxScanRows to 0, the entire file is scanned. If you set maxScanRows to a negative value, the file won't be scanned. Default value: 10
Re:Re:Re:Re:Re:Re:Re:Failed to get an int object from java.lang.String: 130-8560
tarit
2015-12-17 22:50:11.0
Thanks

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