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
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Paradox v5.2
  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 Excel
Issue with the Excel Driver
sankar iyer
2009-07-09 07:52:31.0
We are getting the following error when we try running a query :

Failed to get a double value from java.lang.String: PINYX; CODE: 139264

The query is as follows :

select * from ( SELECT 1 OrderNo,max(FundName) Fundcategory,sum(1M_Rank) 1M_Rank,Sum(1M_Rank_Lip) 1M_Rank_Lip,sum(1m_Perc) 1M_Perc,sum(1M_Perc_Lip) 1M_Perc_Lip,sum(QTD_Rank) QTD_Rank,sum(QTD_Rank_Lip) QTD_Rank_Lip,sum(QTD_Perc) QTD_Perc,sum(QTD_Perc_Lip) QTD_Perc_Lip,sum(3M_Rank) 3M_Rank,sum(3M_Rank_Lip) 3M_Rank_Lip,sum(3M_Perc) 3M_Perc,sum(3M_Perc_Lip) 3M_Perc_Lip,sum(YTD_Rank) YTD_Rank,sum(YTD_Rank_Lip) YTD_Rank_Lip,sum(YTD_Perc) YTD_Perc,sum(YTD_Perc_Lip) YTD_Perc_Lip,sum(1Y_Rank) 1Y_Rank,sum(1Y_Rank_Lip) 1Y_Rank_Lip,sum(1Y_Perc) 1Y_Perc,sum(1Y_Perc_Lip) 1Y_Perc_Lip,sum(3Y_Rank) 3Y_Rank,sum(3Y_Rank_Lip) 3Y_Rank_Lip,sum(3Y_Perc) 3Y_Perc,sum(3Y_Perc_Lip) 3Y_Perc_Lip,sum(5Y_Rank) 5Y_Rank,sum(5Y_Rank_Lip) 5Y_Rank_Lip,sum(5Y_Perc) 5Y_Perc,sum(5Y_Perc_Lip) 5Y_Perc_Lip,sum(10Y_Rank) 10Y_Rank,sum(10Y_Rank_Lip) 10Y_Rank_Lip,sum(10Y_Perc) 10Y_Perc,sum(10Y_Perc_Lip) 10Y_Perc_Lip from (select FundName FundName,'' Category,1M_Rank, 0 1M_Rank_Lip,1M_Perc, 0 1M_Perc_Lip,QTD_Rank, 0 QTD_Rank_Lip,QTD_Perc, 0 QTD_Perc_Lip,3M_Rank, 0 3M_Rank_Lip,3M_Perc, 0 3M_Perc_Lip,YTD_Rank, 0 YTD_Rank_Lip,YTD_Perc, 0 YTD_Perc_Lip,1Y_Rank, 0 1Y_Rank_Lip,1Y_Perc, 0 1Y_Perc_Lip,3Y_Rank, 0 3Y_Rank_Lip,3Y_Perc, 0 3Y_Perc_Lip,5Y_Rank, 0 5Y_Rank_Lip,5Y_Perc, 0 5Y_Perc_Lip,10Y_Rank, 0 10Y_Rank_Lip,10Y_Perc, 0 10Y_Perc_Lip FROM LipperRank L1 WHERE L1.NASDAQ='PINYX' ) union SELECT 2 OrderNo,max(Category) Fundcategory ,sum(1M_Rank) 1M_Rank,sum(1M_Rank_Lip) 1M_Rank_Lip,sum(1M_Perc) 1M_Perc,sum(1M_Perc_Lip) 1M_Perc_Lip,sum(QTD_Rank) QTD_Rank,sum(QTD_Rank_Lip) QTD_Rank_Lip,sum(QTD_Perc) QTD_Perc,sum(QTD_Perc_Lip) QTD_Perc_Lip,sum(3M_Rank) 3M_Rank,sum(3M_Rank_Lip) 3M_Rank_Lip,sum(3M_Perc) 3M_Perc,sum(3M_Perc_Lip) 3M_Perc_Lip,sum(YTD_Rank) YTD_Rank,sum(YTD_Rank_Lip) YTD_Rank_Lip,sum(YTD_Perc) YTD_Perc,sum(YTD_Perc_Lip) YTD_Perc_Lip,sum(1Y_Rank) 1Y_Rank,sum(1Y_Rank_Lip) 1Y_Rank_Lip,sum(1Y_Perc) 1Y_Perc,sum(1Y_Perc_Lip) 1Y_Perc_Lip,sum(3Y_Rank) 3Y_Rank,sum(3Y_Rank_Lip) 3Y_Rank_Lip,sum(3Y_Perc) 3Y_Perc,sum(3Y_Perc_Lip) 3Y_Perc_Lip,sum(5Y_Rank) 5Y_Rank,sum(5Y_Rank_Lip) 5Y_Rank_Lip,sum(5Y_Perc) 5Y_Perc,sum(5Y_Perc_Lip) 5Y_Perc_Lip,sum(10Y_Rank) 10Y_Rank,sum(10Y_Rank_Lip) 10Y_Rank_Lip,sum(10Y_Perc) 10Y_Perc,sum(10Y_Perc_Lip) 10Y_Perc_Lip from (select FundName FundName,'' Category,1M_Rank, 0 1M_Rank_Lip,1M_Perc, 0 1M_Perc_Lip,QTD_Rank, 0 QTD_Rank_Lip,QTD_Perc, 0 QTD_Perc_Lip,3M_Rank, 0 3M_Rank_Lip,3M_Perc, 0 3M_Perc_Lip,YTD_Rank, 0 YTD_Rank_Lip,YTD_Perc, 0 YTD_Perc_Lip,1Y_Rank, 0 1Y_Rank_Lip,1Y_Perc, 0 1Y_Perc_Lip,3Y_Rank, 0 3Y_Rank_Lip,3Y_Perc, 0 3Y_Perc_Lip,5Y_Rank, 0 5Y_Rank_Lip,5Y_Perc, 0 5Y_Perc_Lip,10Y_Rank, 0 10Y_Rank_Lip,10Y_Perc, 0 10Y_Perc_Lip FROM LipperRank L1 WHERE L1.NASDAQ='PINYX' union select '' FundName,Category Category,0 1M_Rank, 1M_Rank 1M_Rank_Lip,0 1M_Perc, 1M_Perc 1M_Perc_Lip,0 QTD_Rank, QTD_Rank QTD_Rank_Lip,0 QTD_Perc, QTD_Perc QTD_Perc_Lip,0 3M_Rank, 3M_Rank 3M_Rank_Lip,0 3M_Perc, 3M_Perc 3M_Perc_Lip,0 YTD_Rank, YTD_Rank YTD_Rank_Lip,0 YTD_Perc, YTD_Perc YTD_Perc_Lip,0 1Y_Rank, 1Y_Rank 1Y_Rank_Lip,0 1Y_Perc, 1Y_Perc 1Y_Perc_Lip,0 3Y_Rank, 3Y_Rank 3Y_Rank_Lip,0 3Y_Perc, 3Y_Perc 3Y_Perc_Lip,0 5Y_Rank, 5Y_Rank 5Y_Rank_Lip,0 5Y_Perc, 5Y_Perc 5Y_Perc_Lip,0 10Y_Rank, 10Y_Rank 10Y_Rank_Lip,0 10Y_Perc, 10Y_Perc 10Y_Perc_Lip FROM LipperRank L2 WHERE L2.CategoryClass = (select distinct LipperClass FROM LipperRank L3 where L3.NASDAQ='PINYX')) )].

ERROR: Failed to get a double value from java.lang.String: PINYX; CODE: 139264
Not sure what would be a way to fix this..

Re:Issue with the Excel Driver
HXTT Support
2009-07-09 08:23:28.0
Try maxScanRows=0 connection property.
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

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